Jay2391 Posted October 13, 2006 Share Posted October 13, 2006 I created thsi code is just to submit info to a database... but it dosen't submit the informationdatabase name natgaltable users<html><head><title>Record</title></head><body><?php $user = "root";$pass = "12345"; $self = $_SERVER['PHP_SELF'];$userid = $_POST['userid'];$name = $_POST['name'];$last = $_POST['last'];$city = $_POST['city'];$state = $_POST['state'];$country = $_POST['coutry'];$email = $_POST['email'];$gender = $_POST['gender'];$nickname = $_POST['nickname'];$age = $_POST['age'];?><form action="<?php echo( $self ); ?>" method="post">Registration Screen <br><br>User ID: <input type="text" name="userid" size="30"><br>First Name: <input type="text" name="name" size="30"><br>Last Name: <input type="text" name="last" size="30"><br>City: <input type="text" name="city" size="30"><br>State: <input type="text" name="state" size="30"><br>Coutry: <input type="text" name="country" size="30"><br>E-mail: <input type="text" name="email" size="30"><br>Gender: <input type="text" name="gender" size="30"><br>Nick Name: <input type="text" name="nickname" size="30"><br>Age: <input type="text" name="age" size="30"><br><br><input type="submit" value="Submit"><br></form><?php if( $self and $userid and $name and $last and $city and $state and $country and $email and $gender and $nickname and $age ){ $conn=mysql_connect ("localhost", $user, $pass) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("natgal"); $sql = "insert into users ( userid, name, last, city, state, country, email, gender, nickname, age) values ( $userid, \"$name\", \"$last\", \"$city\",\"$state\", \"$country\", \"$email\", \"$gender\", \"$nickname\", \"$age\")"; $rs = mysql_query( $sql, $conn ); if( $rs ){ echo( "Record added:$userid $name $last $city $state $country $email $gender $nickname $age" ); } }?></body></html> Link to comment https://forums.phpfreaks.com/topic/23896-submit-info-to-db/ Share on other sites More sharing options...
dymon Posted October 13, 2006 Share Posted October 13, 2006 Hi,I would advice you first to show the error: $rs = mysql_query( $sql, $conn ) or die (mysql_error());This error could say a lot about the problem you have.And try to make the query like this:[code]$sql = "insert into users ( userid, name, last, city, state, country, email, gender, nickname, age) values ( '$userid', '$name', '$last', '$city', '$state', '$country', '$email', '$gender', '$nickname', '$age')";[/code]This should work. Hope it helps. Link to comment https://forums.phpfreaks.com/topic/23896-submit-info-to-db/#findComment-108617 Share on other sites More sharing options...
Jay2391 Posted October 16, 2006 Author Share Posted October 16, 2006 I get no errors and that did ot work ... I did a test and i know I am conecting to the DB ...ay other sugestions Link to comment https://forums.phpfreaks.com/topic/23896-submit-info-to-db/#findComment-109252 Share on other sites More sharing options...
joshi_v Posted October 16, 2006 Share Posted October 16, 2006 HiReplace this in your code <form action="<?php echo( $self ); ?>" method="post">with<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">and try.RegardsJoshi. Link to comment https://forums.phpfreaks.com/topic/23896-submit-info-to-db/#findComment-109414 Share on other sites More sharing options...
Jay2391 Posted October 17, 2006 Author Share Posted October 17, 2006 here is how i fix it ... Capital letters in the select statements<html><head><title>Add Record</title></head><body><?php$user="root";$pass="12345";$self=$_SERVER['PHP_SELF'];$userid=$_POST['userid'];$name=$_POST['name'];$last=$_POST['last'];$city=$_POST['city'];$state=$_POST['state'];$country=$_POST['country'];$email=$_POST['email'];$gender=$_POST['gender'];$nickname=$_POST['nickname'];$age=$_POST['age'];?><form action="<?php echo( $self );?>" method="post">User ID: <input type="text" name="userid" size"30"><br>Name: <input type="text" name="name" size"30"><br>Last: <input type="text" name="last" size"30"><br>City: <input type="text" name="city" size"30"><br>State: <input type="text" name="state" size"30"><br>Country: <input type="text" name="country" size"30"><br>Email: <input type="text" name="email" size"30"><br>Gender: <input type="text" name="gender" size"30"><br>Nickname: <input type="text" name="nickname" size"30"><br>Age: <input type="text" name="age" size"30"><br><input type="submit" value="Submit"><br></form> <?php if($userid and $name and $last and $city and $state and $country and $email and $gender and $nickname and $age){ $dbh=mysql_connect("localhost", $user, $pass) or die ("Err:Conn"); if($dbh){ echo ("Congrats!!!"); $rs=mysql_select_db("natgal", $dbh) or die ("Err:Db"); $sql="INSERT INTO users( userid, name, last, city, state, country, email, gender, nickname, age) VALUES ($userid, \"$name\", \"$last\", \"$city\", \"$state\", \"$country\", \"$email\", \"$gender\", \"$nickname\", \"$age\")"; $rs=mysql_query($sql, $dbh); if($rs){ echo ("Record Added!!!"); } } }?></body></html> Link to comment https://forums.phpfreaks.com/topic/23896-submit-info-to-db/#findComment-110158 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.