inserting values in a database using php and html

[wenggarcia]

please help me..

kindly see if what's wrong with my code below.. im trying to insert values in a table on my database but the query returned as failed.
[php]
html code -my input page

<form action="addcustomers.php" method="$_POST">
Customer ID: <input type="text" name="CustID"><br>
Name: <input type="text" name="Name"><br>
Address: <input type="text" name="Address"><br>
Credit Limit:<input type="text" name="CreditLimit"><br>
<input type="submit" value="ADD">

php code-to process my html code
<?php

$id = $_POST['CustID'];
$name=$_POST['Name'];
$address=$_POST['Address'];
$creditlimit=$_POST['CreditLimit'];
$con=mysql_connect('localhost','root','my_password ');
$db=mysql_select_db('hsrc',$con);
$query_string="INSERT INTO customer VALUES ($id,'$name','$address',$creditlimit)";
echo $query_string;
$query=mysql_query($query_string);
if($query)
{
echo"customers record successfully added";
}else
{
echo"adding of customers record failed";
}
?>
php code -use to display added values in the table

$con = mysql_connect('localhost','root','my_password');
$db = mysql_select_db('hsrc',$con);
$str = "SELECT * FROM customer";
$query = mysql_query($str);
echo("<table border=1>");
echo("<tr><td>Customer ID</td><td>Name</td><td>Address</td><td>CreditLimit</td></tr>");
while($val=mysql_fetch_array($query))
{
echo "<tr><td>" . $val['CustID'] . "</td><td>" . $val['Name'] . "</td><td>" . $val['Address']."</td><td>" . $val['CreditLimit'] . "</td><td>" . $val['DepotID'] . "</td></tr>";

}
echo "<table>";
?>.[/php]

[r035198x]

please help me..

kindly see if what's wrong with my code below.. im trying to insert values in a table on my database but the query returned as failed.

html code -my input page

<form action="addcustomers.php" method="$_POST">

Customer ID: <input type="text" name="CustID"><br>
Name: <input type="text" name="Name"><br>
Address: <input type="text" name="Address"><br>
Credit Limit:<input type="text" name="CreditLimit"><br>

<input type="submit" value="ADD">

php code-to process my html code

<?php

$id = $_POST['CustID'];
$name=$_POST['Name'];
$address=$_POST['Address'];
$creditlimit=$_POST['CreditLimit'];

$con=mysql_connect('localhost','root','my_password ');
$db=mysql_select_db('hsrc',$con);
$query_string="INSERT INTO customer VALUES ($id,'$name','$address',$creditlimit)";
echo $query_string;
$query=mysql_query($query_string);

if($query)
{
echo"customers record successfully added";


}else
{
echo"adding of customers record failed";
}

?>
php code -use to display added values in the table

$con = mysql_connect('localhost','root','my_password');
$db = mysql_select_db('hsrc',$con);
$str = "SELECT * FROM customer";
$query = mysql_query($str);

echo("<table border=1>");
echo("<tr><td>Customer ID</td><td>Name</td><td>Address</td><td>CreditLimit</td></tr>");


while($val=mysql_fetch_array($query))
{
echo "<tr><td>" . $val['CustID'] . "</td><td>" . $val['Name'] . "</td><td>" . $val['Address']."</td><td>" . $val['CreditLimit'] . "</td><td>" . $val['DepotID'] . "</td></tr>";

}

echo "<table>";


?>

Moved to PHP forum.
Please make use of the code tags when posting code and make sure you are posting in the correct forum.

[savanm]

Insert into html table
<?php
$sql = "select * from login";
$ress = mysql_query($sql);
//$res = mysql_fetch_assoc($ress);
echo ("<table name='data' height='21' width='24' cellpadding='3' cellspacing='3' align='center' bordercolor='black' border='1' bgcolor='#45509C'>");
echo "<tr>";
echo"<td>Checkbox</td>";
echo "<td>UserName:</td>";
echo "<td>Password</td>";
echo "</tr>";
while($row = mysql_fetch_array($ress)){
echo "<tr>";
echo "<td><input type='checkbox' name='chkbox' align='center'/></td>";
echo ("<td >$row[user]</td>");
echo ("<td >$row[password]</td>");
echo "</tr>";
}
echo "</table>";
?> Insert into databse
For example the button is like this
-----------------------------------------------
<td><input type="submit" name="btnIns" value="Insert"></td>
For example the textbox is like this is like this
-----------------------------------------------
<input type="password" name="userpass" align="center" maxlength="14" size="12"></td>
<input type="text" name="usertxt" align="center" maxlength="14" size="12"></td>
if(isset($_POST["btnIns"])
{
$usertxt = $_POST["$usertxt"];
$userpass = $_POST["$userpass"];
$sql="insert into tablenamae values('$usertxt','$userpass');
mysql_query($sql);
}
savanm: enclose your code within php or code tags!! - moderator

[ronverdonk]

Extract the exact error message from mysql, then you'll know what the problem is. Just change the insert command into

$query=mysql_query($query_string) 
  or die("INSERT error: ".mysql_error());

Ronald :cool: