Treceți la conținutul principal

o aplicatie complexa firme php

//adaufaref.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<!--
   HTML 3.2
   Document type as defined on http://www.w3.org/TR/REC-html32
-->
<head>
       <title>adaugare firma</title>

</head>

<?
//inceput forma
print '<center>
<body bgcolor="silver">
<form action="adaugaf.php" method ="POST">
<label for="firma">Denumire compania </label><br>
<input type="text" name="firma" value="denumire firma"><br>
<label for="datef">Datele companiei </label><br>
<textarea rows=5 cols=40 wrap="off" name="datef"></textarea><br>';
?>
<?
//conectare baza de date
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//initiere variabila comanda mysql
$sqlb = "SELECT sudomeniul,id_subdo FROM subdomeniu";
$resursab = MYSQL_QUERY($sqlb);

print '<label for="id_do">Alege un subdomeniu:</label><br>
<SELECT NAME="id_subdo">';
// printare selectare domeniu
while($row = mysql_fetch_array($resursab))
{
 print '<option value="'.$row['id_subdo'].'">'.$row['subdomeniul'].'</option>';
}

print '</select><br>
<input type="submit" value="Adauga firma">';
?>
</form>

</body>
</html>



//adaugaredo.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Conectare dtpt</title>
</head>
<body>
<?php
//afisare din cadrul resursei returnate
//a tutror datelor dintr-o tabela
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//conectare
$sql = "insert into domeniu(domeniul) values('".$_POST['domeniul']."')";;
mysql_query($sql);
//stabilire comanda mysql in variabile
?>
<a href="conectare.php" title="vezi toate domeniile">verificare adaugare domeniu</a>
<a href="domeniu.php" title="adaugare domenii">adaugare inca un domeniu</a>
</body>
</html>


//adaugaref.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>adaugarecarteB.php</title>
</head>
<body>
<?php
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");

$sql ="insert into firme (id_subdo, firma, datefirma) values(
'".$_POST['id_subdo']."','".$_POST['firma']."','".$POST['datef']."')";
mysql_query($sql);
?>

<a href="firme.php">Vezi modificarea!</a>
<br>
<a href="adaugaref2.php">Adauga inca o firma!</a>

</body>
</html>
//adaugaref2.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<!--
   HTML 3.2
   Document type as defined on http://www.w3.org/TR/REC-html32
-->
<head>
       <title>adaugare firma</title>

</head>

<?
//inceput forma
print '<center>
<body bgcolor="silver">
<form action="adaugaref.php" method ="POST">
<label for="firma">Denumire compania </label><br>
<input type="text" name="firma" value="denumire firma"><br>
<label for="datef">Datele companiei </label><br>
<input type="text" name="datef" value="date firma"><br>';
?>
<?
//conectare baza de date
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//initiere variabila comanda mysql
$sqlb = "SELECT * FROM subdomeniu order by id_do";
$resursab = MYSQL_QUERY($sqlb);

print '<label for="id_subdo">Alege un subdomeniu:</label><br>
<SELECT NAME="id_subdo">';
// printare selectare domeniu
while($row = mysql_fetch_array($resursab))
{
 print '<option value="'.$row['id_subdo']
 .'">'.$row['subdomeniul'].'</option>';
}

print '</select><br>
<input type="submit" value="Adauga firma">';
?>
</form>

</body>
</html>
//adaugaref2beta.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<!--
   HTML 3.2
   Document type as defined on http://www.w3.org/TR/REC-html32
-->
<head>
       <title>adaugare firma</title>

</head>

<?
//inceput forma
print '<center>
<body bgcolor="silver">
<form action="adaugaref.php" method ="POST">
<label for="firma">Denumire compania </label><br>
<input type="text" name="firma" value="denumire firma"><br>
<label for="datef">Datele companiei </label><br>
<input type="text" name="datef" value="date firma"><br>';
?>
<?
//conectare baza de date
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//initiere variabila comanda mysql
$sqlb = "SELECT subdomeniu.id_do ,subdomeniu.subdomeniul, subdomeniu.id_subdo
,domeniu.id_do, domeniu.domeniul FROM subdomeniu , domeniu where subdomeniu.id_do
= domeniu.id_do order by subdomeniu.id_do";
$resursab = MYSQL_QUERY($sqlb);

print '<label for="id_subdo">Alege un subdomeniu:</label><br>
<SELECT NAME="id_subdo">';
// printare selectare domeniu
while($row = mysql_fetch_array($resursab))
{
 print '<option value="'.$row['id_subdo'].'">'.
 $row['subdomeniul'].'-'.$row['domeniul'].'</option>';
}
//'"intre'.'ghilimele"'.'="intre ghilimele"'
print '</select><br>
<input type="submit" value="Adauga firma">';
?>
</form>

</body>
</html>
//add_branse.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Adaugare branse de activitate</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
<script LANGUAGE="JavaScript">
<!-- Hide from older Browsers
function Locat()
{
location="index.php"

alert('Daca doriti sa reveniti apasati BACK!')
}
//Done Hiding-->
</script>


</head>
<body>

<h1>Adaugare branse de activitate</h1>
<?php
INCLUDE("meniu.php");
?>


<table>
<tr>
<td >
<form action="cmd_add_branse.php" method="POST" id=form1 name=form1>

<label for="nume_branse" id="lblnume_branse">Nume_branse:</label><br>
<input id="nume_branse" name="nume_branse" maxlength="40" size="40">

</td>
</tr>
<tr>
<td >
<center>
<INPUT type=submit value=Adauga id=submit1 name=submit1>
<INPUT type=reset value=Renunta id=reset1 name=reset1>
<center>
</FORM>
<td>
<tr>

</table>


</body>
</html>

//add_domeniu.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Adaugare domeniu de actiitate</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>
<?php
INCLUDE("conn_dtpt.php");
$sql = " SELECT * FROM branse ";
$resursa = mysql_query($sql);
?>

<h1>Adaugare domeniu de activitate</h1>

<?php
INCLUDE("meniu.php");
?><br>
<form action="cmd_add_domeniu.php" method="POST" id=form1 name=form1>
<label for="idbranse" id="lblnume_branse">Nume_branse:</label><br>
<?php
print "<select name='idbransa' width='40'> ";
while($row = mysql_fetch_array($resursa))
{
 print "<option value='".$row['id_branse']."'>"
 .$row['nume_branse']."</option>";
}
print "</select>";
?>
<br>
<label for="nume_domeniu" id="lblnume_domeniu">Nume_domeniu:</label><br>
<input id="nume_domeniu" name="nume_domeniu" maxlength="40" size="40">

</td>
</tr>
<tr>
<td >
<br>
<INPUT type=submit value=Adauga id=submit1 name=submit1>
<INPUT type=reset value=Renunta id=reset1 name=reset1>


</FORM>
<td>
<tr>

</table>

</body>
</html>

//add_firma.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Adaugare firma</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>


<?php
INCLUDE("conn_dtpt.php");
$sqlb = "SELECT * FROM branse";
$resursab = mysql_query($sqlb);
$sqld = "SELECT * FROM domeniu";
$resursad = mysql_query($sqld);
$sqls = "SELECT * FROM subdomeniu";
$resursas = mysql_query($sqls);

?>

<h1>Adaugare firme</h1>

<?php
INCLUDE("meniu.php");
?>

<form action="cmd_add_firma.php" method="POST" id=form1 name=form1>
<label for="idbranse" id="lblnume_branse">Nume_branse:</label><br>
<?php
print "<select name='idbranse' width='40'> ";
while($rowb = mysql_fetch_array($resursab))
{
 print "<option value='".$rowb['id_branse']."'>"
 .$rowb['nume_branse']."</option>";
}
print "</select>";
?>
<br>

<label for="iddomeniu" id="lblnume_domeniu">Nume_domeniu:</label><br>
<?php
print "<select name='iddomeniu' width='40'> ";
while($rowd = mysql_fetch_array($resursad))
{
 print "<option value='".$rowd['id_domeniu']."'>"
 .$rowd['nume_domeniu']."</option>";
}
print "</select>";
?>
<br>
<label for="idsubdomeniu" id="lblnume_subdomeniu">Nume_subdomeniu:</label><br>
<?php
print "<select name='idsubdomeniu' width='40'> ";
while($rows = mysql_fetch_array($resursas))
{
 print "<option value='".$rows['id_subdomeniu']."'>"
 .$rows['nume_subdomeniu']."</option>";
}
print "</select>";
?>


<br>
<br>
<fieldset><legend>Date firma:</legend>
<label for="nume_firma" id="lblnume_firma">Nume_firma:</label><br>
<input id="nume_firma" name="nume_firma" maxlength="50" size="50"><br>

<label for="strada" id="lblstrada">Strada:</label><br>
<input id="strada" name="strada" maxlength="25" size="25"><br>

<label for="nr" id="lblnr">Nr:</label><br>
<input id="nr" name="nr" maxlength="10" size="10"><br>

<label for="bloc" id="lblbloc">Bloc:</label><br>
<input id="bloc" name="bloc" maxlength="10" size="10"><br>

<label for="apartament" id="lblapartament">Apartament:</label><br>
<input id="apartament" name="apartament" maxlength="10" size="10"><br>

<label for="telefon" id="lbltelefon">Telefon:</label><br>
<input id="telefon" name="telefon" maxlength="15" size="15"><br>

<label for="oras" id="lbloras">Oras:</label><br>
<input id="oras" name="oras" maxlength="50" size="50"><br>

<label for="judet" id="lbljudet">Judet:</label><br>
<input id="judet" name="judet" maxlength="30" size="30"><br>

<label for="cod_postal" id="lblcod_postal">Cod_postal:</label><br>
<input id="cod_postal" name="cod_postal" maxlength="6" size="6"><br>

<label for="mobil" id="lblmobil">Mobil:</label><br>
<input id="mobil" name="mobil" maxlength="15" size="15"><br>

<label for="adresa_email" id="lbladresa_email">Adresa_email:</label><br>
<input id="adresa_email" name="adresa_email" maxlength="50" size="50"><br>

<label for="adresa_web" id="lbladresa_web">Adresa_web:</label><br>
<input id="adresa_web" name="adresa_web" maxlength="50" size="50"><br>

<label for="cf" id="lblcf">CF:</label><br>
<input id="cf" name="cf" maxlength="15" size="15">

</fieldset>
</td>
</tr>
<tr>
<td >
<br>
<INPUT type=submit value=Adauga id=submit1 name=submit1>
<INPUT type=reset value=Renunta id=reset1 name=reset1>


</FORM>
<td>
<tr>

</table>

</body>
</html>

//add_subdomeniu.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Adaugare subdomeniu de activitate</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>


<?php
INCLUDE("conn_dtpt.php");
$sqlb = "SELECT * FROM branse";
$resursab = mysql_query($sqlb);
$sqls = "SELECT * FROM domeniu";
$resursas = mysql_query($sqls);
?>

<h1>Adaugare subdomeniu de activitate</h1>

<?php
INCLUDE("meniu.php");
?><br>


<form action="cmd_add_subdomeniu.php" method="POST" id=form1 name=form1>
<label for="idbranse" id="lblnume_branse">Nume_branse:</label><br>
<?php
print "<select name='idbranse' width='40'> ";
while($rowb = mysql_fetch_array($resursab))
{
 print "<option value='".$rowb['id_branse']."'>"
 .$rowb['nume_branse']."</option>";
}
print "</select>";
?>
<br>

<label for="idbranse" id="lblnume_branse">Nume_domeniu:</label><br>
<?php
print "<select name='iddomeniu' width='40'> ";
while($rows = mysql_fetch_array($resursas))
{
 print "<option value='".$rows['id_domeniu']."'>"
 .$rows['nume_domeniu']."</option>";
}
print "</select>";
?>




<br>
<label for="nume_subdomeniu" id="lblnume_subdomeniu">Nume_subdomeniu:</label><br>
<input id="nume_subdomeniu" name="nume_subdomeniu" maxlength="40" size="40">

</td>
</tr>
<tr>
<td >
<br>
<INPUT type=submit value=Adauga id=submit1 name=submit1>
<INPUT type=reset value=Renunta id=reset1 name=reset1>


</FORM>
<td>
<tr>

</table>

</body>
</html>



//barabtn.php

<form action="setrecordset.php" method="POST" class="forma" name="setdeinr">

<hr>
<input type="submit" value="|<" id="top" name="inceput" title="la inceput">
<input type="submit" value="<" id="prev" name="inapoi" title="inapoi">
<label  name="nrcurent"><?=$nrrand+1?> din <?=$nrinr?></label>
<input type="submit" value=">" id="next" name="inainte" title="inainte">
<input type="submit" value=">|" id="bottom" name="sfarsit" title="la sfarsit">
<b>|</b>
<input type="submit" value="del" id="del" name="sterge" title="sterge">
<a href="add_branse.php">Ins</a>
<input type="submit" value="save" id="save" name="salveaza" title="salveaza">
<input type="submit" value="help" id="help" name="ajutor" title="ajutor">
<input type="hidden" value="<?=$nrrand?>" name="nrcurent" >
</form>

</body>
</html>

//branse.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Listare branse</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>
<h1>Listare branse</h1>
<?php
INCLUDE("meniu.php");
?><br>
<?php
INCLUDE("conn_dtpt.php");
$sql = " SELECT * FROM branse ";
$resursa = mysql_query($sql);
print "<table>";
while($row = mysql_fetch_array($resursa))
{
 print "<tr><td bgcolor='silver'>".$row['id_branse']."
 </td><td bgcolor='silver'><a href='domenii.php?id_branse=".$row['id_branse'].
 "'>".$row['nume_branse']."</a></td></tr>";
}
print "</table>";
?>
</body>
</html>
//cautare.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Cautare!</title>
  <LINK REL=StyleSheet HREF="dtpt.css" TITLE="" TYPE="text/css">
  <script language="javascript">
  function helpme(){
    window.status=' Alegeti ... pentru a va intoarce !';
 }
 
 function statusre() {
 window.status='::Microsoft Windows Explorer::De.Toate.Pentru.Toti.::';
 }


 </script>
</head>
<body>



<br>
<form action="cautare.php" method="POST" id="frmCautare" name="frmCautare">

<h1>Cautare</h1>
<?php
                 error_reporting (E_ALL ^ E_NOTICE); 
INCLUDE("meniu.php");
INCLUDE("conn_dtpt.php");
?>



<Table>
<tr>
<td >
Branse:
</td>
<td>
<?php
$sqlb = "select *, count(*) as nrdo from domeniu , branse
where branse.id_branse = domeniu.id_branse group by branse.id_branse";
$resursab = mysql_query($sqlb);
?>
<select id="branse" name="branse" class="selectare" onmouseover="helpme();" onmouseout="statusre();">

<option>...</option>
<?php

IF(ISSET($_POST['btnBranse']) && ($_POST['branse'] != "...")||
($_POST['btnDomeniu']) && ($_POST['branse'] != "...")||
($_POST['btnSubdomeniu']) && ($_POST['branse'] != "...")||
($_POST['btnFirma']) && ($_POST['branse'] != "..."))
{
 $sqlsel = "select * from branse where id_branse = ".$_POST['branse'];
 $resursasel = mysql_query($sqlsel);
 $rez = mysql_fetch_array($resursasel);
 print "<option value='".$_POST['branse']."' selected>"
 .$rez['nume_branse']."</option>";
}

else
{
while($rowb = mysql_fetch_array($resursab))
{
 print "<option value='".$rowb['id_branse']."'> [ ".$rowb['nrdo']." ] "
 .$rowb['nume_branse']."</option>";
}
}
?>
</select>
<input type="submit" name="btnBranse" value="GO!"
alt="Cautare branse" id="btnBranse">
</td>
</tr>

<tr>
<td>
Domeniul:</td>
<td>
<?php
$sqld = "select * , count(*) as nrsubdo from domeniu ,subdomeniu WHERE
domeniu.id_branse = ".$_POST['branse']." and
domeniu.id_domeniu = subdomeniu.id_domeniu
group BY domeniu.id_domeniu";
$resursad = mysql_query($sqld);
?>
<select id="domeniul" name="domeniul" class="selectare" onmouseover="helpme();" onmouseout="statusre();">
<option>...</option>
<?php
IF(ISSET($_POST['btnDomeniu']) && ($_POST['domeniul'] != "...")||
($_POST['btnBranse']) && ($_POST['domeniul'] != "...")||
($_POST['btnSubdomeniu']) && ($_POST['domeniul'] != "...")||
($_POST['btnFirma']) && ($_POST['domeniul'] != "..."))
{
 $sqlseld = "select * from domeniu where id_domeniu = ".$_POST['domeniul'];
 $resursaseld = mysql_query($sqlseld);
 $rezd = mysql_fetch_array($resursaseld);
 print "<option value='".$_POST['domeniul']."' selected>"
 .$rezd['nume_domeniu']."</option>";
}
else
{
while($rowd = mysql_fetch_array($resursad))
{
 print "<option value='".$rowd['id_domeniu']."'> [ ".$rowd['nrsubdo']." ] "
 .$rowd['nume_domeniu']."</option>";
}
}
?>
</select>
<input type="submit" name="btnDomeniu" value="GO!"
alt="Cautare domeniu" id="btnDomeniu">
</td>
</tr>

<tr>
<td >
Subdomeniul:
</td>
<td>
<?php
$sqls = "select * , count(*) as nrfirme from firma, subdomeniu WHERE
subdomeniu.id_domeniu = ".$_POST['domeniul']."
group BY subdomeniu.id_subdomeniu";
$resursas = mysql_query($sqls);
?>
<select id="subdomeniul" name="subdomeniul" class="selectare" onmouseover="helpme();" onmouseout="statusre();">
<option>...</option>
<?php
IF(ISSET($_POST['btnSubdomeniu']) && ($_POST['subdomeniul'] != "...")||
($_POST['btnBranse']) && ($_POST['subdomeniul'] != "...")||
($_POST['btnDomeniu']) && ($_POST['subdomeniul'] != "...")||
($_POST['btnFirma']) && ($_POST['subdomeniul'] != "..."))
{
 $sqlsels = "select * from subdomeniu where id_subdomeniu = ".$_POST['subdomeniul'];
 $resursasels = mysql_query($sqlsels);
 $rezs = mysql_fetch_array($resursasels);
 print "<option value='".$_POST['subdomeniul']."' selected>"
 .$rezs['nume_subdomeniu']."</option>";
}
else
{
while($rows = mysql_fetch_array($resursas))
{
 print "<option value='".$rows['id_subdomeniu']."'> [ ".$rows['nrfirme']." ] "
 .$rows['nume_subdomeniu']."</option>";
}
}
?>
</select>
<input type="submit" name="btnSubdomeniu" value="GO!"
alt="Cautare subdomeniu" id="btnSubdomeniu">
</td>
</tr>

<tr>
<td >
Firma:
</td>
<td>
<?php
$sqlf = "select * from firma WHERE id_subdomeniu = ".$_POST['subdomeniul']."
ORDER BY id_firma ASC";
$resursaf = mysql_query($sqlf);
?>

<select id="firma" name="firma" class="selectare" onmouseover="helpme();" onmouseout="statusre();">
<option>...</option>
<?php
IF(ISSET($_POST['btnFirma']) && ($_POST['firma'] != "...")||
($_POST['btnBranse']) && ($_POST['firma'] != "...")||
($_POST['btnDomeniu']) && ($_POST['firma'] != "...")||
($_POST['btnSubdomeniu']) && ($_POST['firma'] != "..."))
{
 $sqlself = "select * from firma where id_firma = ".$_POST['firma'];
 $resursaself = mysql_query($sqlself);
 $rezf = mysql_fetch_array($resursaself);
 print "<option value='".$_POST['firma']."' selected>"
 .$rezf['nume_firma']."</option>";
}
else
{
while($rowf = mysql_fetch_array($resursaf))
{
 print "<option value='".$rowf['id_firma']."'>"
 .$rowf['nume_firma']."</option>";
}
}
?>
</select>
<input type="submit" name="btnFirma" value="GO!" alt="Cautare firma" id="btnFirma">

</td>
</tr>
<?php
IF(ISSET($_POST['btnFirma']) && ($_POST['firma'] != "..."))
{
$sqlx = " SELECT * FROM firma WHERE id_firma = ".$_POST['firma'];
$resursax = mysql_query($sqlx);

print "<table border='0px'>";
print"<tr>
<td>idfirma</td>
<td>numefirma</td>
</tr>";

while($rowx = mysql_fetch_array($resursax))
{
 print "<tr>
    <td>".$rowx['id_firma']."</td>
    <td>".$rowx['nume_firma']."</td>
</tr><tr>
<td>strada</td>
<td>nr</td>
<td>bloc</td>
<td>apartament</td>
</tr><tr>
 <td>".$rowx['strada']."</td>
    <td>".$rowx['nr']."</td>
    <td>".$rowx['bloc']."</td>
    <td>".$rowx['apartament']."</td>
        </tr><tr>
<td>oras</td>
<td>judet</td>
<td>codpostal</td>
</tr><tr>
    <td>".$rowx['oras']."</td>
    <td>".$rowx['judet']."</td>
    <td>".$rowx['cod_postal']."</td></tr><tr>
<td>telefon</td>
<td>mobil</td>
<td>adesaemail</td>
<td>adresaweb</td>
<td>cf</td></td></tr><tr>
    <td>".$rowx['telefon']."</td>
 <td>".$rowx['mobil']."</td>
    <td><a href='mailto:".$rowx['adresa_email']."'>".$rowx['adresa_email']."</a></td>
    <td><a href='".$rowx['adresa_web']."'>".$rowx['adresa_web']."</a></td>
    <td>".$rowx['cf']."</td>
 <tr>";
}

print "</table>";
}
?>
</table>
<input type="submit" name="Reset" value="Reset!" alt="Resetare cautare" id="Reset">
</form>
</body>
</html>

//cautaresam2.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Cautare!</title>
  <LINK REL=StyleSheet HREF="dtpt.css" TITLE="" TYPE="text/css">
</head>
<body>
<?php
INCLUDE("conn_dtpt.php");
?>

<form action="cautare.php" method="POST" id="frmCautare" name="frmCautare">

<h1>Cautare</h1>
<br>

<Table>

<tr>
<td >
Branse:
</td>
<td>
<?php
$sqlb = "select *, count(*) as nrdo from domeniu , branse
where branse.id_branse = domeniu.id_branse group by branse.id_branse;";
$resursab = mysql_query($sqlb);
$nrbranse = mysql_num_rows($resursab);
?>
<select id="branse" name="branse" class="selectare">

<option>...</option>
<?php

while($rowb = mysql_fetch_array($resursab))
{
   print "<option value='".$rowb['id_branse']."'> [ ".$rowb['nrdo']." ] "
 .$rowb['nume_branse']."</option>";
}
?>
</select>
<input type="submit" name="btnBranse" value="GO!"
alt="Cautare branse" id="btnBranse">
</td>
</tr>
</table>
</form>
</body>
</html>

//cmd_add_branse.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Raspuns add_branse</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>

<h1>Executie</h1>
<table><TR><TD BGCOLOR='SILVER'>
<a href="add_branse.php" title="introducere branse noua">branse nou</a>
</TD><TD BGCOLOR='SILVER'>
<a href="branse.php" title="listare branse">Listare branse</a>
</TD></TR></TABLE><br>
<?php
SESSION_START();
INCLUDE("conn_dtpt.php");
$numebranse = STRTOUPPER($_POST['nume_branse']);

$sqlcauta = "SELECT * FROM branse WHERE nume_branse = '".$_POST['nume_branse']."'";
$resursacauta = mysql_query($sqlcauta);

if(mysql_num_rows($resursacauta) != 0)
{
print '<center><table  border=1px><tr><td>Atentie !<br> Aceasta branse exista deja in baza de date!</td></tr></table></center>';
print '<br>
<a href="add_branse.php" title="inapoi">Inapoi</a>';
exit;
}

if ($numebranse == '')
{
print 'Nu puteti adauga spatii goale in baza de date!';
print '<br>
<a href="add_branse.php" title="inapoi">Inapoi</a>';
}
else
{
$sql = "INSERT INTO branse(nume_branse) VALUES ('".$numebranse."')";
mysql_query($sql);
?>

<b>Adaugarea bransei  <?=$numebranse?> fost realizata !</b>
<br>
<a href="branse.php" title="vezi lista de branse">Listare branse de activitate</a>
<?php
}
?>

</body>
</html>

//cmd_add_domeniu.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Raspuns add_domeniu</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>

<h1>Executie</h1>
<table><TR><TD BGCOLOR='SILVER'>
<a href="add_branse.php" title="introducere branse noua">branse nou</a>
</TD><TD BGCOLOR='SILVER'>
<a href="branse.php" title="listare branse">Listare branse</a>
</TD></TR></TABLE><br>

<?php
SESSION_START();
INCLUDE("conn_dtpt.php");
$numedomeniu = STRTOUPPER($_POST['nume_domeniu']);
$idbransa = $_POST['idbransa'];
$sqlcauta = "SELECT * FROM domeniu WHERE nume_domeniu = '".$_POST['nume_domeniu']."'";
$resursacauta = mysql_query($sqlcauta);

if(mysql_num_rows($resursacauta) != 0)
{
print '<center>Atentie !<br>, Acest domeniu exista deja in baza de date!</center>';
print '<br>
<a href="add_domeniu.php" title="inapoi">Inapoi</a>';
exit;
}

if ($numedomeniu == '')
{
print 'Nu puteti adauga spatii goale in baza de date!';
print '<br>
<a href="add_domeniu.php" title="inapoi">Inapoi</a>';
}
else
{
$sql = "INSERT INTO domeniu(nume_domeniu,id_branse) VALUES ('".$numedomeniu."','".$idbransa."')";
mysql_query($sql);
?>

<b>Adaugarea domeniului  <?=$numedomeniu?> fost realizata !</b>
<br>
<a href="domenii.php" title="vezi lista de domenii pe branse de activitati">Listare domeniilor pe branse de activitate</a>
<?php
}
?>

</body>
</html>

//cmd_add_firma.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Raspuns add_firma</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>

<h1>Executie</h1>


<?php
SESSION_START();
INCLUDE("conn_dtpt.php");
$numefirma = STRTOUPPER($_POST['nume_firma']);
$strada = STRTOUPPER($_POST['strada']);
$nr = STRTOUPPER($_POST['nr']);
$bloc = STRTOUPPER($_POST['bloc']);
$apartament = STRTOUPPER($_POST['apartament']);
$telefon = STRTOUPPER($_POST['telefon']);
$oras = STRTOUPPER($_POST['oras']);
$judet = STRTOUPPER($_POST['judet']);
$codpostal = STRTOUPPER($_POST['cod_postal']);
$mobil = STRTOUPPER($_POST['mobil']);
$adresaemail = STRTOUPPER($_POST['adresa_email']);
$adresaweb = STRTOUPPER($_POST['adresa_web']);
$cf = STRTOUPPER($_POST['cf']);

$idbransa = $_POST['idbranse'];
$iddomeniu = $_POST['iddomeniu'];
$idsubdomeniu = $_POST['idsubdomeniu'];
$sqlcauta = "SELECT * FROM firma WHERE nume_firma = '".$_POST['nume_firma']."'";
$resursacauta = mysql_query($sqlcauta);

if(mysql_num_rows($resursacauta) != 0)
{
print '<center>Atentie !<br>, Acesta firma exista deja in baza de date!</center>';
print '<br>
<a href="add_firma.php" title="inapoi">Inapoi</a>';
exit;
}

if ($numefirma == '' OR $strada == '' OR $nr == '' OR $telefon == '' OR $oras == ''
OR $judet == '' OR $codpostal == '' OR $cf == '')
{
print 'Nu puteti adauga spatii goale in baza de date!';
print '<br>
<a href="add_firma.php" title="inapoi">Inapoi</a>';
}
else
{
$sql = "INSERT INTO firma(id_subdomeniu,
nume_firma,
strada,
nr,
bloc,
apartament,
telefon,
oras,
judet,
cod_postal,
mobil,
adresa_email,
adresa_web,
cf)
VALUES ('".$idsubdomeniu."',
'".$numefirma."',
'".$strada."',
'".$nr."',
'".$bloc."',
'".$apartament."',
'".$telefon."',
'".$oras."',
'".$judet."',
'".$codpostal."',
'".$mobil."',
'".$adresaemail."',
'".$adresaweb."',
'".$cf."')";
mysql_query($sql);
?>

<b>Adaugarea datelor firmei  <?=$numefirma?> fost realizata !<br>
Subdomeniu:<?=$idsubdomeniu?><br>
Strada:<?=$strada?><br>
Nr:<?=$nr?><br>
Bloc:<?=$bloc?><br>
Apartament:<?=$apartament?><br>
Telefon:<?=$telefon?><br>
Oras:<?=$oras?><br>
Judet:<?=$judet?><br>
CodPostal:<?=$codpostal?><br>
Mobil:<?=$mobil?><br>
AdresaEmail:<?=$adresaemail?><br>
AdresaWeb:<?=$adresaweb?><br>
CF:<?=$cf?><br></b>



<br>
<a href="firme.php" title="vezi lista de firme pe subdomenii, domenii si branse de activitati">Listare firme pe subdomenii, domenii si branse de activitate</a>
<?php
}
?>

</body>
</html>

//cmd_add_subdomeniu.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Raspuns add_subdomeniu</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>

<h1>Executie</h1>


<?php
SESSION_START();
INCLUDE("conn_dtpt.php");
$numesubdomeniu = STRTOUPPER($_POST['nume_subdomeniu']);
$idbransa = $_POST['idbranse'];
$iddomeniu = $_POST['iddomeniu'];
$sqlcauta = "SELECT * FROM subdomeniu WHERE nume_subdomeniu = '".$_POST['nume_subdomeniu']."'";
$resursacauta = mysql_query($sqlcauta);

if(mysql_num_rows($resursacauta) != 0)
{
print '<center>Atentie !<br>, Acest subdomeniu exista deja in baza de date!</center>';
print '<br>
<a href="add_subdomeniu.php" title="inapoi">Inapoi</a>';
exit;
}

if ($numesubdomeniu == '')
{
print 'Nu puteti adauga spatii goale in baza de date!';
print '<br>
<a href="add_subdomeniu.php" title="inapoi">Inapoi</a>';
}
else
{
$sql = "INSERT INTO subdomeniu(nume_subdomeniu,id_domeniu) VALUES ('".$numesubdomeniu."','".$iddomeniu."')";
mysql_query($sql);
?>

<b>Adaugarea subdomeniului  <?=$numesubdomeniu?> fost realizata !</b>
<br>
<a href="subdomenii.php" title="vezi lista de subdomenii pe domenii si branse de activitati">Listare subdomeniilor pe domenii si branse de activitate</a>
<?php
}
?>

</body>
</html>

//conectare.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Conectare dtpt</title>
</head>
<body>
<?php
//afisare din cadrul resursei returnate
//a tutror datelor dintr-o tabela
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//conectare
$sql = "select * from domeniu order by id_do";
$resursa =mysql_query($sql);
//stabilire comanda mysql in variabile
print "<table>";
//printare cap de tabel
while($row = mysql_fetch_array($resursa))
{
 print  "<tr><td>".$row['id_do']."</td>
 <td>".$row['domeniul']."</td></tr>";
}
//atata timp cat $row este mai mic decat $resursa printeaza cate un rand si
// coloanele corespunzatoar tabelului
print "</table>";
//inchidem tabelul
 ?>
</body>
</html>

//conn_dtpt.php



<?PHP

mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");

?>


//detoatepentrutoti firme.html

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1250">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<link rel=File-List href="DeToatePentruToti_files/filelist.xml">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style id="DeToatePentruToti_20595_Styles">
<!--table
 {mso-displayed-decimal-separator:"\,";
 mso-displayed-thousand-separator:"\.";}
.xl1520595
 {padding:0px;
 mso-ignore:padding;
 color:windowtext;
 font-size:10.0pt;
 font-weight:400;
 font-style:normal;
 text-decoration:none;
 font-family:Arial;
 mso-generic-font-family:auto;
 mso-font-charset:238;
 mso-number-format:General;
 text-align:general;
 vertical-align:bottom;
 mso-background-source:auto;
 mso-pattern:auto;
 white-space:nowrap;}
.xl2420595
 {padding:0px;
 mso-ignore:padding;
 color:windowtext;
 font-size:10.0pt;
 font-weight:400;
 font-style:normal;
 text-decoration:none;
 font-family:Arial;
 mso-generic-font-family:auto;
 mso-font-charset:238;
 mso-number-format:General;
 text-align:center;
 vertical-align:bottom;
 mso-background-source:auto;
 mso-pattern:auto;
 white-space:nowrap;}
.xl2520595
 {padding:0px;
 mso-ignore:padding;
 color:blue;
 font-size:10.0pt;
 font-weight:400;
 font-style:normal;
 text-decoration:underline;
 text-underline-style:single;
 font-family:Arial;
 mso-generic-font-family:auto;
 mso-font-charset:238;
 mso-number-format:General;
 text-align:center;
 vertical-align:bottom;
 mso-background-source:auto;
 mso-pattern:auto;
 white-space:nowrap;}
-->
</style>
</head>

<body>
<!--[if !excel]>&nbsp;&nbsp;<![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="DeToatePentruToti_20595" align=center x:publishsource="Excel">

<table x:str border=0 cellpadding=0 cellspacing=0 width=768 style='border-collapse:
 collapse;table-layout:fixed;width:576pt'>
 <col width=64 span=12 style='width:48pt'>
 <tr height=17 style='height:12.75pt'>
  <td height=17 width=64 style='height:12.75pt;width:48pt' align=left
  valign=top><!--[if gte vml 1]><v:shapetype id="_x0000_t136" coordsize="21600,21600"
   o:spt="136" adj="10800" path="m@7,l@8,m@5,21600l@6,21600e">
   <v:formulas>
    <v:f eqn="sum #0 0 10800"/>
    <v:f eqn="prod #0 2 1"/>
    <v:f eqn="sum 21600 0 @1"/>
    <v:f eqn="sum 0 0 @2"/>
    <v:f eqn="sum 21600 0 @3"/>
    <v:f eqn="if @0 @3 0"/>
    <v:f eqn="if @0 21600 @1"/>
    <v:f eqn="if @0 0 @2"/>
    <v:f eqn="if @0 @4 21600"/>
    <v:f eqn="mid @5 @6"/>
    <v:f eqn="mid @8 @5"/>
    <v:f eqn="mid @7 @8"/>
    <v:f eqn="mid @6 @7"/>
    <v:f eqn="sum @6 0 @5"/>
   </v:formulas>
   <v:path textpathok="t" o:connecttype="custom" o:connectlocs="@9,0;@10,10800;@11,21600;@12,10800"
    o:connectangles="270,180,90,0"/>
   <v:textpath on="t" fitshape="t"/>
   <v:handles>
    <v:h position="#0,bottomRight" xrange="6629,14971"/>
   </v:handles>
   <o:lock v:ext="edit" text="t" shapetype="t"/>
  </v:shapetype><v:shape id="_x0000_s1026" type="#_x0000_t136" style='position:absolute;
   margin-left:36.75pt;margin-top:8.25pt;width:490.5pt;height:43.5pt;z-index:2'
   fillcolor="red [10]" strokecolor="black [8]" o:insetmode="auto">
   <v:shadow on="t" opacity="52429f"/>
   <v:textpath style='font-family:"Tahoma";font-style:italic;v-text-kern:t'
    trim="t" fitpath="t" string="WWW.MYBUSSINES.RO"/>
  </v:shape><![endif]--><![if !vml]><span style='mso-ignore:vglayout;
  position:absolute;z-index:2;margin-left:47px;margin-top:10px;width:659px;
  height:62px'><img width=659 height=62
  src="DeToatePentruToti_files/DeToatePentruToti_20595_image001.gif"
  alt=WWW.MYBUSSINES.RO v:shapes="_x0000_s1026"></span><![endif]><span
  style='mso-ignore:vglayout2'>
  <table cellpadding=0 cellspacing=0>
   <tr>
    <td height=17 class=xl1520595 width=64 style='height:12.75pt;width:48pt'><a
    name="RANGE!A1"></a></td>
   </tr>
  </table>
  </span></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
  <td class=xl1520595 width=64 style='width:48pt'></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td colspan=7 rowspan=32 height=544 class=xl1520595 width=448
  style='mso-ignore:colspan-rowspan;height:408.0pt;width:336pt'><!--[if gte vml 1]><v:shapetype
   id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
   path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
   <v:stroke joinstyle="miter"/>
   <v:formulas>
    <v:f eqn="if lineDrawn pixelLineWidth 0"/>
    <v:f eqn="sum @0 1 0"/>
    <v:f eqn="sum 0 0 @1"/>
    <v:f eqn="prod @2 1 2"/>
    <v:f eqn="prod @3 21600 pixelWidth"/>
    <v:f eqn="prod @3 21600 pixelHeight"/>
    <v:f eqn="sum @0 0 1"/>
    <v:f eqn="prod @6 1 2"/>
    <v:f eqn="prod @7 21600 pixelWidth"/>
    <v:f eqn="sum @8 21600 0"/>
    <v:f eqn="prod @7 21600 pixelHeight"/>
    <v:f eqn="sum @10 21600 0"/>
   </v:formulas>
   <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
   <o:lock v:ext="edit" aspectratio="t"/>
  </v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t75"
   href="../Program%20Files/Apache%20Group/Apache/htdocs/DTPT/LOGIN.PHP.htm"
   style='position:absolute;margin-left:6pt;margin-top:5.25pt;width:282.75pt;
   height:397.5pt;z-index:1' o:button="t">
   <v:fill o:detectmouseclick="t"/>
   <v:imagedata src="DeToatePentruToti_files/DeToatePentruToti_20595_image002.jpg"
    o:title="sigla"/>
   <x:ClientData ObjectType="Pict">
    <x:SizeWithCells/>
    <x:CF>Bitmap</x:CF>
    <x:AutoPict/>
   </x:ClientData>
  </v:shape><![endif]--><![if !vml]><span style='mso-ignore:vglayout'>
  <table cellpadding=0 cellspacing=0>
   <tr>
    <td width=8 height=7></td>
   </tr>
   <tr>
    <td></td>
    <td><a href="../Program%20Files/Apache%20Group/Apache/htdocs/DTPT/LOGIN.PHP.htm"><img
    border=0 width=377 height=530
    src="DeToatePentruToti_files/DeToatePentruToti_20595_image003.jpg" v:shapes="_x0000_s1025"></a></td>
    <td width=63></td>
   </tr>
   <tr>
    <td height=7></td>
   </tr>
  </table>
  </span><![endif]><!--[if !mso & vml]><span style='width:336.0pt;height:408.0pt'></span><![endif]--></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td colspan=4 class=xl2420595>Bine ati venit pe pagina MyBussines.ro</td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td colspan=4 class=xl2420595>© TRAL SOFTWARE 2004</td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <tr height=17 style='height:12.75pt'>
  <td height=17 class=xl1520595 style='height:12.75pt'></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td colspan=4 class=xl2520595><a
  href="mailto:admin@mybussines.ro?subject=contact" title="write to admin">admin</a></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
  <td class=xl1520595></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
 </tr>
 <![endif]>
</table>

</div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>

//domenii.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Listare domenii</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>

<h1>Domenii</h1>

<?php
INCLUDE("conn_dtpt.php");
INCLUDE("meniu.php");
if(isset($_GET['id_branse'])){

$id_branse=$_GET['id_branse'];
$sqlb = "select * from domeniu, branse WHERE domeniu.id_branse = ".$id_branse." AND branse.id_branse = domeniu.id_branse ORDER BY branse.id_branse ASC";
$resursab = mysql_query($sqlb);
$nrdomenii = mysql_num_rows($resursab);

print "<table border='0px'>";
print"<tr><td>idbranse</td><td>idbranse</td><td>iddomeniu</td><td>numebranse</td><td>numedomeniu</td></tr>";

while($rowb = mysql_fetch_array($resursab))
{
 print "<tr><td>".$rowb['id_branse']."</td>
 <td>".$rowb['id_branse']."</td>
 <td>".$rowb['id_domeniu']."</td>
 <td>".$rowb['nume_branse']."</td>
 <td><a href='subdomenii.php?id_domeniu=".$rowb['id_domeniu'].
 "'>".$rowb['nume_domeniu']."</a></td></tr>";
}

 
print "<tr> <b class='normaltext'>Sunt ".$nrdomenii." domenii in bransa curenta</b></tr>";
print "</table>";
}

else
{
$sql = "select * from domeniu, branse WHERE domeniu.id_branse = branse.id_branse ORDER BY branse.id_branse ASC";
$resursa = mysql_query($sql);

print "<table border='0px'>";
print"<tr><td>idbranse</td><td>idbranse</td><td>iddomeniu</td><td>numebranse</td><td>numedomeniu</td></tr>";

while($row = mysql_fetch_array($resursa))
{
 print "<tr><td>".$row['id_branse']."</td>
 <td>".$row['id_branse']."</td>
 <td>".$row['id_domeniu']."</td>
 <td>".$row['nume_branse']."</td>
 </td>
 <td><a href='subdomenii.php?id_domeniu=".$row['id_domeniu'].
 "'>".$row['nume_domeniu']."</a></td><tr>";
}

print "</table>";
}
?>

</body>
</html>
//dtpt.css
/*
Theme Name:Speckyboy December 2012
Theme URI:http://speckyboy.com/
Description:Stylish 2-column theme created from Wordpress.
Version:10
Author:Paul Andrew, Andy Killen
Author URI:http://speckyboy.com/
*/

body{color:#222;background-color:#f2f2f2;font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;margin:0 auto 0;padding:0;position:relative}

a,a:visited{color:#507aa5;text-decoration:none;background:inherit}
a:hover{color:#222;text-decoration:none;background:inherit}

a img{border: none}

ul,img,img a{padding:0;margin:0}

hr{text-align:right;width:100%;height:1px;color:#ddd;border:none;margin:8px 0 6px 0;background:inherit} /* For Internet Explorer */
html>body hr{margin-right:0;width:100%;height:1px;background-color:#ddd;border:none;background:inherit} /* For Gecko-based browsers */
html>body hr{border:0px solid #ddd} /* For Opera and Gecko-based browsers */

ul{list-style:none}

/*Body Wrap*/
#wrap{padding:0 25px 20px;background-color:#fff;width:964px;margin:0px auto 0px;position:relative}
#top-color-section{width:100%;position:absolute;width:100%;height:36px;background-color:#658DB5;top:0;left:0}
/*Header*/
#header{padding-top:30px}
#header img{border:0}
.topad{float:right;margin:30px 0 30px 0;height:90px}
.logo{float:left;margin:45px 0 15px 0;height:90px}

/*Searchform Homepage & No Return Search*/
.search-button{background:#ddd url(images/search_icon.png) no-repeat center;display:inline-block;padding:3px 11px 3px;color:#222;text-decoration:none;font-size:10px;cursor:pointer;margin:0px 5px 0 0;-moz-border-radius:3px;border-radius:3px;border:1px solid #ccc}
.search-button2{background:#f5f5f5 url(images/search_icon.png) no-repeat center;display:inline-block;padding:7px 12px 6px 12px;color:#222;text-decoration:none;font-size:10px;cursor:pointer;margin:20px 1px 0 0;-moz-border-radius:3px;border-radius:3px;border:1px solid #ddd}
.search-button:hover, .research:hover, .cat-drop:hover, .search-button2:hover{background:#ccc url(images/search_icon.png) no-repeat center;border:1px solid #bbb}

.main-search{float:right;text-transform:none}
.searchtext{border:1px solid #ccc;color:#222;font-size:11px;padding:4px 5px 4px;margin:5px 5px 0 0;background:#fcfcfc;-moz-border-radius:3px;border-radius:3px}
.searchtext:focus{background-color:#fafafa;border:1px solid #bbb}
.search-terms{color:#F00}
.search-title{padding:0 0 25px 0}

/*Middle Drop-Down Navigation*/
#mid-nav-container{padding:0;margin:0 auto 0;font-size:11px;clear:both;border-bottom:1px solid #d5d5d5;border-top:1px solid #d5d5d5;height:33px}

/* Targeting both first and second level menus */
#mid-nav li{float:left;position:relative;list-style:none}
#mid-nav li a{background:#fff;border:none;color:#222;display:block;margin:0 5px 0 0;padding:5px 20px 5px 8px;background:url(images/arrow.png) no-repeat right}

/* Targeting the first level menu */
#mid-nav{display:block;padding:5px 0 2px 0;z-index:100;position:absolute;margin:0}
#mid-nav > li > a:hover{-moz-border-radius:3px 3px 0 0;-webkit-border-radius:3px 3px 0 0;border-radius:3px 3px 0 0;padding:5px 20px 5px 8px;color:#fff;background:#507aa5 url(images/arrow_hover.png) no-repeat right}

/* Targeting the second level menu */
#mid-nav li ul{background:#507aa5;color:#222;display:none;margin:0;width:140px;position:absolute;padding:2px 0;margin:0;-webkit-border-bottom-right-radius:3px;-moz-border-radius-bottomright:3px;border-bottom-right-radius:3px;-moz-border-radius-bottomleft:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;-moz-border-radius-topright:3px;border-top-right-radius:3px;border-top-right-radius:3px;-moz-box-shadow:1px 1px 1px #333;-webkit-box-shadow:1px 1px 1px #333;box-shadow:1px 1px 1px #333}
#mid-nav li ul li{width:100%}
#mid-nav li ul li a{background:#507aa5;border:none;line-height:25px;margin:0;padding:0 0 0 8px;color:#fff}
#mid-nav li ul li a:hover{background:#466A90}
#mid-nav li ul li.strong-archive a{font-weight:600;border-top:1px solid #466A90}

/* A class of current will be added via jQuery */
#mid-nav li.current > a{background:#507aa5;-moz-border-radius:3px 3px 0 0;-webkit-border-radius:3px 3px 0 0;border-radius:3px 3px 0 0;color:#fff;background:#507aa5 url(images/arrow_hover.png) no-repeat right;-moz-box-shadow:1px 1px 1px #333;-webkit-box-shadow:1px 1px 1px #333;box-shadow:1px 1px 1px #333}

/* CSS fallback */
#mid-nav li:hover > ul.child{display:block}


/* Targeting both first and second level menus */
#social_drop li{float:right;position:relative;list-style:none}
#social_drop li a{border:none;color:#222;display:block;margin:0 5px 0 0;padding:3px;color:#fff;background:inherit}
#social_drop li.active a{border:none;color:#222;display:block;margin:0 0px 0 0;padding:3px 20px 0px 3px;background:url(images/arrow_hover.png) no-repeat right;color:#fff;background:inherit}
#social_drop li.feed a{border:none;display:block;margin:0 0px 0 0px;padding:0px 20px 0px 26px;background:url(images/rss_small.png) no-repeat left;color:#fff;background:inherit}
#social_drop li.feed a:hover{background:#658DB5 url(images/rss_small.png) no-repeat left}

/* Targeting the first level menu */
#social_drop{float:right;margin-right:30px;margin-top:1px;font-size:11px}
#social_drop > li.active > a:hover{-moz-border-radius:3px 3px 0 0;-webkit-border-radius:3px 3px 0 0;border-radius:3px 3px 0 0;padding:3px 20px 0px 3px;color:#fff;background:#476D93 url(images/arrow_hover.png) no-repeat right;font-size:11px}
#social_drop > li > a:hover{-moz-border-radius:3px;-webkit-border-radius:3px;border-radius:3px;padding:3px 3px 0 3px;color:#fff;background:#476D93}

/* Targeting the second level menu */
#social_drop li ul{background:#476D93;color:#222;display:none;margin:0;width:155px;float:left;padding:2px 0;margin:0;-moz-border-radius:3px 0px 3px 3px;-webkit-border-radius:3px 0px 3px 3px;border-radius:3px 0px 3px 3px;position:absolute;right:0px;-moz-box-shadow:1px 1px 1px #333;-webkit-box-shadow:1px 1px 1px #333;box-shadow:1px 1px 1px #333}
#social_drop li ul li{width:100%}
#social_drop li ul li a{background:#476D93;border:none;line-height:25px;margin:0;padding:0 0 0 8px;color:#fff}
#social_drop li ul li a:hover{background:#466A90}
#social_drop li ul li.strong-archive a{font-weight:600;border-top:1px solid #466A90}

/* A class of current will be added via jQuery */
#social_drop li.current > a{-moz-border-radius:3px 3px 0 0;-webkit-border-radius:3px 3px 0 0;border-radius:3px 3px 0 0;color:#fff;background:#476D93 url(images/arrow_hover.png) no-repeat right;-moz-box-shadow:1px 1px 1px #333;-webkit-box-shadow:1px 1px 1px #333;box-shadow:1px 1px 1px #333}

/* CSS fallback */
#social_drop li:hover > ul.child{display:block}

/*Middle Drop-Down Navigation*/
#mid-nav2-container{padding:0;margin:0 auto 0;font-size:11px;clear:both;height:26px}

/* Targeting both first and second level menus */
#mid-nav2 li{float:left;position:relative;list-style:none}
#mid-nav2 li a{background:#f3f3f3;border:none;color:#333;display:block;margin:0;padding:6px 10px 4px;border-top:1px solid #d5d5d5;border-right:1px solid #d5d5d5}
#mid-nav2 li.active a{background:#fff;color:#222;display:block;margin:0 0px 0 10px;padding:6px 10px 4px;border:1px solid #d5d5d5;border-bottom:1px solid #fff;-webkit-border-radius:4px 0 0 0;border-radius:4px 0 0 0}
#mid-nav2 li.child a{background:#f3f3f3;color:#333;display:block;margin:0 0px 0 0px;padding:6px 10px 4px;-webkit-border-radius:0px 4px 0 0;border-radius:0px 4px 0 0}
#mid-nav2 li a:hover{background:#fafafa;text-decoration:none;color:#fff;border-bottom:1px solid #d5d5d5}

/* Targeting the first level menu */
#mid-nav2{display:block;padding:1px 0 2px 0;z-index:100;position:absolute;margin:0}
#mid-nav2 > li > a:hover{color:#222;background:#ececec}
#mid-nav2 > li.active > a:hover{-moz-border-radius:3px 3px 0 0;-webkit-border-radius:3px 3px 0 0;border-radius:3px 3px 0 0;color:#fff;background:#fff;border-bottom:1px solid #fff;color:#222}

/* Header Top Navigation */
#top-navigation-wrap{padding:0;position:absolute;left:0px;width:100%;background-color:#6086AC;height:36px}
#top-navigation{padding-top:3px;margin:0 25px}
#top-navigation img{border:0;margin:0;padding:0}
#top-navigation li{display:inline;margin:0;padding:0}
#top-navigation a:hover{-moz-border-radius:3px;-webkit-border-radius:3px;background:#476D93}
#top-navigation a{float:left;font-size:11px;margin:4px;padding:4px 6px 4px 6px;text-decoration:none;color:#fefefe;background:inherit}
#top-navigation ul{margin:0;padding:0}

/* Main Content - Typography */
h1,h2,h3,h4,h5{color:#444;background:inherit;margin:0}
h1{color:#555;font-size:30px;font-weight:bold;padding:0 0 5px;background:inherit}
h2{border-top:1px solid #ddd;font-weight:bold;clear:both;font-size:21px;padding:20px 0 20px}
h3{border-top:none;font-weight:bold;clear:both;font-size:20px;padding:20px 0 20px}
h4{border-top:none;font-weight:bold;clear:both;font-size:17px;padding:0px 0 10px}
h5{font-size:16px;padding:8px 0 8px;border-top:1px solid #ddd;font-weight:bold;clear:both;padding:20px 0 20px}
h1 a:hover{color:#333;text-decoration:none;background:inherit}

.content-title{float:right;width:494px}
.content-title h1{font-size:28px;font-weight:700;line-height:110%;padding:0 0 0 0}
.post-title{font-size:36px;padding:5px 0 8px 0}
.author-archive{padding:0 0 25px 0}
.content p{line-height:20px;margin:0;padding:0 0 15px}
.blue{color:#507aa5;background:inherit}

blockquote{font-size:15px;font-family:Georgia, "Times New Roman", Times, serif;padding:5px 8px 0;background-color:#fefefe;color:#444;font-style:italic;border-top:1px solid #f1f1f1;border-bottom:1px solid #f1f1f1;margin:10px 10px 0;background-image:url(images/openquote1.gif);background-position:top left;background-repeat:no-repeat;text-indent:23px}
blockquote span{display:block;background-image:url(images/closequote1.gif);background-repeat:no-repeat;background-position:bottom right;padding:0 0 8px}
blockquote p{padding:0;margin:0}

cite{font-weight:bold;font-size:11px;text-transform:uppercase;float:right;padding:0 30px 10px 0}

pre{border:solid 3px #eee;margin:0 0 10px 0;padding:0;background:#f9f9f9}

code{background:#eee;padding:0 3px}

.clean{clear:both}
/* Main Content */
.content{margin:0 auto 0;padding:25px 0 0 0;position:relative}
.post-list li{padding:15px;margin:20px;list-style:circle}

/* Main Content - Middle */
#content-middle{float:left;margin:0;padding:0 22px 0 0;width:650px;border-right:1px solid #ddd}
.content-middle-thumb{clear:both;display:block;float:left;margin:2px 0 15px 0}
#content-middle img{border:1px solid #e5e5e5;background:#fff;padding:4px;float:left;margin:0 15px 15px 0}
#content-middle a img{border:1px solid #e5e5e5;background:#fafafa;padding:4px;float:left;margin:0 15px 15px 0}
#content-middle a:hover img{border:1px solid #ccc;padding:4px;background:#ddd;float:left}

#content-middle ul{margin:0;padding:0px 0 15px}
#content-middle ol{margin:0;padding:0px 0 15px}
#content-middle ul li{margin:0 0 0 15px;padding:2px 0 2px 2px;list-style:none;line-height:135%}
#content-middle ol li{margin:0 0 0 30px;padding:2px 0 2px 2px;line-height:135%}

#social-share{float:right;}
#social-share a img{margin:0 2px 1px 0  !important;padding:0  !important;border:none !important;float:none;height:17px;width:17px}



.social-sprites-linkedin{background: url(images/specky-share.png) no-repeat -34px 0 !important;}
.social-sprites-delicious{ background: url(images/specky-share.png) no-repeat 0 0 !important;}
.social-sprites-digg{ background: url(images/specky-share.png) no-repeat -17px 0 !important;}
.social-sprites-pinterest{ background: url(images/specky-share.png) no-repeat -51px 0 !important;}
.social-sprites-reddit{ background: url(images/specky-share.png) no-repeat -68px 0 !important;}
.social-sprites-stumble{ background: url(images/specky-share.png) no-repeat -85px 0 !important;}


#postinfo{font-size:11px;border-bottom:1px solid #eee;border-top:1px solid #eee;margin:0;padding:5px 0;color:#444;width:650px;clear:both;background:inherit}
#postinfo img{border:0;float:none;margin:0}
#postinfo a img{border:0;padding:0 0 0 5px;float:none;;margin:0;background:none}
#postinfo a:hover img{border:0;float:none;background:none;padding:0 0 0 5px}
#postcat{font-size:11px;border-bottom:1px solid #eee;margin:0 0 12px;padding:5px 0;color:#444;width:650px;clear:both;background:inherit}
#postcat img{border:0;margin:0;float:none;}
#postcat a img{border:0;padding:0 0 0 5px;float:none;margin:-1px 0 0 0;background:none}
#postcat a:hover img{border:0;float:none;background:none;padding:0 0 0 5px;margin:0} 
.author-desc{clear:both;display:block;height:100%;width:100%}
.author-description{display:block;float:right;width:556px;line-height:19px}
.author-meta{padding:0 20px 0 0}
.author-profile{display:block;float:right;width:556px;line-height:19px;padding:0 0 20px 0}
.post-category{font-size:28px;padding:20px 0;color:#222;border-top:3px solid #ddd;background:inherit}
.info{font-size:11px;line-height:18px;margin:0;float:right;color:#444;width:494px;background:inherit}

.more-text{font-size:11px}
.text-excerpt{font-size:13px;line-height:18px;margin:0;padding:0;width:494px;float:right}
.middlespacer{background:#fff;border-bottom:1px solid #d5d5d5;clear:both;margin:0 0 23px 0;padding:0;width:650px}
#greybox,.greybox{border:2px solid #eee;background:#f9f9f9;padding:10px;margin:0 0 15px 0;line-height:19px}
.greybox-split{border:2px solid #eee;background:#f9f9f9;padding:10px;margin:0 0 15px 0;line-height:19px}
.split-post-right,.split-post-left{width:302px;padding:0 23px 0 0;float:left;margin:0}
.split-post-right{padding:0 0 0 10px}
.split-post-left h2,.split-post-right h2{border-top:none;font-size:17px;padding:0 0 10px 0}

/* Main Content - Page Navi */
.wp-pagenavi{clear:both;float:right}
.wp-pagenavi a, .wp-pagenavi span{text-decoration:none;border:1px solid #ddd;padding:3px 5px;margin:2px 0 2px 2px}
.wp-pagenavi a:hover, .wp-pagenavi span.current{border-color:#507aa5;background:#507aa5;background:inherit}
.wp-pagenavi .nextpostslink a{border:none}

/* Sidebar */
#sidebar{float:right;font-size:11px;text-align:left;width:280px;margin:0}
#sidebar a img{border:none;float:left;margin:0 0 15px 15px}
#sidebar h3{font-size:13px;font-weight:bold;padding:0 0 10px 0;margin:0;width:265px;float:right;border-top:1px solid #fff}
.sidebar-left{float:left;padding:0;width:117px;margin:0}
.sidebar-right{float:right;padding:0;width:117px;margin:0}
.sidebar-widget-int{overflow:hidden;background:#fff;padding:5px 8px 5px 8px}

/* Sidebar Tabs*/
.subscribe-button{background:#507aa5;display:inline-block;padding:4px 2px 3px 2px;color:#fff;text-decoration:none;-moz-border-radius:3px;-webkit-border-radius:3px;border:none;font-size:11px;text-transform:uppercase;cursor:pointer;margin:0;text-transform:none}
.subscribe-button:hover{background:#555}
.subscribe-footer-button{background:#666;display:inline-block;padding:4px 2px 3px 1px;color:#fff;text-decoration:none;-moz-border-radius:3px;-webkit-border-radius:3px;border:none;font-size:11px;text-transform:uppercase;cursor:pointer;margin:0;text-transform:none}
.subscribe-footer-button:hover{background:#555}
#subscribe-text,#newsletter-text{width:160px;border:1px solid #ccc;color:#222;font-size:10px;padding:3px;font-size:12px;margin:9px 5px 5px 0;-moz-border-radius:3px;-webkit-border-radius:3px;background:#fff}
#subscribe-footer{width:160px;border:1px solid #444;color:#fff;font-size:12px;padding:3px;margin:5px 5px 5px 0;-moz-border-radius:3px;-webkit-border-radius:3px;background:#888}
#newsletter-text{margin:14px 5px 0 0;background:#fbfbfb}
#subscribe_tabs{float:right}
#subscribe_tabs .list-block{background:#fff;margin:0;width:235px;overflow:hidden;padding:5px 8px 5px 8px}
#subscribe_tabs{padding:7px;margin:0 0 15px 0;width:251px;clear:both;background:#ccc}
#subscribe_tabs ul{list-style:none}
#subscribe_tabs ul li a{border-bottom:1px dotted #e5e5e5;padding:5px 0;display:block;margin:0 5px}
#subscribe_tabs ul li a:hover{background:#f9f9f9;color:#222}
#subscribe_tabs .nav{overflow:hidden}
#subscribe_tabs .nav li{padding:0;float:left;margin:0 5px 0 0}
#subscribe_tabs .nav li.last{margin-right:0}
#subscribe_tabs .nav li a{margin:0;display:block;border:none;padding:4px 7px;color:#333;-moz-border-radius-topleft:3px;-moz-border-radius-topright:3px;-webkit-border-top-left-radius:3px;-webkit-border-top-right-radius:3px;border-top-left-radius:3px;border-top-right-radius:3px;text-align:center;clear:both;background:inherit}
#subscribe_tabs li a.current,#subscribe_tabs li a.current:hover{background-color:#fff;color:#222}
#subscribe_tabs .nav li a:hover, #subscribe_tabs .nav li a:focus{background:#999}
#category_tabs{float:right}
#category_tabs .list-block{background:#fff;margin:0;width:235px;overflow:hidden;padding:5px 8px}
#category_tabs{padding:7px;margin:0 0 15px 0;width:251px;clear:both;background:#ccc}
#category_tabs ul{list-style:none}
#category_tabs ul li a{border-bottom:1px dotted #e5e5e5;padding:5px 0;display:block;margin:0 5px}
#category_tabs ul li a:hover{background:#f9f9f9;color:#222}
#category_tabs .nav{overflow:hidden}
#category_tabs .nav li{padding:0;float:left;margin:0 5px 0 0}
#category_tabs .nav li.last{margin-right:0}
#category_tabs .nav li a{margin:0;display:block;border:none;padding:4px 7px;color:#333;-moz-border-radius-topleft:3px;-moz-border-radius-topright:3px;-webkit-border-top-left-radius:3px;-webkit-border-top-right-radius:3px;border-top-left-radius:3px;border-top-right-radius:3px;text-align:center;clear:both;background:inherit}
#category_tabs li a.current,#category_tabs li a.current:hover{background-color:#fff;color:#222}
#category_tabs .nav li a:hover, #category_tabs .nav li a:focus{background:#999}
#archives_tabs{float:right}
#archives_tabs .list-block{background:#fff;padding:5px;margin:0;width:241px}
#archives_tabs{padding:7px;margin:0 0 15px 0;background:#ccc;width:251px}
#archives_tabs ul li a{border-bottom:1px dotted #eee;padding:5px 0;display:block;margin:0 5px 0 5px}
#archives_tabs ul li a:hover{background:#f9f9f9;color:#222}
#archives_tabs .nav{overflow:hidden}
#archives_tabs .nav li{padding:0;float:left;margin:0 5px 0 0}
#archives_tabs .nav li.last{margin-right:0}
#archives_tabs .nav li a{margin:0;display:block;border:none;padding:4px 7px;color:#333;-moz-border-radius-topleft:3px;-moz-border-radius-topright:3px;-webkit-border-top-left-radius:3px;-webkit-border-top-right-radius:3px;border-top-left-radius:3px;border-top-right-radius:3px;text-align:center;clear:both;background:inherit}
#archives_tabs li a.current,#archives_tabs li a.current:hover{background-color:#fff;color:#000}
#archives_tabs .nav li a:hover, #archives_tabs .nav li a:focus{background:#999}

/* Footer*/
#footer{font-size:11px;margin:0;padding:0;clear:both;overflow:auto;text-align:left;background:#484848;width:100%}
#footer-wrap{font-size:11px;margin:0 auto 0;padding:0px 40px;clear:both;text-align:left;background:#444;width:934px;border-bottom:1px solid #555}
#footer ul{margin:0;padding:0}
#footer ul li{letter-spacing:0;margin:0;padding:0}
#footer ul li a{border-bottom:1px dotted #555;display:block;font-size:11px;padding:4px 4px 4px 0;text-decoration:none;color:#dedede;background:inherit}
#footer ul li a:hover{background-color:inherit;border-bottom:1px dotted #777;color:#efefef}
#footer a img{border:none;display:inline;margin:0 0 0 0}
#footer h3{font-size:15px;font-weight:normal;padding:20px 0 5px 0;border-top:none;color:#fff;background:inherit}
.footer-column{padding:0;float:left;font-size:12px;margin:0;display:block}
.footer-column-ad{padding:25px 0 0 0;float:left;font-size:12px;margin:0;display:block}
.footer-column-middle{padding:0 47px;float:left;font-size:12px;margin:0;display:block}
.bottom-left{border:none;float:left;padding:0 20px 0 0;width:125px}
.bottom-right{float:right;padding:0;width:124px;border-right:1px solid #444}
.footer-space{clear:both;display:block;height:1px;width:100%;border-bottom:1px solid #555;padding:20px 0 0 0}
#largead{border-bottom:1px solid #555;clear:both;margin:0;padding:15px 0 15px 0;text-align:center}
#copyright{font-size:12px;margin:1px 0 0 0;padding:15px 0 15px 0;text-align:center;color:#eee;background:inherit}
#copyright a{color:#eee;background:inherit}
#bottomad{background-color:#1C1C1C;bottom:0;display:block;height:32px;left:0;padding:0;position:fixed;text-align:center;width:100%;z-index:999;background:#e2e2e2}
#bottomad a img{border:none}

/* Clears & Footers */
.clear,#clear-bottom,#clear-top{clear:both;display:block;height:1px;width:100%}
#clear-bottom{height:15px}
#main_post_clear{clear:both;margin-top:2px;padding-top:5px}

/* Table Styling */
table{background-color:#fff;border:1px solid #ddd;border-collapse:collapse;border-spacing:0;text-align:center;margin:10px 0;font-size:12px}
table td{background-color:#fff;border:1px solid #ddd;line-height:15px;margin-bottom:15px;padding:6px;text-align:center}
table th{background-color:#fdfdfd;border:1px solid #ddd;line-height:15px;margin-bottom:15px;padding:6px;text-align:center;font-weight:normal}

table.font{background-color:#222;border:0;border-collapse:collapse;border-spacing:0;color:#507aa5;font-weight:400;text-align:left;width:500px}
table.font td{background-color:#eee;border:2px solid #fff;color:#555;font-family:"Courier New", Courier, monospace;padding:6px;text-align:left}
table.font td.book{background-color:#fcfcfc;font-family:Georgia, "Times New Roman", Times, serif;font-size:13px;font-weight:400;padding:8px 4px 4px;text-align:center}
table.font td.hed{background-color:#ddd;border-bottom:2px solid #fff;color:#507aa5;font-family:Georgia, "Times New Roman", Times, serif;font-size:16px;font-weight:400;padding:6px;text-align:left}
table.stats{background-color:#ddd;border:0;border-collapse:collapse;border-spacing:0;color:#507aa5;font-weight:400;text-align:left;width:400px}
table.stats td{background-color:#d5d5d5;border:1px solid #fff;color:#555;padding:6px;text-align:left}
table.stats td.hed{background-color:#ddd;border-bottom:2px solid #fff;color:#507aa5;padding:6px;text-align:left}

/* Buttons */
.med,.small,.large{display:inline-block;background:#507aa5;color:#fff;outline:none;cursor:pointer;text-align:center;text-decoration:none;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px}
.med{margin:15px 15px 10px 0;font-size:12px;padding:2px 10px}
.small{margin:15px 15px 10px 0;font-size:10px;padding:1px 10px}
.large{margin:0 15px 20px 0;font-size:14px;padding:4px 14px}
.small:hover, .med:hover, .large:hover,.small:active, .med:active, .large:active{background:#222;color:#fff}
.button-med, .button-med:visited{font-size:13px;background:#507aa5;display:inline-block;padding:2px 5px 2px;color:#fff;text-decoration:none;-moz-border-radius:4px;-webkit-border-radius:4px;border-radius:4px;border:none;position:relative;cursor:pointer;margin:10px 10px 0 0}
.button-med:hover{background:#555;color:#fff}
.button-med-split, .button-med-split:visited{font-size:13px;background:#507aa5;display:inline-block;padding:2px 5px 2px;color:#fff;text-decoration:none;-moz-border-radius:4px;-webkit-border-radius:4px;border-radius:4px;border:none;position:relative;cursor:pointer;margin:0 10px 20px 0}
.button-med-split:hover{background:#555;color:#fff}
.button-large, .button-large:visited,.button-small, .button-small:visited{font-size:15px;background:#507aa5;display:inline-block;padding:2px 5px 2px;color:#fff;text-decoration:none;-moz-border-radius:4px;-webkit-border-radius:4px;border-radius:4px;border:none;position:relative;cursor:pointer;margin:10px 10px 0 0}
.button-small:hover{background:#555;color:#fff}
.button-small, .button-small:visited{font-size:11px}

.plusone{float:right;padding:0 0 10px 0;margin:2px 0 0 10px}
.facebook_widget{float:right;padding:0 0 10px 0;margin:3px 0 0 10px}
.twitter_widget{float:right;padding:0 0 10px 0;margin:2px 0 0 0px}

/* Comments */
#comments{position:relative;margin:0;padding:0}
#comments .commentlist{padding:0}
#comments .comment.thread-even{background:#efefef;border:1px solid #ddd;border-width:1px 0}
#comments .comment{margin:0;width:100%;list-style-type:none}
#comments .comment .comment-body{position:relative;padding:15px 0 15px 15px}
#comments .comment-head{margin:0 0 15px 0}
#comments .comment-author img{float:left;margin:0 15px 5px 0}
#comments .comment-author cite{font-weight:bold;font-style:normal;font-size:18px;float:left;text-transform:none;padding:0 5px 0 0}
#comments .comment-meta{font-size:10px}
#comments .comment-entry p{margin:0 0 10px 0}
#comments .reply{padding-top:10px}
#comments ul.children{margin:10px 10px 0 45px;padding:0}
#comments ul.children li{border-top:1px solid #ddd}
#comments .cancel-comment-reply,#comments .pingbacks li.pingback{margin:10px 0}
#comments .pingbacks li.pingback .reply{display:none}


/* Comments Form */#respond label{font-size:13px}
#commentform{margin:15px 0 0 5px}
#commentform input.txt, #commentform textarea{font:14px/14px Arial, Helvetica, sans-serif;border:1px solid #ccc;margin:0 15px 25px 0}
#commentform input.txt{background:#fcfcfc;width:170px;margin:0 15px 25px 0;padding:5px 7px}
#commentform textarea{background:#fcfcfc;width:95%;padding:5px 7px}
#commentform .form-allowed-tags{font-size:12px;color:#555;background:inherit}

/* Comments Buttons */
.reply a{display:inline-block;background:#777;color:#fff;outline:none;cursor:pointer;text-align:center;text-decoration:none;margin:0;font-size:11px;padding:2px 4px;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px}
.reply a:hover{background:#507aa5;color:#fff}
.reply a:active{background:#507aa5;color:#fff}
#respond button{display:inline-block;background:#507aa5;color:#fff;outline:none;cursor:pointer;text-align:center;text-decoration:none;margin:10px 15px 20px 0;font-size:14px;padding:6px 10px;-webkit-border-radius:3px;-moz-border-radius:3px;border-radius:3px;border:none}
#respond button:hover{background:#777}

/* Pingbacks / Trackbacks */.pinglist li{margin:0 0 0 20px;list-style-type:decimal}
.pinglist li .date{font-size:11px}
.pinglist li .pingcontent{display:block;margin:10px 0}
.moderation{padding:0 0 0 25px}
.comment-text{padding:0}
.trackbacklist{margin:0;padding:0}
.content .trackbacklist ul{margin:0}
#commentform{padding:0 0 10px 0}
#commentform p{margin:0 0 10px 0}
.box-comments{position:relative;padding:0 0 30px}
.comments-paging{position:absolute;top:0;right:0}
#respond textarea{float:none;height:200px;padding:3px;width:650px}
#respond textarea,#respond input{background:#fcfcfc;border:1px solid #ddd;font-size:13px;padding:3px;width:300px}
.commentad{border-top:1px solid #ddd;padding:15px 0 0px 0;clear:both;float:none;margin:0}
.commentad a img{text-align:center;float:none}
.center{text-align:center}
#wix_ad a img{border:none;margin:0 0 10px 0;background:#fff}
#wix_ad a:hover img{border:none}
.sidebar-iframe{border:none;overflow:hidden;width:265px;height:320px;margin:0 0 15px 15px}

/* contact for 7 */
div.wpcf7{margin:0;padding:0}
div.wpcf7-response-output{margin:2em 0.5em 1em;padding:0.2em 1em}
div.wpcf7-mail-sent-ok{border:2px solid #398f14}
div.wpcf7-mail-sent-ng{border:2px solid #f00}
div.wpcf7-spam-blocked{border:2px solid #ffa500}
div.wpcf7-validation-errors{border:2px solid #f7e700}
span.wpcf7-form-control-wrap{position:relative}
span.wpcf7-not-valid-tip{position:absolute;top:20%;left:20%;z-index:100;background:#fff;border:1px solid #f00;font-size:10pt;width:280px;padding:2px}
span.wpcf7-not-valid-tip-no-ajax{color:#f00;font-size:10pt;display:block}
span.wpcf7-list-item{margin-left:0.5em}
.wpcf7-display-none{display:none}
div.wpcf7 img.ajax-loader{border:none;vertical-align:middle;margin-left:4px}
div.wpcf7 .watermark{color:#888;background:inherit}

/* sprites */
.rss-sidebar,.twitter-sidebar,.digg2,.fbook-sidebar,.ff-sidebar,.deli-sidebar{padding:2px 0 2px 23px}
.rss-sidebar,.twitter-sidebar,.digg2,.fbook-sidebar,.ff-sidebar,.deli-sidebar,.s-logo,.s-mobify,.s-mt,.s-mxcdn,.s-rss,.s-smashingnetwork{background:url(images/sprites.png) no-repeat top left}
.deli-sidebar,.s-delicious{background-position:0 0 !important}
.digg2{background-position:0 -38px !important}
.fbook-sidebar,.s-facebook{background-position:0 -76px !important}
.ff-sidebar{background-position:0 -114px !important}
.s-logo{background-position:0 -192px;width:173px;height:53px}
.s-mobify{background-position:0 -268px;width:125px;height:40px}
.s-mt{background-position:0 -331px;width:265px;height:50px}
.s-mxcdn{background-position:0 -404px;width:125px;height:40px}
.rss-sidebar,.s-rss{background-position:0 -506px !important}
.s-smashingnetwork{background-position:0 -544px;width:249px;height:105px}
.twitter-sidebar{background-position:0 -711px !important}

/* top bar and sidebar sprites */
.top-email,.top-facebook,.top-gplus,.mighty-deals-sidebar-logo,.media-temple-sidebar-logo,.max-cdn-sidebar-logo,.top-rss,.top-twitter{background-image:url(images/sprites2.png);background-repeat:none}
.top-email{background-position:0 0;width:23px;height:23px}
.top-facebook{background-position:-24px 0;width:23px;height:23px}
.top-gplus{background-position:-48px 0;width:23px;height:23px}
.mighty-deals-sidebar-logo{background-position:-72px 0;width:265px;height:260px}
.media-temple-sidebar-logo{background-position:-338px 0;width:265px;height:50px}
.max-cdn-sidebar-logo{background-position:-604px 0;width:265px;height:53px}
.top-rss{background-position:-870px 0;width:23px;height:23px}
.top-twitter{background-position:-894px 0;width:23px;height:23px}


#dsq-content #dsq-global-toolbar .dsq-global-toolbar-left li{float:left;list-style:none outside none;margin:0 3px 5px 0}

#dsq-content #dsq-global-toolbar .dsq-global-toolbar-right li{float:left;list-style:none outside none;margin:0 0 5px 3px}
#dsq-content .dsq-comment{-moz-transition:all 0.5s ease-in-out 0s;clear:both;list-style:none outside none;margin:0 0 1.5em;position:relative}
#dsq-content .dsq-comment-meta li, #dsq-content .dsq-comment-actions li{float:left;font-size:90%;list-style:none outside none;margin:0 12px 0 0}
#dsq-content #dsq-footer li{float:left;list-style:none outside none;margin:0 10px 0 0}
#dsq-reactions li .dsq-avatar img{border:solid 3px white}
#dsq-reactions li{margin:0 !important}





#youtube{width:700px;float:left;position:relative;height:428px}
#youtube .title{position:absolute;top:-40px;left:10px;font-size:32px;overflow:visible;width:950px}
.title h1{margin:0;width:700px;line-height:1.05em}

#video-area{
margin-top:60px;margin-bottom:20px
}
#controler{width:260px;float:left;height:426px;position:relative;border:solid 1px #ccc;border-left:none}
#controler h1{font-size:20px;background-color:#1D7719;padding:13px 14px;margin:0;
}
#controler .selection h3{margin:15px 5px 0 5px;padding:0;color:#507AA5;font-family:Trebuchet,Tahoma,"Lucida Sans Unicode",Verdana,sans-serif;font-size:16px}
#controler .selection{;margin:5px 5px 5px 7px}
#controler .more{position:relative}

#controler a:hover{text-decoration:none}
#controler a small{color:#507AA5}
#controler a span{color:#507AA5}

.videolist a{display:block;height:60px;width:100%}
.videolist{margin:0;padding:0;border:dashed 3px #507AA5;border-width:3px 0;height:311px;overflow:hidden;list-style-type:none}
.videolist li{position:relative;padding:8px 5px 5px 7px;border-bottom:dotted 1px #507AA5;line-height:15px;height:64px}
.videolist li.selected{border:none;background-color:#ebebeb}
.videolist li img{border:solid 3px #507AA5;float:left;margin-right:10px;-moz-border-radius:3px;border-radius:3px;-webkit-border-radius:3px}

.videolist li.selected img{border-color:#555}
.videolist li.selected a, #controler li.selected a *{color:#555}
#controler li.selected .social-buttons a *{color:#555}
.social-buttons{position:absolute;bottom:-16px;right:4px}
.videolist .social-buttons img{border:none;float:none}
.social-buttons a{display:inline}
.social-buttons a span.head{display:none}
.videolist small{padding-top:20px;font-size:12px}

#controler h4{text-align:right;margin:0 75px 0 0;padding:15px 0 5px 0;color:#507AA5}
#controler h4 a{color:#507AA5;text-decoration:underline}
#controler h4 a:hover{color:#74DA63;text-decoration:none}

#up{position:absolute;bottom:-5px;right:45px}
#down{position:absolute;bottom:-5px;right:25px}
#up img{background:url(images/up-down.png) no-repeat left center}
#down img{background:url(images/up-down.png) no-repeat right center}
#top-content{margin-bottom:20px}

#competition-info{float:left;width:220px;border:solid 1px #ddd;margin:10px 10px 10px 0}
#competition-info h4{background-color:#ddd;color:#000;padding-left:17px;padding-top:4px }
#competition-info h5{border:none;margin:0;padding:0 5px 0 0;display:inline}

.blog-social-stats {font-size:12px}
.blog-social-stats h3{margin:0;padding:0;font-size:14px}

.make-relative{position:relative}
.make-relative > img,.make-relative > a img ,.make-relative > a{float:none !important;z-index:100}
a.pin-it-image-button{position:absolute;bottom:25px;right:25px;z-index:200;display:block;height:34px;width:55px;background:transparent url(images/pin-it.png) no-repeat;cursor:pointer}
a.pin-it-image-button span{display:none}

.alignleft{float:left}
.alignright{float:right}

//dtpt.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<!--
   HTML 3.2
   Document type as defined on http://www.w3.org/TR/REC-html32
-->
<head>
       <title>de toate pentru toti</title>
</head>
<body><center><br><br><p>MyBusiness</p><br>
<a href="indexdtpt.html" title="enter to website"><img src="_sigla.jpg" border="none"></a><br>
<br><br>
<p>
Web master <a href="mailto:trufin_alex@yahoo.com" title="mail to me">Trufin Alex</a>
</p>
<center>
</body>
</html>



//ex1.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?
INCLUDE("conn_dtpt.php");

$sql = "SELECT * FROM domeniu,branse
WHERE domeniu.id_branse = branse.id_branse";
$resursa = mysql_query($sql);
print "<table><tr>
<td BGCOLOR='SILVER'>id_branse</td>
<td BGCOLOR='SILVER'>id_branse</td>
<td BGCOLOR='SILVER'>id_domeniu</td>
<td BGCOLOR='SILVER'>nume_branse</td>
<td BGCOLOR='SILVER'>nume_domeniu</td></tr>";

while($row = mysql_fetch_array($resursa))
{
 print "<tr><td BGCOLOR='SILVER'>"
 .$row['domeniu.id_branse'].
 "</td><td BGCOLOR='SILVER'>"
 .$row['branse.id_branse'].
 "</td></td><td BGCOLOR='SILVER'>"
 .$row['domeniu.id_domeniu'].
 "</td></td><td BGCOLOR='SILVER'>"
 .$row['branse.nume_branse'].
 "</td><td BGCOLOR='SILVER'>"
 .$row['domeniu.nume_domeniu'].
 "</td></tr>" ;
}

print "</table>";
?>
</body>
</html>

//find.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Cautare!</title>
  <LINK REL=StyleSheet HREF="dtpt.css" TITLE="" TYPE="text/css">
  </head>
<script language="javascript">

</script>
<body>
<h1>Find</h1>

<?php
error_reporting (E_ALL ^ E_NOTICE); 
INCLUDE("meniu.php");
INCLUDE("conn_dtpt.php");
?>

<form action="find.php" method="GET" name="frmCaut" id="frmCaut">
<b>Cautare</b>:
<input type="text" name="txtCaut" size="20" maxlength="20" alt="Text de cautat" value="0">
<input name="btnCaut" value="Cautare" type="submit" alt="Apasa pentru a incepe cautarea" >
</form>

<br>

<Table>
<tr>
<td>
<?
$CUVANT = $_GET['txtCaut'];
if(STRLEN($CUVANT) > 3 ){

?>
<TD VALIGN="TOP"><H1>REZULTATELE CAUTARII</H1><P>TEXTUL CAUTAT:<B><?=$CUVANT?></B></P>

<B>Branse</B><BLOCKQUOTE>

<?
$SQL = "SELECT nume_branse, id_branse FROM branse WHERE nume_branse LIKE '%".$CUVANT."%'";
$RESURSA = mysql_query($SQL);

IF(mysql_num_rows($RESURSA)== 0)
{
 PRINT '<I>NICI UN REZULTAT</I>';
}
WHILE($ROW=mysql_fetch_array($RESURSA))
{
 $nume_branse = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['nume_branse']);
 PRINT '<A HREF="branse.PHP?id_branse='.$ROW['id_branse'].'">'.$nume_branse.'</A>';
}
?>
</BLOCKQUOTE>

<B>Domenii</B>
<BLOCKQUOTE>
<?PHP
$SQL="SELECT * FROM domeniu WHERE nume_domeniu LIKE '%".$CUVANT."%'";
$RESURSA = mysql_query($SQL);
IF(mysql_num_rows($RESURSA)== 0)
{
 PRINT "<I>NICI UN REZULTAT</I>";
}
WHILE($ROW=mysql_fetch_array($RESURSA))
{
 $domeniu = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['nume_domeniu']);
 PRINT '<A HREF="domenii.PHP?id_domeniu='.$ROW['id_domeniu'].'">'.$domeniu.'</A>';
}
?>
</BLOCKQUOTE>

<B>Subdomenii</B>
<BLOCKQUOTE>
<?PHP
$SQL="SELECT * FROM subdomeniu WHERE nume_subdomeniu LIKE '%".$CUVANT."%'";
$RESURSA = mysql_query($SQL);
IF(mysql_num_rows($RESURSA)== 0)
{
 PRINT "<I>NICI UN REZULTAT</I>";
}
WHILE($ROW=mysql_fetch_array($RESURSA))
{
 $subdomeniu = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['nume_subdomeniu']);
 PRINT '<A HREF="subdomenii.PHP?id_subdomeniu='.$ROW['id_subdomeniu'].'">'.$subdomeniu.'</A>';
}
?>
</BLOCKQUOTE>

<B>Firme</B>
<BLOCKQUOTE>
<?PHP
$SQL="SELECT * FROM firma WHERE nume_firma LIKE '%".$CUVANT."%' OR strada LIKE
'%".$CUVANT."%' OR nr LIKE '%".$CUVANT."%' OR bloc LIKE '%".$CUVANT."%'
OR apartament LIKE '%".$CUVANT."%' OR telefon LIKE '%".$CUVANT."%' OR oras LIKE '%".$CUVANT."%'
OR judet LIKE '%".$CUVANT."%' OR cod_postal LIKE '%".$CUVANT."%' OR mobil LIKE '%".$CUVANT."%'
OR adresa_web LIKE '%".$CUVANT."%' OR adresa_email LIKE '%".$CUVANT."%' OR cf LIKE '%".$CUVANT."%'" ;
$RESURSA = mysql_query($SQL);
IF(mysql_num_rows($RESURSA)== 0)
{
 PRINT "<I>NICI UN REZULTAT</I>";
}
WHILE($ROW=mysql_fetch_array($RESURSA))
{
 $firma = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['nume_firma']);
 $strada = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['strada']);
 $nr = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['nr']);
 $bloc = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['bloc']);
 $apartament = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['apartament']);
 $telefon = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['telefon']);
 $oras = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['oras']);
 $judet = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['judet']);
 $codpostal = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['cod_postal']);
 $mobil = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['mobil']);
 $adresaemail = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['adresa_email']);
 $adresaweb = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['adresa_web']);
 $cf = STR_REPLACE($CUVANT,"<B>$CUVANT</B>",$ROW['cf']);

 
 PRINT '<A HREF="firme.PHP?id_firma='.$ROW['id_firma'].'">'.$firma.'
 </A><BR>'.$ROW['id_subdomeniu'].'
 <BR>'.$strada.'
 <BR>'.$nr.'
 <BR>'.$bloc.'
 <BR>'.$apartament.'
 <BR>'.$telefon.'
 <BR>'.$oras.'
 <BR>'.$judet.'
 <BR>'.$codpostal.'
 <BR>'.$mobil.'
 <BR><a href="mailto:'.$adresaemail.'">'.$adresaemail.'</a>
 <BR><a href="'.$adresaweb.'">'.$adresaweb.'</a>
 <BR>'.$cf.'';
IF(mysql_num_rows($RESURSA) > 1)
{
 PRINT "<hr>";
}
}
?>
</BLOCKQUOTE>

</td>
</tr>
</table>
<?php
}
else
{
 print 'Textul este mai mic de 6 caractere!';
}

?>
</body>
</html>

//firme.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Listare firme</title>
<LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>

<h1>Firme</h1>
<?php
INCLUDE("conn_dtpt.php");

$sql = "select * from firma, subdomeniu, domeniu, branse WHERE firma.id_subdomeniu = subdomeniu.id_subdomeniu AND subdomeniu.id_domeniu = domeniu.id_domeniu AND domeniu.id_branse = branse.id_branse ORDER BY branse.id_branse ASC";
$resursa = mysql_query($sql);
INCLUDE("meniu.php");
print "<table border='0px' cellpading='2px' >";
print"<tr><thead><td>idbranse</td>
<td>idbranse</td>
<td>iddomeniu</td>
<td>numebranse</td>
<td>numedomeniu</td>
<td>iddomeniu</td>
<td>idsubdomeniu</td>
<td>numesubdomeniu</td>
<td>idsubdomeniu</td>
<td>idfirma</td>
<td>numefirma</td>
<td>strada</td>
<td>nr</td>
<td>bloc</td>
<td>apartament</td>
<td>telefon</td>
<td>oras</td>
<td>judet</td>
<td>codpostal</td>
<td>mobil</td>
<td>adesaemail</td>
<td>adresaweb</td>
<td>cf</td></thead>
</tr>";

while($row = mysql_fetch_array($resursa))
{
 print "<tr><td>".$row['id_branse']."</td>
 <td>".$row['id_branse']."</td>
 <td>".$row['id_domeniu']."</td>
 <td>".$row['nume_branse']."</td>
 <td>".$row['nume_domeniu']."</td>
    <td>".$row['id_domeniu']."</td>
    <td>".$row['id_subdomeniu']."</td>
    <td>".$row['nume_subdomeniu']."</td>
    <td>".$row['id_subdomeniu']."</td>
    <td>".$row['id_firma']."</td>
    <td>".$row['nume_firma']."</td>
    <td>".$row['strada']."</td>
    <td>".$row['nr']."</td>
    <td>".$row['bloc']."</td>
    <td>".$row['apartament']."</td>
    <td>".$row['telefon']."</td>
    <td>".$row['oras']."</td>
    <td>".$row['judet']."</td>
    <td>".$row['cod_postal']."</td>
    <td>".$row['mobil']."</td>
    <td><a href='mailto:".$row['adresa_email']."'>".$row['adresa_email']."</a></td>
    <td><a href='".$row['adresa_web']."'>".$row['adresa_web']."</a></td>
    <td>".$row['cf']."</td>
 <tr>";
}

print "</table>";

?>

</body>
</html>
//firme2.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Conectare dtpt</title>
</head>
<body>
<?php
//afisare din cadrul resursei returnate
//a tutror datelor dintr-o tabela
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//conectare
$sql = "select firme.id_subdo, firme.firma, firme.datefirma,
firme.id_firma, subdomeniu.id_subdo ,subdomeniu.subdomeniul, subdomeniu.id_do,
domeniu.id_do, domeniu.domeniul from firme, subdomeniu, domeniu
where firme.id_subdo = subdomeniu.id_subdo AND subdomeniu.id_do = domeniu.id_do";

$resursa =mysql_query($sql);
//stabilire comanda mysql in variabile
print "<table>";
//printare cap de tabel
while($row = mysql_fetch_array($resursa))
{
 print  "<tr><td>".$row['id_subdo']."</td>
 <td>".$row['firma']."</td><td>".$row['datefirma']."</td>
 <td>".$row['id_firma']."</td></tr>";
}
//atata timp cat $row este mai mic decat $resursa printeaza cate un rand si
// coloanele corespunzatoar tabelului
print "</table>";
//inchidem tabelul
 ?>
</body>
</html>



//index.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<!--
   HTML 3.2
   Document type as defined on http://www.w3.org/TR/REC-html32
-->
<head>
       <title>de toate pentru toti</title>
</head>
<body><br><br><br><center>Wellcome to MyBussines!!</center>
<br>




<a href="adaugaredo.html" title="adaugare domeniu">adaugare domeniu</a><br>
<a href="selectare.php" title="adaugare subdomeniu">adaugare subdomeniu</a><br>
<a href="adaugaref2.php" title="adaugare firma">adaugare firma</a><br>
</body>
</html>



//index.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>dtpt</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="" TYPE="text/css">
       
</head>
<body>
<div STYLE="LEFT:5PX;TOP:50PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<center><h1 class="pagtitlu">D.T.P.T.</h1></center>
<br>
<hr>
<DIV>
<div STYLE="LEFT:90PX;TOP:190PX;WIDTH:155PX; HEIGHT:100PX;
POSITION:ABSOLUTE;BACKGROUND-COLOR:WHITE;BORDER:1PX SILVER SOLID;padding:25px">
<form action="login.php" method="POST">
<center><b class="titlu">Login!:</b></center>
<HR SIZE=1PX>
<label for="user" name="lbluser" id="lbluser" class="etichete">User:</label><br>
<center><input type="text" name="user" size="15" maxlength="15" id="user"><br></center>
<label for="pass" name="lblpass" id="lblpass" class="etichete">Password:</label><br>
<center><input type="password" name="pass" size="15" maxlength="15" id="pass"></center>
<CENTER><HR SIZE=1PX>
<input type="submit" value="Login!" id="login" name="login" title="log-in now!" class="buton">
<input type="Reset" value="Reset" id="Reset" name="Reset" title="Reset!" class="buton">
</CENTER>
</form>
</div>

<div STYLE="LEFT:300PX;TOP:200PX;WIDTH:600PX; HEIGHT:50PX;
POSITION:ABSOLUTE;BACKGROUND-COLOR:WHITE;BORDER:1PX SILVER SOLID;padding:25px">
<center><b class="titlu">Sign-in!:</b></center>
<HR SIZE=1PX><center><p class="textnormal">
Pentru a va inscrie in lista de utilizatori
ai acestui serviciu nu este nevoie decat de o adresa 
valida  de e-mail , si sa completati un formular
pe care il veti gasi accesand link-ul de mai jos.</p></center>
<HR SIZE=1PX>
<center>
<A HREF="SIGNIN.PHP" TITLE="Sign-in !" class="linknormal">Sign-in !</A>
</center>
</div>


<div STYLE="LEFT:5PX;TOP:450PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE;padding:25px">
<hr>
<center><a href="mailto:trufin_alex@yahoo.com" class="linknormal">
&COPY tralsb software 2004</a></center>
<DIV>
</body>
</html>


//jos.php

<hr>
<center><a href="mailto:trufin_alex@yahoo.com" >&COPY tralsb software 2004</a></center>

</body>
</html>

//login.php

<?php
INCLUDE("meniu.php");
INCLUDE("conn_dtpt.php");
$user=$_POST['user'];
$pass=$_POST['pass'];
print "User:".$user;
print"<br>";
print "Pass:".$pass;
?>
//meniu.php
<table>
<tr>
<td>
<input type="button" name="go" value="GO to index..." class="goclik" id="goclick" onClick="Locat();return false">
</td>
</tr>
</table>

<table><TR ><TD >
<a href="add_branse.php" title="introducere bransa de activitate nouA" class="optiunemeniu">
Bransa noua</a></TD>
<td>
<a href="add_domeniu.php" title="introducere domeniu nou" class="optiunemeniu">
Domeniu nou</a>
</TD>
<td>
<a href="add_subdomeniu.php" title="introducere subdomeniu nou" class="optiunemeniu">
Subdomeniu nou</a>
</TD>
<td>
<a href="add_firma.php" title="introducere firma noua" class="optiunemeniu">
Firma noua</a>
</TD>
</tr>


<tr>
<td>
<a href="branse.php" title="listare branse" class="optiunemeniu">Listare branse</a>
</TD>
<td>
<a href="domenii.php" title="listare domenii" class="optiunemeniu">Listare domenii</a>
</TD>
<td>
<a href="subdomenii.php" title="listare subdomenii" class="optiunemeniu">Listare subdomenii</a>
</TD>
<td>
<a href="firme.php" title="listare firme" class="optiunemeniu">Listare branse</a>
</TD></TR>

<tr>
<td>
<a href="setrecordset.php" title="recordset branse" class="optiunemeniu">
Branse Recordset</a></td>
<td>
<a href="setrecordsetdomeniu.php" title="recordset domeniu" class="optiunemeniu">
Domeniu Recordset</a></td>
<td>
<a href="setrecordsetsubdomeniu.php" title="recordset subdomeniu" class="optiunemeniu">
Subdomeniu Recordset</a></td>
<td>
<a href="setrecordsetfirma.php" title="recordset firma" class="optiunemeniu">
Firma Recordset</a></td>
</tr>
<tr>
<td>
<a href="cautare.php" title="cautare firme" class="optiunemeniu">
Cautare</a></td>
<td>
<a href="find.php" title="find" class="optiunemeniu">
Find</a></td>
</tr>
</TABLE>



//raspunssignin.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Raspuns Sign-in !</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="" TYPE="text/css">
</head>
<body>
<?php
if ($_POST['nume'] == ''||
$_POST['pnume'] == '' ||
$_POST['datan'] == '' ||
$_POST['loc'] == '' ||
$_POST['str'] == '' ||
$_POST['nrstr'] == '' ||
$_POST['bloc'] == '' ||
$_POST['ap'] == '' ||
$_POST['jud'] == '' ||
$_POST['cp'] == '' ||
$_POST['tel'] == '' ||
$_POST['cell'] == '' ||
$_POST['email'] == '' ||
$_POST['web'] == '' ||
$_POST['user'] == '' ||
$_POST['pass'] == '' ||
$_POST['passB'] == '' ){
print '<div id="eroare" class="eroare"><center>Eroare:<br><br><b class="textnormal">Nu ati introdus toate datele! </b><br><br><br>';
print '<a href="signinC.php" title="Back!" class="linknormal">Inapoi</a></div></center>';
}
else
{
 print 'Ati introdus toate datele!, Va multumim!<br>';
 print 'Nume:'.$_POST['nume'].'<br>';
 print 'Prenume:'.$_POST['pnume'].'<br>';
 print 'Data nasterii:'.$_POST['datan'].'<br>';
 print 'Localitate:'.$_POST['loc'].'<br>';
 print 'Strada:'.$_POST['str'].'<br>';
 print 'Nr:'.$_POST['nrstr'].'<br>';
 print 'Bloc:'.$_POST['bloc'].'<br>';
 print 'Apartament:'.$_POST['ap'].'<br>';
 print 'Judet:'.$_POST['jud'].'<br>';
 print 'Cod Postal:'.$_POST['cp'].'<br>';
 print 'Telefon:'.$_POST['tel'].'<br>';
 print 'Mobil:'.$_POST['cell'].'<br>';
 print 'Adresa e-mail:'.$_POST['email'].'<br>';
 print 'Pagina Web:'.$_POST['web'].'<br>';
 print 'Utilizator:'.$_POST['user'].'<br>';
 print 'Parola:'.md5($_POST['pass']).'<br>';
 print 'ParolaB:'.md5($_POST['passB']);
}

?>
</body>
</html>

//recordset.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Set de inregistrari</title>
</head>
<body>
<h1>Lista branselor existente</h1><br>

<?php
INCLUDE("conn_dtpt.php");
$sql = " SELECT * FROM branse ";
$resursa = mysql_query($sql);
$nrinr = mysql_num_rows($resursa);

print "<table>";
while($row = mysql_fetch_array($resursa))
{
 print "<tr><td bgcolor='silver'><label for='bransa' name='id'>".$row['id_branse']."</label>
 </td><td bgcolor='silver'><input type='text' maxlenght='40' size='40'
 name='bransa' value='".$row['nume_branse']."'></a></td></tr>";
}
print "</table>";

$rezultat = mysql_result($resursa,0,"nume_branse");
print '<hr>'.$rezultat;
?>
<hr> Exista <?=$nrinr?> inregistari in tabel




</body>
</html>

//selectare.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<!--
   HTML 3.2
   Document type as defined on http://www.w3.org/TR/REC-html32
-->
<head>
       <title>adaugare subdomeniu</title>

</head>

<?
//inceput forma
print '<center>
<body bgcolor="silver">
<form action="adaugarecarte_iddomeniu.php" method ="POST">
<label for="subdo">Subdomeniul</label><br>
<input type="text" name="subdo" value="scrieti subdomeniul"><br>';
?>
<?
//conectare baza de date
mysql_connect("localhost", "root", "");
mysql_select_db("dtpt");
//initiere variabila comanda mysql
$sqlb = "SELECT domeniul,id_do FROM domeniu order by id_do";
$resursab = MYSQL_QUERY($sqlb);

print '<label for="id_do">Alege un domeniu:</label><br>
<SELECT NAME="id_do">';
// printare selectare domeniu
while($row = mysql_fetch_array($resursab))
{
 print '<option value="'.$row['id_do'].'">'.$row['domeniul'].'</option>';
}

print '</select><br>
<input type="submit" value="Adauga subdomeniu">';
?>
</form>

</body>
</html>
//recordset.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Record set</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       
       
</head>
<body>
<h1>Set de inregistrari</h1>
<?php
INCLUDE("meniu.php");
?>
<hr>
<?php
INCLUDE("conn_dtpt.php");
$sql = " SELECT * FROM branse ";
$resursa = mysql_query($sql);
$nrinr = mysql_num_rows($resursa);
$nrindex = $nrinr - 1;
$nrrand=0; 

if(isset($_POST['inainte']) AND $_POST['nrcurent']< $nrindex )
{
  $nrrand = $_POST['nrcurent'] + 1;
  
}


if(isset($_POST['inapoi']) AND $_POST['nrcurent'] <= $nrindex AND $_POST['nrcurent'] > '1')
{
  $nrrand = $_POST['nrcurent'] - 1;
}


if(isset($_POST['sfarsit']) AND $_POST['nrcurent'] < $nrindex)
{
  $nrrand = $nrindex;
}

if(isset($_POST['inceput']))
{
  $nrrand = 0;
}


$numebranse = mysql_result($resursa,$nrrand,"nume_branse");
$idbranse = mysql_result($resursa,$nrrand,"id_branse");


?>
<label name="id" ><?=$idbranse?></label>
<input type="text" name="branse" id="branse"value="<?=$numebranse?>">
<form action="setrecordset.php" method="POST" class="forma" name="setdeinr">

<hr>
<input type="submit" value="|<" id="top" name="inceput" title="la inceput">
<input type="submit" value="<" id="prev" name="inapoi" title="inapoi">
<label  name="nrcurent"><?=$nrrand+1?> din <?=$nrinr?></label>
<input type="submit" value=">" id="next" name="inainte" title="inainte">
<input type="submit" value=">|" id="bottom" name="sfarsit" title="la sfarsit">
<b>|</b>
<input type="submit" value="del" id="del" name="sterge" title="sterge">
<a href="add_branse.php">Ins</a>
<input type="submit" value="save" id="save" name="salveaza" title="salveaza">
<input type="submit" value="help" id="help" name="ajutor" title="ajutor">
<input type="hidden" value="<?=$nrrand?>" name="nrcurent" >
</form>

</body>
</html>

//setrecordsetdomeniu.php



<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Record set</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       
       
</head>
<body>
<h1>Set de inregistrari</h1>
<?php
INCLUDE("meniu.php");
?>
<hr>
<?php
INCLUDE("conn_dtpt.php");
$sql = " select * from domeniu, branse WHERE domeniu.id_branse = branse.id_branse ORDER BY branse.id_branse ASC ";
$resursa = mysql_query($sql);
$nrinr = mysql_num_rows($resursa);
$nrindex = $nrinr - 1;
      $nrrand=0; 

if(isset($_POST['inainte']) AND $_POST['nrcurent']< $nrindex )
{
  $nrrand = $_POST['nrcurent'] + 1;
  
}


if(isset($_POST['inapoi']) AND $_POST['nrcurent'] <= $nrindex AND $_POST['nrcurent'] > '1')
{
  $nrrand = $_POST['nrcurent'] - 1;
}


if(isset($_POST['sfarsit']) AND $_POST['nrcurent'] < $nrindex)
{
  $nrrand = $nrindex;
}

if(isset($_POST['inceput']))
{
  $nrrand = 0;
}


$numebranse = mysql_result($resursa,$nrrand,"branse.nume_branse");
$idbranse = mysql_result($resursa,$nrrand,"branse.id_branse");
$iddomeniu = mysql_result($resursa,$nrrand,"domeniu.id_domeniu");
$numedomeniu = mysql_result($resursa,$nrrand,"domeniu.nume_domeniu");



?>
<label name="id" ><?=$idbranse?></label>
<input type="text" name="branse" id="branse"value="<?=$numebranse?>">

<label name="iddo" ><?=$iddomeniu?></label>
<input type="text" name="domeniu" id="domeniu"value="<?=$numedomeniu?>">

<form action="setrecordsetdomeniu.php" method="POST" class="forma" name="setdeinr">

<hr>
<input type="submit" value="|<" id="top" name="inceput" title="la inceput">
<input type="submit" value="<" id="prev" name="inapoi" title="inapoi">
<label  name="nrcurent"><?=$nrrand+1?> din <?=$nrinr?></label>
<input type="submit" value=">" id="next" name="inainte" title="inainte">
<input type="submit" value=">|" id="bottom" name="sfarsit" title="la sfarsit">
<b>|</b>
<input type="submit" value="del" id="del" name="sterge" title="sterge">
<a href="add_domeniu.php">Ins</a>
<input type="submit" value="save" id="save" name="salveaza" title="salveaza">
<input type="submit" value="help" id="help" name="ajutor" title="ajutor">
<input type="hidden" value="<?=$nrrand?>" name="nrcurent" >
</form>

</body>
</html>


//setrecordsetfirma.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Record set</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       
       
       
</head>
<body>
<h1>Recordset Firme</h1>

<?php
INCLUDE("conn_dtpt.php");
INCLUDE("meniu.php");
$sql = " select * from firma ,subdomeniu, domeniu, branse WHERE firma.id_subdomeniu = subdomeniu.id_subdomeniu AND subdomeniu.id_domeniu = domeniu.id_domeniu AND domeniu.id_branse = branse.id_branse ORDER BY branse.id_branse ASC ";
$resursa = mysql_query($sql);
$nrinr = mysql_num_rows($resursa);
$nrindex = $nrinr - 1;
    $nrrand=0; 
if(isset($_POST['sterge']))
{
$sqlD = "DELETE from firma WHERE id_firma = ".$_POST['idfirma'] ;
mysql_query($sqlD);
}

if(isset($_POST['salveaza']))
{
$sqlm = "UPDATE firma SET nume_firma='".$_POST['numefirma']."'
,strada='".$_POST['str']."',nr='".$_POST['nr']."'
,bloc='".$_POST['bl']."',apartament='".$_POST['ap']."'
,telefon='".$_POST['tel']."',oras='".$_POST['loc']."'
,judet='".$_POST['jud']."',cod_postal='".$_POST['cp']."'
,mobil='".$_POST['cell']."',adresa_email='".$_POST['email']."'
,adresa_web='".$_POST['www']."',cf='".$_POST['cf']."'
WHERE id_firma = ".$_POST['idfirmah'] ;
mysql_query($sqlm);
print '<b>Modificarea a fost facuta!</b><br>';
echo "\n<meta http-equiv=\"refresh\" "
        . " content=\"3;URL=setrecordsetfirma.php\">\n";

}

if(isset($_POST['inainte']) AND $_POST['nrcurent']< $nrindex )
{
  $nrrand = $_POST['nrcurent'] + 1;
  
}


if(isset($_POST['inapoi']) AND $_POST['nrcurent'] <= $nrindex AND $_POST['nrcurent'] > '1')
{
  $nrrand = $_POST['nrcurent'] - 1;
}


if(isset($_POST['sfarsit']) AND $_POST['nrcurent'] < $nrindex)
{
  $nrrand = $nrindex;
}

if(isset($_POST['inceput']))
{
  $nrrand = 0;
}


$numebranse = mysql_result($resursa,$nrrand,"branse.nume_branse");
$idbranse = mysql_result($resursa,$nrrand,"branse.id_branse");
$iddomeniu = mysql_result($resursa,$nrrand,"domeniu.id_domeniu");
$numedomeniu = mysql_result($resursa,$nrrand,"domeniu.nume_domeniu");
$idsubdomeniu = mysql_result($resursa,$nrrand,"subdomeniu.id_subdomeniu");
$numesubdomeniu = mysql_result($resursa,$nrrand,"subdomeniu.nume_subdomeniu");
$idfirma = mysql_result($resursa,$nrrand,"firma.id_firma");
$numefirma = mysql_result($resursa,$nrrand,"firma.nume_firma");
$strada = mysql_result($resursa,$nrrand,"firma.strada");
$nr = mysql_result($resursa,$nrrand,"firma.nr");
$bloc = mysql_result($resursa,$nrrand,"firma.bloc");
$apartament = mysql_result($resursa,$nrrand,"firma.apartament");
$telefon = mysql_result($resursa,$nrrand,"firma.telefon");
$oras = mysql_result($resursa,$nrrand,"firma.oras");
$judet = mysql_result($resursa,$nrrand,"firma.judet");
$codpostal = mysql_result($resursa,$nrrand,"firma.cod_postal");
$mobil = mysql_result($resursa,$nrrand,"firma.mobil");
$adresaemail = mysql_result($resursa,$nrrand,"firma.adresa_email");
$adresaweb = mysql_result($resursa,$nrrand,"firma.adresa_web");
$cf = mysql_result($resursa,$nrrand,"firma.cf");


?>
<hr>
<label name="id" for="branse"><?=$idbranse?></label>
<input type="text" name="branse" id="branse" value="<?=$numebranse?>">
<br>
<label name="iddo" for="domeniu"><?=$iddomeniu?></label>
<input type="text" name="domeniu" id="domeniu" value="<?=$numedomeniu?>">
<br>
<label name="idsudo" for="subdomeniu"><?=$idsubdomeniu?></label>
<input type="text" name="subdomeniu" id="subdomeniu" value="<?=$numesubdomeniu?>">
<br>
<label name="lblidfirma" for="firma"><?=$idfirma?></label>

<form action="setrecordsetfirma.php" method="POST" class="forma" name="setdeinr">

<input type="text" name="numefirma" id="firma" value="<?=$numefirma?>">
<br>
<input type="text" name="str" id="str" value="<?=$strada?>">
<input type="text" name="nr" id="nr" value="<?=$nr?>">
<input type="text" name="bl" id="bl" value="<?=$bloc?>">
<input type="text" name="ap" id="ap" value="<?=$apartament?>">
<input type="text" name="tel" id="tel" value="<?=$telefon?>">
<input type="text" name="loc" id="loc" value="<?=$oras?>">
<input type="text" name="jud" id="jud" value="<?=$judet?>">
<input type="text" name="cp" id="cp" value="<?=$codpostal?>">
<input type="text" name="cell" id="cell" value="<?=$mobil?>">
<input type="text" name="email" id="email" value="<?=$adresaemail?>">
<input type="text" name="www" id="www" value="<?=$adresaweb?>">
<input type="text" name="cf" id="cf" value="<?=$cf?>">




<hr>
<input type="submit" value="|<" id="top" name="inceput" title="la inceput">
<input type="submit" value="<" id="prev" name="inapoi" title="inapoi">
<label  name="nrcurent"><?=$nrrand+1?> din <?=$nrinr?></label>
<input type="submit" value=">" id="next" name="inainte" title="inainte">
<input type="submit" value=">|" id="bottom" name="sfarsit" title="la sfarsit">
<b>|</b>
<input type="submit" value="del" id="del" name="sterge" title="sterge">
<a href="add_firma.php">Ins</a>
<input type="submit" value="save" id="save" name="salveaza" title="salveaza">
<input type="submit" value="help" id="help" name="ajutor" title="ajutor">
<input type="hidden" value="<?=$nrrand?>" name="nrcurent" >
<input type="hidden" value="<?=$idfirma?>" name="idfirma" >


</form>

</body>
</html>

//setrecordsetdomeniu.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Record set</title>
       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       
       
</head>
<body>
<h1>Set de inregistrari</h1>
<?php
INCLUDE("meniu.php");
?>
<hr>
<?php
INCLUDE("conn_dtpt.php");
$sql = " select * from subdomeniu, domeniu, branse WHERE subdomeniu.id_domeniu = domeniu.id_domeniu AND domeniu.id_branse = branse.id_branse ORDER BY branse.id_branse ASC ";
$resursa = mysql_query($sql);
$nrinr = mysql_num_rows($resursa);
$nrindex = $nrinr - 1;
      $nrrand=0; 

if(isset($_POST['inainte']) AND $_POST['nrcurent']< $nrindex )
{
  $nrrand = $_POST['nrcurent'] + 1;
  
}


if(isset($_POST['inapoi']) AND $_POST['nrcurent'] <= $nrindex AND $_POST['nrcurent'] > '1')
{
  $nrrand = $_POST['nrcurent'] - 1;
}


if(isset($_POST['sfarsit']) AND $_POST['nrcurent'] < $nrindex)
{
  $nrrand = $nrindex;
}

if(isset($_POST['inceput']))
{
  $nrrand = 0;
}


$numebranse = mysql_result($resursa,$nrrand,"branse.nume_branse");
$idbranse = mysql_result($resursa,$nrrand,"branse.id_branse");
$iddomeniu = mysql_result($resursa,$nrrand,"domeniu.id_domeniu");
$numedomeniu = mysql_result($resursa,$nrrand,"domeniu.nume_domeniu");
$idsubdomeniu = mysql_result($resursa,$nrrand,"subdomeniu.id_subdomeniu");
$numesubdomeniu = mysql_result($resursa,$nrrand,"subdomeniu.nume_subdomeniu");


?>
<label name="id" for="branse"><?=$idbranse?></label>
<input type="text" name="branse" id="branse"value="<?=$numebranse?>">

<label name="iddo" for="domeniu"><?=$iddomeniu?></label>
<input type="text" name="domeniu" id="domeniu"value="<?=$numedomeniu?>">

<label name="idsudo" for="subdomeniu"><?=$idsubdomeniu?></label>
<input type="text" name="subdomeniu" id="subdomeniu"value="<?=$numesubdomeniu?>">


<form action="setrecordsetsubdomeniu.php" method="POST" class="forma" name="setdeinr">

<hr>
<input type="submit" value="|<" id="top" name="inceput" title="la inceput">
<input type="submit" value="<" id="prev" name="inapoi" title="inapoi">
<label  name="nrcurent"><?=$nrrand+1?> din <?=$nrinr?></label>
<input type="submit" value=">" id="next" name="inainte" title="inainte">
<input type="submit" value=">|" id="bottom" name="sfarsit" title="la sfarsit">
<b>|</b>
<input type="submit" value="del" id="del" name="sterge" title="sterge">
<a href="add_subdomeniu.php">Ins</a>
<input type="submit" value="save" id="save" name="salveaza" title="salveaza">
<input type="submit" value="help" id="help" name="ajutor" title="ajutor">
<input type="hidden" value="<?=$nrrand?>" name="nrcurent" >
</form>

</body>
</html>

//singin.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>dtpt sign-in</title>
       <META NAME="save" CONTENT="history">

       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       <script language="javascript">
      
       function verifica(){
        if((document.signinformular.nume.value == "")||(document.signinformular.nume.value == "nume")){
         alert("Completati numele!");
         document.signinformular.nume.focus();
         return false;
        }
        if((document.signinformular.pnume.value == "")||(document.signinformular.pnume.value == "prenume")){
         alert("Completati prenumele!");
         document.signinformular.pnume.focus();
         return false;
        }
        if((document.signinformular.datan.value == "")||(document.signinformular.datan.value == "zzllaaaa")){
         alert("Completati data nasterii!");
         document.signinformular.datan.focus();
         return false;
        }
        if((document.signinformular.loc.value == "")||(document.signinformular.loc.value == "localitatea")){
         alert("Completati localitatea!");
         document.signinformular.loc.focus();
         return false;
        }
        if((document.signinformular.str.value == "")||(document.signinformular.str.value == "strada")){
         alert("Completati strada!");
         document.signinformular.str.focus();
         return false;
        }
        if((document.signinformular.nrstr.value == "")||(document.signinformular.nrstr.value == "66")){
         alert("Completati numarul strazii!");
         document.signinformular.nrstr.focus();
         return false;
        }
        if((document.signinformular.bloc.value == "")||(document.signinformular.bloc.value == "b2")){
         alert("Completati blocul!");
         document.signinformular.bloc.focus();
         return false;
        }
        if((document.signinformular.ap.value == "")||(document.signinformular.ap.value == "11a")){
         alert("Completati numarul de apartament!");
         document.signinformular.ap.focus();
         return false;
        }
        if((document.signinformular.jud.value == "")||(document.signinformular.jud.value == "judetul")){
         alert("Completati judetul!");
         document.signinformular.jud.focus();
         return false;
        }
        if((document.signinformular.cp.value == "")||(document.signinformular.cp.value == "123456")){
         alert("Completati codul postal!");
         document.signinformular.cp.focus();
         return false;
        }
        if((document.signinformular.tel.value == "")||(document.signinformular.tel.value == "0269234723")){
         alert("Completati numarul telefon!");
         document.signinformular.tel.focus();
         return false;
        }
        if((document.signinformular.cell.value == "")||(document.signinformular.mobil.value == "0766776643")){
         alert("Completati numarul de mobil!");
         document.signinformular.cell.focus();
         return false;
        }
        if((document.signinformular.email.value == "")||(document.signinformular.email.value == "trufin_alex@yahoo.com")){
         alert("Completati adresa de e-mail!");
         document.signinformular.email.focus();
         return false;
        }
        if((document.signinformular.web.value == "")||(document.signinformular.web.value == "www.tralsb.ro")){
         alert("Completati adresa web!");
         document.signinformular.web.focus();
         return false;
        }
        if((document.signinformular.user.value == "")||(document.signinformular.user.value == "utilizator")){
         alert("Completati numele de utilizator!");
         document.signinformular.user.focus();
         return false;
        }
        if((document.signinformular.pass.value == "")||(document.signinformular.pass.value.lenght<6)){
         alert("Completati parola, sau aceasta nu are minim 6 caractere!");
         document.signinformular.pass.focus();
         return false;
        }
        if(document.signinformular.passB.value == ""){
         alert("Nu ati introdus parola pentru verificare!");
         document.signinformular.passB.focus();
         return false;
        }
        if(document.signinformular.passB.value != document.signinformular.pass.value ){
         alert("Ati introdus doua parole diferite !");
         document.signinformular.pass.focus();
         return false;
        }
        if((document.signinformular.email.value == "" )||
     (document.signinformular.email.value.indexOf('@') == -1)||
     (document.signinformular.email.value.indexOf('.') == -1)||
     (document.signinformular.email.value.lenght<6))
     {
   alert("Adresa de email nu este valida!");
   document.signinformular.email.focus();
   return false;
  }
  
    if((document.signinformular.cp.value.lenght<6))
     {
   alert("Codul postal trebuie sa fie de exact 6 cifre!");
   document.signinformular.cp.focus();
   return false;
  }
  
  if((document.signinformular.web.value == "" )||
     (document.signinformular.web.value.indexOf('www') == -1)||
     (document.signinformular.web.value.indexOf('.') == -1)||
     (document.signinformular.web.value.lenght<6))
     {
   alert("Adresa de web nu este valida!");
   document.signinformular.web.focus();
   return false;
  }
       }

       function Confirma(){
input_box=confirm("Formularul va fi resetat!");
if (input_box == true)
{
 document.signinformular.reset();
}
else
{
 return false;
}
}

function Acord(){
input_box=confirm("Trimiteti datele!");
if (input_box == true)
{
 document.signinformular.submit();
}
else
{
 return false;
}
}
      </script>
       
       
       
       
</head>
<body>
<div STYLE="LEFT:5PX;TOP:80PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<center><h1 class="pagtitlu">D.T.P.T.</h1></center>

<hr>

<DIV>
<div STYLE="LEFT:200PX;TOP:190PX;WIDTH:500PX; HEIGHT:580PX;
POSITION:ABSOLUTE;BACKGROUND-COLOR:WHITE;BORDER:1PX SILVER SOLID;padding:25px">
<form action="raspunssignin.php" method="POST" name="signinformular" id="signinformular" onsubmit="return verifica()">
<center><b class="titlu">Sign-in !:</b></center>
<HR SIZE=1PX>

<label class="etichete" for="nume" name="lblnume" id="lblnume">Nume:</label><br>
<input value="nume" type="text" name="nume" size="25" maxlength="25" id="nume" class='saveHistory' ><br>
<label class="etichete" for="pnume" name="lblpnume" id="lblpnume">Prenume:</label><br>
<input value="prenume" type="text" name="pnume" size="50" maxlength="50" id="pnume" class='saveHistory'><br>

<label class="etichete" for="datan" name="lbldtn" id="lbldtn">Data nasterii:</label><br>
<input value="zzllaaaa" type="text" name="datan" size="8" maxlength="8" id="datan" class='saveHistory'><br>
<label class="etichete" for="loc" name="lblloc" id="lblloc">Localitatea:</label><br>
<input value="localitatea" type="text" name="loc" size="50" maxlength="50" id="loc" class='saveHistory'><br>

<label class="etichete" for="str" name="lblstr" id="lblstr">Strada:</label><br>
<input value="strada" type="text" name="str" size="50" maxlength="50" id="str" class='saveHistory'><br>
<label class="etichete" for="nrstr" name="lblnrstr" id="lblnrstr">Nr:</label><br>
<input value="66" type="text" name="nrstr" size="5" maxlength="5" id="nrstr" class='saveHistory'><br>

<label class="etichete" for="bloc" name="lblbloc" id="lblbloc">Bloc:</label><br>
<input value="b2" type="text" name="bloc" size="10" maxlength="10" id="bloc" class='saveHistory'><br>
<label class="etichete" for="ap" name="lblap" id="lblap">Ap:</label><br>
<input value="11a" type="text" name="ap" size="5" maxlength="5" id="ap" class='saveHistory'><br>

<label class="etichete" for="jud" name="lbljud" id="lbljud">Judetul:</label><br>
<input value="judetul" type="text" name="jud" size="30" maxlength="30" id="jud" class='saveHistory'><br>
<label class="etichete" for="cp" name="lblcp" id="lblcp">Cod Postal:</label><br>
<input value="123456" type="text" name="cp" size="6" maxlength="6" id="cp" class='saveHistory'><br>

<label class="etichete" for="tel" name="lbltel" id="lbltel">Telefon:</label><br>
<input value="0269234723" type="text" name="tel" size="15" maxlength="15" id="tel" class='saveHistory'><br>
<label class="etichete" for="cell" name="lblcell" id="lblcell">Mobil:</label><br>
<input value="0766776643" type="text" name="cell" size="15" maxlength="15" id="cell" class='saveHistory'><br>

<label class="etichete" for="email" name="lblemail" id="lblemail">Adresa e-mail:</label><br>
<input value="trufin_alex@yahoo.com" type="text" name="email" size="50" maxlength="50" id="email" class='saveHistory'><br>
<label class="etichete" for="web" name="lblweb" id="lblweb">Adresa pagina web:</label><br>
<input value="www.tralsb.ro" type="text" name="web" size="50" maxlength="50" id="web" class='saveHistory'><br>

<label class="etichete" for="user" name="lbluser" id="lbluser">User:</label><br>
<input value="utilizator" type="text" name="user" size="15" maxlength="15" id="user" class='saveHistory'><br>
<label class="etichete" for="pass" name="lblpass" id="lblpass">Password:</label><br>
<input type="password" name="pass" size="15" maxlength="15" id="pass" class='saveHistory'><br>

<label class="etichete" for="passB" name="lblpassB" id="lblpassB">Password Verificare:</label><br>
<input type="password" name="passB" size="15" maxlength="15" id="passB" class='saveHistory'><br>


<CENTER><HR SIZE=1PX>

<input type="submit" value="Sign-in!" id="signin" name="signin" title="sign-in now!" class="buton" >
<!-- onclick="Acord()" -->
<input type="Reset" value="Reset" id="Reset" name="Reset" title="Reset!" class="buton" onclick="Confirma()">
</CENTER>
</form>
</div>



<div STYLE="LEFT:5PX;TOP:1000PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<hr>
<center><a href="mailto:trufin_alex@yahoo.com" class="linknormal">
&COPY tralsb software 2004</a></center>
<DIV>
</body>
</html>



//singin3f.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body><center>
<form action="SIGNINP2.PHP" method="POST">
<label for="user">User:</label><br>
<input type="text" name="user" size="15" maxlenght=40><BR>
<input type="submit" NAME="SUBMIT BUTON" value="Sign-in !">
</form></center>
</body>
</html>


/singinb.php


<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>dtpt sign-in</title>
       <META NAME="save" CONTENT="history">

       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       <script language="javascript">
      
       function verifica(){
        if((document.signinformular.nume.value == "")||(document.signinformular.nume.value == "nume")){
         alert("Completati numele!");
         document.signinformular.nume.focus();
         return false;
        }
        if((document.signinformular.pnume.value == "")||(document.signinformular.pnume.value == "prenume")){
         alert("Completati prenumele!");
         document.signinformular.pnume.focus();
         return false;
        }
        if((document.signinformular.datan.value == "")||(document.signinformular.datan.value == "zzllaaaa")){
         alert("Completati data nasterii!");
         document.signinformular.datan.focus();
         return false;
        }
        if((document.signinformular.loc.value == "")||(document.signinformular.loc.value == "localitatea")){
         alert("Completati localitatea!");
         document.signinformular.loc.focus();
         return false;
        }
        if((document.signinformular.str.value == "")||(document.signinformular.str.value == "strada")){
         alert("Completati strada!");
         document.signinformular.str.focus();
         return false;
        }
        if((document.signinformular.nrstr.value == "")||(document.signinformular.nr.value == "66")){
         alert("Completati numarul strazii!");
         document.signinformular.nrstr.focus();
         return false;
        }
        if((document.signinformular.bloc.value == "")||(document.signinformular.bloc.value == "b2")){
         alert("Completati blocul!");
         document.signinformular.bloc.focus();
         return false;
        }
        if((document.signinformular.ap.value == "")||(document.signinformular.ap.value == "11a")){
         alert("Completati numarul de apartament!");
         document.signinformular.ap.focus();
         return false;
        }
        if((document.signinformular.jud.value == "")||(document.signinformular.jud.value == "judetul")){
         alert("Completati judetul!");
         document.signinformular.jud.focus();
         return false;
        }
        if((document.signinformular.cp.value == "")||(document.signinformular.cp.value == "123456")){
         alert("Completati codul postal!");
         document.signinformular.cp.focus();
         return false;
        }
        if((document.signinformular.tel.value == "")||(document.signinformular.tel.value == "0269234723")){
         alert("Completati numarul telefon!");
         document.signinformular.tel.focus();
         return false;
        }
        if((document.signinformular.cell.value == "")||(document.signinformular.mobil.value == "0766776643")){
         alert("Completati numarul de mobil!");
         document.signinformular.cell.focus();
         return false;
        }
        if((document.signinformular.email.value == "")||(document.signinformular.email.value == "trufin_alex@yahoo.com")){
         alert("Completati adresa de e-mail!");
         document.signinformular.email.focus();
         return false;
        }
        if((document.signinformular.web.value == "")||(document.signinformular.web.value == "www.tralsb.ro")){
         alert("Completati adresa web!");
         document.signinformular.web.focus();
         return false;
        }
        if((document.signinformular.user.value == "")||(document.signinformular.user.value == "utilizator")){
         alert("Completati numele de utilizator!");
         document.signinformular.user.focus();
         return false;
        }
        if((document.signinformular.pass.value == "")||(document.signinformular.pass.value.lenght<6)){
         alert("Completati parola, sau aceasta nu are minim 6 caractere!");
         document.signinformular.pass.focus();
         return false;
        }
        if(document.signinformular.passB.value == ""){
         alert("Nu ati introdus parola pentru verificare!");
         document.signinformular.passB.focus();
         return false;
        }
        if(document.signinformular.passB.value != document.signinformular.pass.value ){
         alert("Ati introdus doua parole diferite !");
         document.signinformular.pass.focus();
         return false;
        }
        if((document.signinformular.email.value == "" )||
     (document.signinformular.email.value.indexOf('@') == -1)||
     (document.signinformular.email.value.indexOf('.') == -1)||
     (document.signinformular.email.value.lenght<6))
     {
   alert("Adresa de email nu este valida!");
   document.signinformular.email.focus();
   return false;
  }
  
    if((document.signinformular.cp.value.lenght<6))
     {
   alert("Codul postal trebuie sa fie de exact 6 cifre!");
   document.signinformular.cp.focus();
   return false;
  }
  
  if((document.signinformular.web.value == "" )||
     (document.signinformular.web.value.indexOf('www') == -1)||
     (document.signinformular.web.value.indexOf('.') == -1)||
     (document.signinformular.web.value.lenght<6))
     {
   alert("Adresa de web nu este valida!");
   document.signinformular.web.focus();
   return false;
  }
       }

       function Confirma(){
input_box=confirm("Formularul va fi resetat!");
if (input_box == true)
{
 document.signinformular.reset();
}
else
{
 return false;
}
}

function Acord(){
input_box=confirm("Trimiteti datele!");
if (input_box == true)
{
 document.signinformular.submit();
}
else
{
 return false;
}
}
      </script>
       
       
       
       
</head>
<body>
<div STYLE="LEFT:5PX;TOP:80PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<center><h1 class="pagtitlu">D.T.P.T.</h1></center>

<hr>

<DIV>
<div STYLE="LEFT:200PX;TOP:190PX;WIDTH:500PX; HEIGHT:580PX;
POSITION:ABSOLUTE;BACKGROUND-COLOR:WHITE;BORDER:1PX SILVER SOLID;padding:25px">
<form action="raspunssignin.php" method="POST" name="signinformular" id="signinformular" onsubmit="return verifica()">
<center><b class="titlu">Sign-in !:</b></center>
<HR SIZE=1PX>

<label class="etichete" for="nume" name="lblnume" id="lblnume">Nume:</label><br>
<input value="nume" type="text" name="nume" size="25" maxlength="25" id="nume" class='saveHistory' ><br>
<label class="etichete" for="pnume" name="lblpnume" id="lblpnume">Prenume:</label><br>
<input value="prenume" type="text" name="pnume" size="50" maxlength="50" id="pnume" class='saveHistory'><br>

<label class="etichete" for="datan" name="lbldtn" id="lbldtn">Data nasterii:</label><br>
<br>
<table>
<tr>
<td>
<select name="ziua" class="saveHistory" id="ziuadata">
<option>...</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
</td>
<td><select name="luna" class="saveHistory" id="lunadata">
<option>...</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select></td>
<td><select name="anul" class="saveHistory" id="anuldata">
<option>...</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select></td>
</tr></table>
<br>



<label class="etichete" for="loc" name="lblloc" id="lblloc">Localitatea:</label><br>
<input value="localitatea" type="text" name="loc" size="50" maxlength="50" id="loc" class='saveHistory'><br>

<label class="etichete" for="str" name="lblstr" id="lblstr">Strada:</label><br>
<input value="strada" type="text" name="str" size="50" maxlength="50" id="str" class='saveHistory'><br>
<label class="etichete" for="nrstr" name="lblnrstr" id="lblnrstr">Nr:</label><br>
<input value="66" type="text" name="nrstr" size="5" maxlength="5" id="nrstr" class='saveHistory'><br>

<label class="etichete" for="bloc" name="lblbloc" id="lblbloc">Bloc:</label><br>
<input value="b2" type="text" name="bloc" size="10" maxlength="10" id="bloc" class='saveHistory'><br>
<label class="etichete" for="ap" name="lblap" id="lblap">Ap:</label><br>
<input value="11a" type="text" name="ap" size="5" maxlength="5" id="ap" class='saveHistory'><br>

<label class="etichete" for="jud" name="lbljud" id="lbljud">Judetul:</label><br>
<input value="judetul" type="text" name="jud" size="30" maxlength="30" id="jud" class='saveHistory'><br>
<label class="etichete" for="cp" name="lblcp" id="lblcp">Cod Postal:</label><br>
<input value="123456" type="text" name="cp" size="6" maxlength="6" id="cp" class='saveHistory'><br>

<label class="etichete" for="tel" name="lbltel" id="lbltel">Telefon:</label><br>
<input value="0269234723" type="text" name="tel" size="15" maxlength="15" id="tel" class='saveHistory'><br>
<label class="etichete" for="cell" name="lblcell" id="lblcell">Mobil:</label><br>
<input value="0766776643" type="text" name="cell" size="15" maxlength="15" id="cell" class='saveHistory'><br>

<label class="etichete" for="email" name="lblemail" id="lblemail">Adresa e-mail:</label><br>
<input value="trufin_alex@yahoo.com" type="text" name="email" size="50" maxlength="50" id="email" class='saveHistory'><br>
<label class="etichete" for="web" name="lblweb" id="lblweb">Adresa pagina web:</label><br>
<input value="www.tralsb.ro" type="text" name="web" size="50" maxlength="50" id="web" class='saveHistory'><br>

<label class="etichete" for="user" name="lbluser" id="lbluser">User:</label><br>
<input value="utilizator" type="text" name="user" size="15" maxlength="15" id="user" class='saveHistory'><br>
<label class="etichete" for="pass" name="lblpass" id="lblpass">Password:</label><br>
<input type="password" name="pass" size="15" maxlength="15" id="pass" class='saveHistory'><br>

<label class="etichete" for="passB" name="lblpassB" id="lblpassB">Password Verificare:</label><br>
<input type="password" name="passB" size="15" maxlength="15" id="passB" class='saveHistory'><br>


<CENTER><HR SIZE=1PX>

<input type="submit" value="Sign-in!" id="signin" name="signin" title="sign-in now!" class="buton" >
<!-- onclick="Acord()" -->
<input type="Reset" value="Reset" id="Reset" name="Reset" title="Reset!" class="buton" onclick="Confirma()">
</CENTER>
</form>
</div>



<div STYLE="LEFT:5PX;TOP:1000PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<hr>
<center><a href="mailto:trufin_alex@yahoo.com" class="linknormal">
&COPY tralsb software 2004</a></center>
<DIV>
</body>
</html>

singinc.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>dtpt sign-in</title>
       <META NAME="save" CONTENT="history">

       <LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
       <script language="javascript">
      
       function verifica(){
        if(document.signinformular.nume.value == ""){
         alert("Completati numele!");
         document.signinformular.nume.focus();
         return false;
        }
        if(document.signinformular.pnume.value == ""){
         alert("Completati prenumele!");
         document.signinformular.pnume.focus();
         return false;
        }
        if((document.signinformular.datan.value == "")||(typeof(document.signinformular.datan.value)!= 'number' )){
         alert("Completati data nasterii!");
         document.signinformular.datan.focus();
         return false;
        }
        if(document.signinformular.loc.value == ""){
         alert("Completati localitatea!");
         document.signinformular.loc.focus();
         return false;
        }
        if(document.signinformular.str.value == ""){
         alert("Completati strada!");
         document.signinformular.str.focus();
         return false;
        }
        if(document.signinformular.nrstr.value == ""){
         alert("Completati numarul strazii!");
         document.signinformular.nrstr.focus();
         return false;
        }
        if(document.signinformular.bloc.value == ""){
         alert("Completati blocul!");
         document.signinformular.bloc.focus();
         return false;
        }
        if(document.signinformular.ap.value == ""){
         alert("Completati numarul de apartament!");
         document.signinformular.ap.focus();
         return false;
        }
        if(document.signinformular.jud.value == ""){
         alert("Completati judetul!");
         document.signinformular.jud.focus();
         return false;
        }
        if(document.signinformular.cp.value == ""){
         alert("Completati codul postal!");
         document.signinformular.cp.focus();
         return false;
        }
        if(document.signinformular.tel.value == ""){
         alert("Completati numarul telefon!");
         document.signinformular.tel.focus();
         return false;
        }
        if(document.signinformular.cell.value == ""){
         alert("Completati numarul de mobil!");
         document.signinformular.cell.focus();
         return false;
        }
        if(document.signinformular.email.value == ""){
         alert("Completati adresa de e-mail!");
         document.signinformular.email.focus();
         return false;
        }
        if(document.signinformular.web.value == ""){
         alert("Completati adresa web!");
         document.signinformular.web.focus();
         return false;
        }
        if(document.signinformular.user.value == ""){
         alert("Completati numele de utilizator!");
         document.signinformular.user.focus();
         return false;
        }
        if((document.signinformular.pass.value == "")||(document.signinformular.pass.value.lenght<6)){
         alert("Completati parola, sau aceasta nu are minim 6 caractere!");
         document.signinformular.pass.focus();
         return false;
        }
        if(document.signinformular.passB.value == ""){
         alert("Nu ati introdus parola pentru verificare!");
         document.signinformular.passB.focus();
         return false;
        }
        if(document.signinformular.passB.value != document.signinformular.pass.value ){
         alert("Ati introdus doua parole diferite !");
         document.signinformular.pass.focus();
         return false;
        }
        if((document.signinformular.email.value == "" )||(document.signinformular.email.value.indexOf('@') == -1)||(document.signinformular.email.value.indexOf('.') == -1)||(document.signinformular.email.value.lenght<6))
     {
   alert("Adresa de email nu este valida!");
   document.signinformular.email.focus();
   return false;
  }
  
    if((document.signinformular.cp.value.lenght<6))
     {
   alert("Codul postal trebuie sa fie de exact 6 cifre!");
   document.signinformular.cp.focus();
   return false;
  }
  
  if((document.signinformular.web.value == "" )||(document.signinformular.web.value.indexOf('www') == -1)||(document.signinformular.web.value.indexOf('.') == -1)||(document.signinformular.web.value.lenght<6))
     {
   alert("Adresa de web nu este valida!");
   document.signinformular.web.focus();
   return false;
  }
       }

       function Confirma(){
input_box=confirm("Formularul va fi resetat!");
if (input_box == true)
{
 document.signinformular.reset();
}
else
{
 return false;
}
}

function Acord(){
input_box=confirm("Trimiteti datele!");
if (input_box == true)
{
 document.signinformular.submit();
}
else
{
 return false;
}
}
      </script>
       
       
       
       
</head>
<body>
<div STYLE="LEFT:5PX;TOP:80PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<center><h1 class="pagtitlu">D.T.P.T.</h1></center>

<hr>

<DIV>
<div STYLE="LEFT:200PX;TOP:190PX;WIDTH:500PX; HEIGHT:580PX;
POSITION:ABSOLUTE;BACKGROUND-COLOR:WHITE;BORDER:1PX SILVER SOLID;padding:25px">
<form action="raspunssignin.php" method="POST" name="signinformular" id="signinformular" onsubmit="return verifica()">
<center><b class="titlu">Sign-in !:</b></center>
<HR SIZE=1PX>

<label class="etichete" for="nume" name="lblnume" id="lblnume">Nume:</label><br>
<input type="text" name="nume" size="25" maxlength="25" id="nume" class='saveHistory' ><br>
<label class="etichete" for="pnume" name="lblpnume" id="lblpnume">Prenume:</label><br>
<input type="text" name="pnume" size="50" maxlength="50" id="pnume" class='saveHistory'><br>

<label class="etichete" for="datan" name="lbldtn" id="lbldtn">Data nasterii:</label><br>
<input type="text" name="datan" size="8" maxlength="8" id="datan" class='saveHistory'><br>
<label class="etichete" for="loc" name="lblloc" id="lblloc">Localitatea:</label><br>
<input type="text" name="loc" size="50" maxlength="50" id="loc" class='saveHistory'><br>

<label class="etichete" for="str" name="lblstr" id="lblstr">Strada:</label><br>
<input type="text" name="str" size="50" maxlength="50" id="str" class='saveHistory'><br>
<label class="etichete" for="nrstr" name="lblnrstr" id="lblnrstr">Nr:</label><br>
<input type="text" name="nrstr" size="5" maxlength="5" id="nrstr" class='saveHistory'><br>

<label class="etichete" for="bloc" name="lblbloc" id="lblbloc">Bloc:</label><br>
<input type="text" name="bloc" size="10" maxlength="10" id="bloc" class='saveHistory'><br>
<label class="etichete" for="ap" name="lblap" id="lblap">Ap:</label><br>
<input type="text" name="ap" size="5" maxlength="5" id="ap" class='saveHistory'><br>

<label class="etichete" for="jud" name="lbljud" id="lbljud">Judetul:</label><br>
<input type="text" name="jud" size="30" maxlength="30" id="jud" class='saveHistory'><br>
<label class="etichete" for="cp" name="lblcp" id="lblcp">Cod Postal:</label><br>
<input type="text" name="cp" size="6" maxlength="6" id="cp" class='saveHistory'><br>

<label class="etichete" for="tel" name="lbltel" id="lbltel">Telefon:</label><br>
<input type="text" name="tel" size="15" maxlength="15" id="tel" class='saveHistory'><br>
<label class="etichete" for="cell" name="lblcell" id="lblcell">Mobil:</label><br>
<input type="text" name="cell" size="15" maxlength="15" id="cell" class='saveHistory'><br>

<label class="etichete" for="email" name="lblemail" id="lblemail">Adresa e-mail:</label><br>
<input type="text" name="email" size="50" maxlength="50" id="email" class='saveHistory'><br>
<label class="etichete" for="web" name="lblweb" id="lblweb">Adresa pagina web:</label><br>
<input type="text" name="web" size="50" maxlength="50" id="web" class='saveHistory'><br>

<label class="etichete" for="user" name="lbluser" id="lbluser">User:</label><br>
<input type="text" name="user" size="15" maxlength="15" id="user" class='saveHistory'><br>
<label class="etichete" for="pass" name="lblpass" id="lblpass">Password:</label><br>
<input type="password" name="pass" size="15" maxlength="15" id="pass" class='saveHistory'><br>

<label class="etichete" for="passB" name="lblpassB" id="lblpassB">Password Verificare:</label><br>
<input type="password" name="passB" size="15" maxlength="15" id="passB" class='saveHistory'><br>


<CENTER><HR SIZE=1PX>

<input type="submit" value="Sign-in!" id="signin" name="signin" title="sign-in now!" class="buton" onclick="Acord()">
<input type="Reset" value="Reset" id="Reset" name="Reset" title="Reset!" class="buton" onclick="Confirma()">
</CENTER>
</form>
</div>



<div STYLE="LEFT:5PX;TOP:1000PX;WIDTH:950PX; HEIGHT:50PX;POSITION:ABSOLUTE">
<hr>
<center><a href="mailto:trufin_alex@yahoo.com" class="linknormal">
&COPY tralsb software 2004</a></center>
<DIV>
</body>
</html>

//singinp2.php


<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?php
$USER = $_POST['user'];
PRINT "bINE AI VENIT $USER";
?>
</body>
</html>


//subdomenii.php

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Listare subdomenii</title>
<LINK REL=StyleSheet HREF="dtpt.css" TITLE="dtptstyle" TYPE="text/css">
</head>
<body>
<h1>Subdomenii</h1>

<?php
INCLUDE("conn_dtpt.php");
INCLUDE("meniu.php");

if(isset($_GET['id_domeniu'])){

$id_domeniu = $_GET['id_domeniu'];

$sqlSD = "select * from subdomeniu, domeniu WHERE subdomeniu.id_domeniu = ".$id_domeniu." and domeniu.id_domeniu = ".$id_domeniu;
$resursa = mysql_query($sqlSD);

if(isset($_GET['id_domeniu']) && ($sqlSD == 0)){
 print 'Nu exista nici un subdomeniu in aceast domeniu';
}
else
{
print "<table >";
print"<tr>
<td>iddomeniu</td>
<td>numedomeniu</td>
<td>iddomeniu</td>
<td>idsubdomeniu</td>
<td>numesubdomeniu</td>
</tr>";

while($row = mysql_fetch_array($resursa))
{
 print "<tr>
 <td>".$row['id_domeniu']."</td>
 <td>".$row['nume_domeniu']."</td>
    <td>".$row['id_domeniu']."</td>
    <td>".$row['id_subdomeniu']."</td>
    <td>".$row['nume_subdomeniu']."</td>
 <tr>";
}

print "</table>";
}
}

if(!isset($_GET['id_domeniu'])){
$sqlSD = "select * from subdomeniu, domeniu WHERE domeniu.id_domeniu = subdomeniu.id_domeniu ORDER BY domeniu.id_domeniu ASC";
$resursa = mysql_query($sqlSD);

print "<table >";
print"<tr>
<td>iddomeniu</td>
<td>numedomeniu</td>
<td>iddomeniu</td>
<td>idsubdomeniu</td>
<td>numesubdomeniu</td>
</tr>";

while($row = mysql_fetch_array($resursa))
{
 print "<tr>
 <td>".$row['id_domeniu']."</td>
 <td>".$row['nume_domeniu']."</td>
    <td>".$row['id_domeniu']."</td>
    <td>".$row['id_subdomeniu']."</td>
    <td>".$row['nume_subdomeniu']."</td>
 <tr>";
}

print "</table>";

} 
?>

</body>
</html>
//time.php
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?php

$today = getdate();
$month = $today['month'];
$mday = $today['mday'];
$year = $today['year'];
echo "$month $mday, $year";
print "<br>";
print "Pagina asta merge bine!";
?>


</body>
</html>


Comentarii

Postări populare de pe acest blog

program principal cpp

#include "clasa.h" #include <stdio.h> #include <conio.h> #include <stdlib.h> #include <string.h> #define DELAY 9000000 void delay() { for(long i=0;i<DELAY;i++); } //constructor cu initializare de la tastatura BigInt::BigInt() {char x; signed char t[400]; int i; printf("\nNumarul cu semn "); do s=getche(); while((s!='+')&&(s!='-')); n=0; do {x=getche(); t[n]=x-'0'; n++; } while((x>='0')&&(x<='9')); n--; for(i=0;i<n;i++) nr[i]=t[n-i-1]; } //constructor cu initializare prin parametri BigInt::BigInt(char semn,signed char numar[],int dim) {int i; s=semn; n=dim; for(i=0;i<n;i++) nr[i]=numar[n-i-1]; } //transform un int negativ in pozitiv int BigInt::Pozitiv(int x) {int a,vb; a=0; vb=0; while(vb==0) if((x+a)==0) vb=1; else a=a+1; x=a; return x; } //constructor dintr-un nr int obisnuit BigInt::BigInt(int x) {int i; if(x>=0) s='+'…

NUMERE PRIME ALGORITM C++

// NUMERE PRIME ALGORITM C++//  reediting from scratch //on this page is just the study for a next algoritm for generating the parime nr series like Fibonnaci or ....if possibile

74111121313417374414124343447 if u know the red part you can generate the orange part
1 0 1 111112222 1 1 23

o aplicatie php localitati romania

//APLICATIA SE REFERA LA BAZA DE DATE SIRUTA

//dragtable.js


/* dragtable v1.0 June 26, 2008 Dan Vanderkam, http://danvk.org/dragtable/ http://code.google.com/p/dragtable/ \Bsortabledraggable\B Instructions: - Download this file - Add <script src="dragtable.js"></script> to your HTML. - Add class="draggable" to any table you might like to reorder. - Drag the headers around to reorder them. This is code was based on: - Stuart Langridge's SortTable (kryogenix.org/code/browser/sorttable) - Mike Hall's draggable class (http://www.brainjar.com/dhtml/drag/) - A discussion of permuting table columns on comp.lang.javascript Licensed under the MIT license. */ // Here's the notice from Mike Hall's draggable script: //***************************************************************************** // Do not remove this notice. // // Copyright 2001 by Mike Hall. // See http…