it seems that i finish a kind of code but is not working, is not introducing the data in the fields, i don't understand why ???
here is the code :
Code: Select all
<?php
$hostname = "localhost";
$db_user = "root";
$db_password = "";
$database = "eurolevel";
$db_table = "apartamente";
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);
?>
<?php
if (isset($_REQUEST['Submit'])) {
$sql = "INSERT INTO $db_table(tip, nr_camere, zona) values ('".mysql_real_escape_string(stripslashes($_REQUEST['tip']))."','".mysql_real_escape_string(stripslashes($_REQUEST['nr_camere']))."', '".mysql_real_escape_string(stripslashez($_REQUEST['zona']))."')";
if($result = mysql_query($sql ,$db)) {
echo '<h1>Thank you</h1>Your information has been entered into our database<br><br><img src="http://www.webune.com/images/headers/default_logo.jpg"';
} else {
echo "ERROR: ".mysql_error();
}
} else {
?>
<title>Adaugare Apartament</title>
<link rel="stylesheet" type="text/css" href="view.css" media="all">
<script type="text/javascript" src="view.js"></script>
</head>
<body id="main_body" >
<img id="top" src="top.png" alt="">
<div id="form_container">
<h1><a>Adaugare Apartament</a></h1>
<form id="form_71925" class="appnitro" method="post" action="">
<div class="form_description">
<h2>Adaugare Apartament</h2>
<p>Completati Toate Campurile!!!</p>
</div>
<ul >
<li id="li_1" >
<label class="description" for="tip">Tip </label>
<div>
<input id="Tip" name="Tip" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_2" >
<label class="description" for="nrcamere">Nr. Camere </label>
<div>
<input id="nrcamere" name="nrcamere" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_3" >
<label class="description" for="zona">Zona </label>
<div>
<input id="zona" name="zona" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_4" >
<label class="description" for="adresa">Adresa </label>
<div>
<input id="adresa" name="adresa" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_5" >
<label class="description" for="confort">Confort </label>
<div>
<input id="confort" name="confort" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_6" >
<label class="description" for="etaj">Etaj </label>
<div>
<input id="etaj" name="etaj" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_7" >
<label class="description" for="suprafatatotala">Suprafata Totala </label>
<div>
<input id="suprafatatotala" name="suprafatatotala" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_8" >
<label class="description" for="suprafatautila">Suprafata Utila </label>
<div>
<input id="suprafatautila" name="suprafatautila" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_9" >
<label class="description" for="anconstructie">An Constructie </label>
<div>
<input id="anconstructie" name="anconstructie" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_10" >
<label class="description" for="vedere">Vedere </label>
<div>
<input id="vedere" name="vedere" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_12" >
<label class="description" for="orientare">Orientare </label>
<div>
<input id="orientare" name="orientare" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_13" >
<label class="description" for="nrgrsanitare">Nr Grupuri Sanitare </label>
<div>
<input id="nrgrsanitare" name="nrgrsanitare" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_14" >
<label class="description" for="nrbalcoane">Nr Balcoane </label>
<div>
<input id="nrbalcoane" name="nrbalcoane" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_15" >
<label class="description" for="bulina">Legea 112/Bulina </label>
<div>
<input id="bulina" name="bulina" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_16" >
<label class="description" for="cadastruintabulare">Cadastru/ Intabulare </label>
<div>
<input id="cadastruintabulare" name="cadastruintabulare" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li> <li id="li_17" >
<label class="description" for="descriere">Descriere </label>
<div>
<textarea id="descriere" name="descriere" class="element textarea medium"></textarea>
</div>
</li> <li id="li_18" >
<label class="description" for="pret">Pret </label>
<div>
<input id="pret" name="pret" class="element text medium" type="text" maxlength="255" value=""/>
</div>
</li>
<li class="buttons">
<input type="hidden" name="anunt" value="71925" />
<input id="saveForm" class="button_text" type="submit" name="submit" value="Adauga" action="bazadate.php" />
</li>
</ul>
</form>
<div id="footer">
</div>
</div>
<img id="bottom" src="bottom.png" alt="">
</body>
<?php
}
?>
</body>
</html>
and i have this code to, but like the other, it;s not working nothing in the database :
Code: Select all
<?
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="eurolevel"; // Database name
$tbl_name="apartamente"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Get values from form
$tip=$_POST['tip'];
$nrcamere=$_POST['nrcamere'];
$zona=$_POST['zona'];
$adresa=$_POST['adresa'];
$confort=$_POST['confort'];
$etaj=$_POST['etaj'];
$stot=$_POST['suprafatatotala'];
$sutila=$_POST['suprafatautila'];
$anconstr=$_POST['anconstructie'];
$vedere=$_POST['vedere'];
$orienteare=$_POST['orientare'];
$nrgrsan=$_POST['nrgrsanitare'];
$nrbalcoane=$_POST['nrbalcoane'];
$bulina=$_POST['bulina'];
$cadint=$_POST['cadastruintabulare'];
$descriere=$_POST['descriere'];
$pret=$_POST['pret'];
// Insert data into mysql
$sql="INSERT INTO $tbl_name(tip, nr_camere, zona, adresa, confort, etaj, suprtotala, suprutila, an_constructie, vedere, orientare, nr_gr_sanitare, nr_balcoane, bulina, cadastru_intabulare, descriere, pret)VALUES('$tip', '$nrcamere', '$zona','$adresa','$confort','$etaj','$stot','$sutila','$anconstr','$vedere','$orienteare','$nrgrsan','$nrbalcoane','$bulina','$cadint','$descriere','$pret')";
$result=mysql_query($sql);
// if successfully insert data into database, displays message "Successful".
if($result){
echo "Anuntul a fost adaugat cu succes";
echo "<BR>";
echo "<a href='form.html'>Innapoi la adaugare anunt</a>";
}
else {
echo "Eroare!!! Daca intampinati acest mesaj - sunati administratorul site-ului";
}
// close connection
mysql_close();
?>