Databases
StackOverflow2013
Postsdbo
POCan't insert data from registration page (php) to mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan't insert data from registration page (php) to mysql
    primarykey
    data
    text
    <p>Having trouble inserting data from .php file to mysql. Don't know what the problem is. I have two main .php files. The first is the homepage:</p> <pre><code> &lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" id="jmtoday" class=" no_js"&gt; &lt;html&gt; &lt;head&gt; &lt;link href='icon.jpg' rel='icon' type='image/jpg'/&gt; &lt;meta http-equiv="Content-type" content="text/html; charset=utf-8" /&gt; &lt;meta http-equiv="Content-language" content="en" /&gt; &lt;LINK REL=StyleSheet HREF="Mainstyles.css" TYPE="text/css"&gt;&lt;/link&gt; &lt;Title&gt;Welcome to JM Today&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;div class="container"&gt; &lt;div class="header"&gt;&lt;a class="logo" HREF="Homepage.html"&gt;&lt;img src="Logo.png" alt="[JM Today]" &gt;&lt;/a&gt;&lt;/div&gt; &lt;div class="navbar"&gt; &lt;ul class="navbar"&gt;&lt;li class="navbar"&gt;&lt;a class="navbar" HREF="Homepage.html"&gt;Homepage&lt;/a&gt; &lt;/li&gt; &lt;li class="navbar"&gt;&lt;a class="navbar" HREF="Classes.html"&gt;Classes&lt;/a&gt;&lt;/li&gt; &lt;li class="navbar"&gt;&lt;a class="navbar" HREF="Calendar.html"&gt;Calendar&lt;/a&gt;&lt;/li&gt; &lt;li class="navbar"&gt;&lt;a href="Tutoring.html" class="navbar"&gt;Tutoring&lt;/a&gt;&lt;/li&gt; &lt;li class="navbar"&gt;&lt;a href="News.html" class="navbar" &gt;News&lt;/a&gt;&lt;/li&gt; &lt;li class="navbar"&gt;&lt;a href="Aboutus.html" class="navbar"&gt;About Us&lt;/a&gt;&lt;/li&gt;&lt;/div&gt; &lt;div class="left"&gt;&lt;/div&gt; &lt;div class="content"&gt;&lt;h2 class="homepage"&gt;For Students. By Students.&lt;/h2&gt;&lt;p&gt;Welcome to JM Today, where you could find anything about your school, your classmates, and everything else. Online.&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;/p&gt;&lt;/div&gt; &lt;div class="signup"&gt;&lt;h2 class="homepage"&gt;Sign Up Now&lt;/h2&gt;&lt;h3 class="homepage"&gt;It's free, as you expected.&lt;/h3&gt; &lt;form name="registration_form" method="post" action="register.php" onsubmit="return Validate();"&gt;&lt;input type=hidden name=todo value=post&gt; &lt;table&gt; &lt;tr&gt;&lt;td class="label"&gt;First Name:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="fname"&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td class="label"&gt;Last Name:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="lname"&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td class="label"&gt;E-Mail Address:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="email"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt;&lt;td class="label"&gt;Username:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="username"&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td class="label"&gt;Password:&lt;/td&gt;&lt;td&gt;&lt;input type="password" name="password"&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td class="label"&gt;Password Confirmation:&lt;/td&gt;&lt;td&gt;&lt;input type="password" name="password_confirmation"&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td class="label"&gt;&lt;input type="submit" value="Register"&gt;&lt;/td&gt;&lt;/tr&gt; &lt;/form&gt; &lt;/table&gt; &lt;script language = "Javascript"&gt; function Validate() { if (document.registration_form.fname.value == '') { alert('Please fill in your first name!'); return false; } if (document.registration_form.lname.value == '') { alert('Please fill in your last name!'); return false; } if (document.registration_form.email.value == '') { alert('Please fill in your email address!'); return false; } if (document.registration_form.username.value == '') { alert('Please fill in your desired username!'); return false; } if (document.registration_form.password.value == '') { alert('Please fill in your desired password!'); return false; } if (document.registration_form.password_confirmation.value == '') { alert('Please fill in your password again for confirmation!'); return false; } if (document.registration_form.password.value != document.registration_form.password_confirmation.value) { alert("The two passwords are not identical! "+ "Please enter the same password again for confirmation"); return false; } return true; } &lt;/script&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="footer"&gt;&lt;p class="copyright"&gt;JMToday &amp;copy; 2010&lt;/p&gt;&lt;p class="right"&gt;A Samir Ghobril Production&lt;/p&gt;&lt;/div&gt; &lt;/body&gt; </code></pre> <p>And the second is register.php</p> <pre><code> !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" id="jmtoday" class=" no_js"&gt; &lt;html&gt; &lt;head&gt; &lt;link href='icon.jpg' rel='icon' type='image/jpg'/&gt; &lt;meta http-equiv="Content-type" content="text/html; charset=utf-8" /&gt; &lt;meta http-equiv="Content-language" content="en" /&gt; &lt;LINK REL=StyleSheet HREF="Mainstyles.css" TYPE="text/css"&gt;&lt;/link&gt; &lt;Title&gt;Sign up to JM Today&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;?php $dbservertype='mysql'; $servername='localhost'; $dbusername='root'; $dbpassword='****'; $dbname='jmtdy'; connecttodb($servername,$dbname,$dbusername,$dbpassword); function connecttodb($servername,$dbname,$dbuser,$dbpassword) { global $link; $link=mysql_connect ("$servername","$dbuser","$dbpassword"); if(!$link){die("Could not connect to MySQL");} mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error()); } ?&gt; &lt;?php $username=$_POST['username']; $password=$_POST['password']; $password2=$_POST['password_confirmation']; $todo=$_POST['todo']; $email=$_POST['email']; $fname=$_POST['fname']; $lname=$_POST['lname']; if(isset($todo) and $todo=="post"){ $status = "OK"; $msg=""; if(!isset($username) OR strlen($userid) &lt;3){ $msg=$msg."Username should be equal to or more than 3 characters long&lt;BR/&gt;"; $status= "NOTOK";} if(mysql_num_rows(mysql_query("SELECT username FROM users WHERE username = '$username'"))){ $msg=$msg."Username already exists. Please try another one&lt;BR/&gt;"; $status= "NOTOK";} if ( strlen($password) &lt; 3 ){ $msg=$msg."Password must be more than 3 charactors long&lt;BR/&gt;"; $status= "NOTOK";} if ( $password &lt;&gt; $password2 ){ $msg=$msg."Passwords are not identical.&lt;BR/&gt;"; $status= "NOTOK";} if($status&lt;&gt;"OK"){ echo "$msg&lt;br/&gt;&lt;input type='button' value='Retry' onClick='history.go(-1)'&gt;"; }else{ if(mysql_query("insert into users(username,password,email,fname,lname) values('$username','$password','$email','$fname','$lname')")){ echo "Welcome, You have successfully signed up";} else{ echo "Database Problem, please contact Site admin"; } } } ?&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>If you could please help me i would greatly appreciate it. [edit]ok, i fixed up the code and got this error message. Access denied for user 'www-data'@'localhost' (using password: NO). Does this help?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSamir Ghobril
    1. USSamir Ghobril
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan't insert data from registration page (php) to mysql
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POCan't insert data from registration page (php) to mysql
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhat happens? What doesn't work?
      singulars
      1. POCan't insert data from registration page (php) to mysql
      1. USPekka 웃
    2. COYOU DON'T REALLY use **root** as login and don't do any escaping of input, whatsoever, do you?
      singulars
      1. POCan't insert data from registration page (php) to mysql
      1. USLinus Kleen
    3. COdo you get any errors? does anything get printed`? you should write after each mysql_query() or die (mysql_error ()) to make it print any occured mysql errors
      singulars
      1. POCan't insert data from registration page (php) to mysql
      1. USBreezer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload