New Topic/Question
Reply
i have a problem with inserting data into my SQL database, the database is created and its working, the local server is running everything is ok but it still dosent work. Maybe i have the wariables wrong, or i dont know some typing error, but nothing apears.
Here is the code maybe some1 sees what i cant.
Maybe i should name my database and my table diferently ?
<?php
$host="localhost";
$username="root";
$password="***********";
$database="Information";
$table="information";
$nume='$_POST[name]';
$email='$_POST[email]';
$topic='$_POST[topic]';
$descriere='$_POST[message]';
$date=date("Y-m-d");
$canty='$_POST[cant]';
mysql_connect("$host","$username","$password") or die(mysql_error());
echo "connected";
mysql_select_db("$database") or die(mysql_error());
echo "database found";
$mysql="INSERT INTO $table(Nr.Reg,Nume,E-mail,Descriere,Date,Topic,Cantitate) VALUES ('0','$nume','$email','$descriere','$date','$topic','$canty')";
if (!mysql_query($mysql))
die (mysql_error());
echo"Data inserted!";
mysql_close();
?><head>
<link href="Styles/StylesContacte.CSS" rel="stylesheet" type="text/css">
<title>Contacte</title>
<script type="text/javascript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
</script>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<hr />
<style type="text/css">
form {
width:480px;
margin-left:auto;
margin-right:auto;
text-align:center;
}
form ul {
list-style-type:none;
}
form ul li {
margin:5px 5px;
}
form label {
display:block;
border:#ccc;
font-size:16px;
}
form input , select{
font-size:16px;
width:100%;
background-color:#FFFFFF;
}
#message textarea {
border:solid 3px #ccc;
background-color:#FFFFFF;
}
</style>
</head>
<body>
<header>
<div id="banner">
<img src="Pictures/Untitled-3.png" name="BannerPic" width="650" height="163" id="BannerPic">
</div>
</header>
<div id="menu">
<div id="menu_center">
<ul>
<li><a href="Home.html">Home</a></li>
<li><a href="Produse.html">Produse</a></li>
<li><a href="Cumsefabrica.html">Cum se fabrica</a></li>
<li><a href="Mangalita.html">Mangalita</a></li>
<li><a href="Contacte.html">Contacte </a></li>
</ul>
</div>
</div>
<div id="content">
<div id="holder">
<div id="text1">
<textarea name="Description" cols="80" rows="23" readonly class="nosize-text" id="Desc" height="150" resize="none">
</textarea>
</div>
<div id="mail">
<form action="?" method="post">
<ul>
<li>
<label for="name">Numele:</label>
<input type="text" name="name" id="name" />
</li>
<li>
<label for="email">Email:</label>
<input type="text" name="email" id="email" />
</li>
<li>
<label for="cantitate">Cantitate(KG):</label>
<input type="text" name="cant" id="cant" />
</li>
<li>
<label for="topic">Comanda:</label>
<select id="topic" name="topic">
<option value="Ponies">Salam</option>
<option value="Mexicans">Sunca</option>
<option value="Weiner">Carnati</option>
</select>
</li>
<li>
<label for="message">Tell me something</label>
<textarea id="message" name="message" cols="42" rows="7"> </textarea>
</li>
<li>
<input type="submit" value="Trimite">
</li>
</ul>
</form>
</div>
</div>
<footer>
<table border="0" align="center" cellpadding="10" cellspacing="5" id="table1">
<tr>
<td><a href="Home.html">•Home</a></td>
<td><a href="Produse.html"> •Produse</a></td>
<td><a href="Cumsefabrica.html"> •Cum se fabrica</a></td>
<td><a href="Mangalita.html"> •Mangalita</a></td>
<td><a href="Contacte.html"> •Contacte</a></td>
</tr>
</table>
</footer>
</div>
</body>
</html>
MultiQuote
| 