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
BPN = 2 POW 74207281 -1

odd impar
even par

!!! any even number is a sum of two even numbers or two odd numbers or two prime numbers
!!! any odd number is a sum of a odd number and a even numbers
!!!  prime numbers can not be a sum of two prime numbers but will be a sum of a prime number and an even number 
!!! any prime numbers will be odd too but not all odd number are primes
!!! all the numbers formed by same digit  1,3,7,9 are not prime numbers except 11


0, 1, 2, 3, 5, 7, 11, 13, 17, 19, 23, 29, 31, 
37, 41, 43, 47, 53, 59, 61, 67, 71, 73, 
79, 83, 89, 97

1 = 1 + 0+ 0              0
2 = 1 + 1+ 0              1
3 = 2 + 1+ 0              1

small numbers 

5 = 3 + 2+ 0              2
7 = 5 + 2 + 0              2
11 = 7 + 3 + 1            4
13 = 11+2 + 0            2
17 = 13 + 3 + 1 4
19 = 17 + 2+ 0 2
23 = 19 + 3 + 1 4
29 = 23 + 5 + …

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…