Jump to content

[SOLVED] PHP won't write into MySQL database


jonathanchacon

Recommended Posts

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?

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?

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.