php - Why isn't my insert data code working? -
i trying insert data database mysql phpadmin.
my webhost 000webhost.
my connection mysql database code:
<?php $mysql_host = "mysql2.000webhost.com"; $mysql_database = "*********"; $mysql_user = "********"; $mysql_password = "**********"; $dbcon = mysql_connect($mysql_host,$mysql_user,$mysql_password,$mysql_database); if (!$dbcon) { die('error connecting database'); } echo ('you have connected successfully'); ?> my insert data code:
<?php if (isset($_post['submitted'])) { include('connect_mysql.php'); $fname = $_post['fname']; $lname = $_post['lname']; $sqlinsert = "insert people (firstname, lastname) values ('$fname', '$lname')"; if (!mysql_query($dbcon, $sqlinsert)) { die('error inserting new record'); } // end of nested if statement $newrecord = "1 record added database"; } ?> <html> <head> <title>insert data db</title> </head> <body> <h1>insert data db</h1> <form method="post" action="insert-data.php"> <input type="hidden" name="submitted" value="true" /> <fieldset> <legend>new people</legend> <label>first name: <input type="text" name="fname" /></label> <label>last name: <input type="text" name="lname" /></label> </fieldset> <br /> <input type="submit" value="add new person" /> </form> <?php echo $newrecord ?> </body> </html> instead of letting me put database brings me page http://error404.000webhost.com/?
try change
<label>first name: <input type="text name="fname" /></label> <label>last name: <input type="text name="lname" /></label> to
<label>first name: <input type="text" name="fname" /></label> <label>last name: <input type="text" name="lname" /></label> and insert query , connection to
$dbcon = mysql_connect($mysql_host,$mysql_user,$mysql_password,$mysql_database); $sqlinsert = "insert people (firstname, lastname) values ('$fname', '$lname')";
Comments
Post a Comment