[SOLVED] PHP won't write into MySQL database

[jonathanchacon]

I have this login script that I got online and while the script works and it does access the database, it doesn't actually input the users and their passwords into the database.Here is the php for the login: 

<?php
ob_start();
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
header("location:http://www.yahoo.com");
}

ob_end_flush();
?>

I only use yahoo as a location til I get the direct link to where it will eventually point to. The database does not show anyone who has logged in. It is also supposed to send them to the login_success.php page if they have logged in before. Where is the error in my code?

[btherl]

Change this line:

 

$result=mysql_query($sql);

 

to

 

$result=mysql_query($sql) or die("Error in $sql: " . mysql_error());

[PFMaBiSmAd]

PHP won't write into MySQL database

That's because the code you posted is attempting to match what is in the database to log someone in. It is not attempting to write anything in to a database.

 

The database does not show anyone who has logged in

There is no code in the code you posted to do that.

 

It is also supposed to send them to the login_success.php page if they have logged in before

There's nothing in it testing if they previously did anything.

 

Where is the error in my code?

The code you posted does not contain or do most of what you stated it is supposed to be doing. What is your actual code?

[DJTim666]

Lmfao. This is a login script. Not a register script. Try creating one of those to first create the users you want to login to your site. I'm sure you can find a few free register scripts on google.

[jonathanchacon]

Thanks for the input, i'll look for a register script. I don't deal much with php, I'm just a graphic designer and trying to learn the ropes of web design. I do have html and css down, but just starting to learn the basics of php