about using Mysql User and Pass to login to page

**lmf** · Jul 25th, 2005, 07:29 PM

sup? all i just find a code to edit table in mysql but i don't know how to set it have to login every i go to login page if anyone can help me out that will great

birthdays_login.php

PHP Code:


<html><head><title>Birthdays Login</title>

<style type="text/css">

form{ font-family: Arial ,sans-serif;font-style : normal ;font-size : 9pt; font-weight :normal}

</style>

</head>

<body>

<div align="center">

<table width="350" cellpadding="10" cellspacing="0" border="2">

<tr align="center" valign="top">

<td align="left" colspan="1" rowspan="1"  bgcolor="#64B1FF">

<form method="POST" action="birthdays_dbase_interface.php">

<?

print "Enter Username: <input type=text name=username size=20><br>\n";

print "Enter Password:  <input type=password name=password size=20><br>\n";

print "<br>\n";

print "<input type=submit value=Submit><input type=reset>\n";

?>

</form>

</td></tr></table>

</div>

</body>

</html>

birthdays_change_form.php

PHP Code:


<html><head><title></title></head>

<body>

<?

$id=$_POST['id'];

$db="mydatabase";

$link = mysql_connect(localhost,$_POST['username'],$_POST['pass']);

//$link = mysql_connect("localhost");

if (! $link)

die("Couldn't connect to MySQL");



mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());



$query=" SELECT * FROM birthdays WHERE id='$id'";

$result=mysql_query($query);

$num=mysql_num_rows($result);



$i=0;

while ($i < $num) {

$name=mysql_result($result,$i,"name");

$birthday=mysql_result($result,$i,"birthday");

?>

<table width="300" cellpadding="10" cellspacing="0" border="2">

<tr align="center" valign="top">

<td align="center" colspan="1" rowspan="1" bgcolor="#64b1ff">

<h3>Edit and Submit</h3>

<form action="birthdays_change_record.php" method="post">

<input type="hidden" name="username" value="<?php print $_POST['username']?>">

<input type="hidden" name="pass" value="<?php print $_POST['pass']?>">

<input type="hidden" name="ud_id" value="<? echo "$id" ?>">

Name:    <input type="text" name="ud_name" value="<? print "$name"?>"><br>

Birthday:    <input type="text" name="ud_birthday" value="<? echo "$birthday"?>"><br>

<input type="Submit" value="Update">

</form>

</td></tr></table>



<?

++$i;

}

?>

</body>

</html>

birthdays_change_record.php

PHP Code:


<html><head><title></title></head>

<body>

<?

$user=$_POST['username'];

$password=$_POST['password'];

$ud_id=$_POST['ud_id'];

$ud_name=$_POST['ud_name'];

$ud_birthday=$_POST['ud_birthday'];



$db="mydatabase";

$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);

//$link = mysql_connect("localhost");

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

mysql_query(" UPDATE birthdays  SET name='$ud_name' ,birthday='$ud_birthday' WHERE id='$ud_id'");

echo "Record Updated";

mysql_close($link);

?>

<form method="POST" action="birthdays_update_form.php">

<input type="hidden" name="username" value="<?php print $_POST['username']?>">

<input type="hidden" name="pass" value="<?php print $_POST['password']?>">

<input type="submit" value="Change Another">

</form><br>



<form method="POST" action="birthdays_dbase_interface.php">

<input type="hidden" name="username" value="<?php print $_POST['username']?>">

<input type="hidden" name="pass" value="<?php print $_POST['password']?>">

<input type="submit" value="Dbase Interface">

</form>



</body>

</html>

**lmf** · Jul 25th, 2005, 07:32 PM

birthdays_create_database.php

PHP Code:


<html><head><title>Birthdays Create Database</title></head>

<body>

<?

$link = mysql_connect("localhost", "root", "testsql");

if (! $link)

die("Couldn't connect to MySQL");

//create database

mysql_create_db("mydatabase")or die("Create Error: ".mysql_error());

mysql_close($link);

?> 

</body>

</html>

birthdays_create_table.php

PHP Code:


<html><head><title>Birthdays Create Table</title></head>

<body>

<?

$db="mydatabase";

$link = mysql_connect("localhost", "root", "testsql");

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Select DB Error: ".mysql_error());

//create table

mysql_query("CREATE TABLE birthdays( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), birthday VARCHAR(7))")or die("Create table Error: ".mysql_error());

mysql_close($link);



?>

</body>

</html>

birthdays_dbase_interface.php

PHP Code:


<html><head><title></title></head>

<body>

<table width="300" cellpadding="10" cellspacing="0" border="2">

<tr align="center" valign="top">

<td align="left" colspan="1" rowspan="1" bgcolor="64b1ff">

<h3>Birthdays Interface</h3>

<form method="POST" action="birthdays_insert_form.php">

<input type="hidden" name="username" value="<? print $_POST['username']?>">

<input type="hidden" name="password" value="<? print $_POST['password']?>">

<input type="submit" value="Insert Record">

</form><br>

<form method="POST" action="birthdays_display_records.php">

<input type="hidden" name="username" value="<? print $_POST['username']?>">

<input type="hidden" name="password" value="<? print $_POST['password']?>">

<input type="submit" value="Display Records">

</form><br>

<form method="POST" action="birthdays_update_form.php">

<input type="hidden" name="username" value="<? print $_POST['username']?>">

<input type="hidden" name="password" value="<? print $_POST['password']?>">

<input type="submit" value="Update Records">

</form><br>

<form method="POST" action="birthdays_delete_form.php">

<input type="hidden" name="username" value="<? print $_POST['username']?>">

<input type="hidden" name="password" value="<? print $_POST['password']?>">

<input type="submit" value="Delete Record">

</form><br>

</td></tr></table>

</body>

</html>

birthdays_delete_form.php

PHP Code:


<html><head><title>Birthdays Delete Form</title></head>

<body>

<?

$db="mydatabase";

//$link = mysql_connect("localhost");

$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

$result = mysql_query( "SELECT * FROM birthdays" )

or die("SELECT Error: ".mysql_error());

$num_rows = mysql_num_rows($result);

print "There are $num_rows records.<P>";

print "<table width=200 border=1>\n";

while ($get_info = mysql_fetch_row($result)){ 

print "<tr>\n";

foreach ($get_info as $field) 

print "\t<td><font face=arial size=1/>$field</font></td>\n";

print "</tr>\n";

}

print "</table>\n";

mysql_close($link);

?>

<br>

<form method="POST" action="birthdays_delete_record.php">

<pre>

Enter Line Number to Delete: <input type="text" name="id" size="5">

<input type="submit" value="Submit"><input type="reset">

</pre>

</form>

</body>

</html>

**lmf** · Jul 25th, 2005, 07:35 PM

birthdays_delete_record.php

PHP Code:


<html><head><title>Birthdays Delete Record</title></head>

<body>

<?

$user=$_POST['username'];

$password=$_POST['password'];

$id=$_POST['id'];

$db="mydatabase";

//$link = mysql_connect("localhost");

$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

mysql_query("DELETE FROM  birthdays where id=$id")or die("Delete Error: ".mysql_error());

mysql_close($link);

print "Record Removed.\n";

?>

<br><br>

<form method="POST" action="birthdays_delete_form.php">

<input type="hidden" name="username" value="<?php print $_POST['username']?>">

<input type="hidden" name="pass" value="<?php print $_POST['password']?>">

<input type="submit" value="Delete Another">

</form><br>

<form method="POST" action="birthdays_dbase_interface.php">

<input type="hidden" name="username" value="<?php print $_POST['username']?>">

<input type="hidden" name="pass" value="<?php print $_POST['password']?>">

<input type="submit" value="DBase Interface">

</form>

</body>

</html>

birthdays_display_records.php

PHP Code:


<html>

<head><title>(Title Here)</title></head>

<body>

<?php

$db="mydatabase";

//$link = mysql_connect("localhost");

$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

$result = mysql_query( "SELECT * FROM birthdays" )

or die("SELECT Error: ".mysql_error());

$num_rows = mysql_num_rows($result);

print "There are $num_rows records.<P>";

print "<table width=200 border=1>\n";

while ($get_info = mysql_fetch_row($result)){ 

print "<tr>\n";

foreach ($get_info as $field) 

print "\t<td><font face=arial size=1/>$field</font></td>\n";

print "</tr>\n";

}

print "</table>\n";

mysql_close($link);

?>

</body>

</html>

birthdays_insert_form.php

PHP Code:


<html><head><title>Birthdays Insert Form</title></head>

<body>

<table width="300" cellpadding="5" cellspacing="0" border="2">

<tr align="center" valign="top">

<td align="left" colspan="1" rowspan="1" bgcolor="64b1ff">

<h3>Insert Record</h3>

<form method="POST" action="birthdays_insert_record.php">

<!--The hidden fields are provided to maintain state.  

They are used to pass the username and password from script to script.-->

<!--

<input type="hidden" name="username" value="<? print $_POST['username'] ?>">

<input type="hidden" name="password" value="<? print $_POST['password'] ?>">

//-->

<?

print "Enter name: <input type=text name=name size=20><br>\n";

print "Enter Birthday: <input type=text name=birthday size=10><br>\n";

print "<br>\n";

print "<input type=submit value=Submit><input type=reset>\n";

?>

</form>

</td></tr></table>

</body>

</html>

birthdays_insert_record.php

PHP Code:


<html><head><title>Birthdays Insert Record</title></head>

<body>

<?

$name=$_POST['name'];

$birthday=$_POST['birthday'];

$db="mydatabase";

//$link = mysql_connect("localhost");

$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link) or die("Select Error: ".mysql_error());

$result=mysql_query("INSERT INTO birthdays (name, birthday) VALUES ('$name','$birthday')")or die("Insert Error: ".mysql_error());

mysql_close($link);

print "Record added\n";

?>

<form method="POST" action="birthdays_insert_form.php">

<input type="submit" value="Insert Another Record">

</form>

</body>

</html>

birthdays_update_form.php

PHP Code:


<html><head><title>Birthdays Update Form</title></head>

<body>

<?

$db="mydatabase";

//$link = mysql_connect("localhost");

$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);

if (! $link)

die("Couldn't connect to MySQL");

mysql_select_db($db , $link)

or die("Couldn't open $db: ".mysql_error());

$result = mysql_query( "SELECT * FROM birthdays" )

or die("SELECT Error: ".mysql_error());

$num_rows = mysql_num_rows($result);

print "There are $num_rows records.<P>";

print "<table width=200 border=1>\n";

while ($get_info = mysql_fetch_row($result)){ 

print "<tr>\n";

foreach ($get_info as $field) 

print "\t<td><font face=arial size=1/>$field</font></td>\n";

print "</tr>\n";

}

print "</table>\n";

mysql_close($link);

?>

<br>

<form method="POST" action="birthdays_change_form.php">

<pre>

Enter Line Number to Edit: <input type="text" name="id" size="5">

<input type="submit" value="Submit"><input type="reset">

</pre>

</form>

</body>

</html>

tHANKX you for the help

h

**lmf** · Jul 25th, 2005, 07:36 PM

here is the zip file i downloaded from the net
h

Thread: about using Mysql User and Pass to login to page

Thread Tools

Display

about using Mysql User and Pass to login to page

Re: about using Mysql User and Pass to login to page

Re: about using Mysql User and Pass to login to page

Re: about using Mysql User and Pass to login to page

Posting Permissions