Jump to content

phpnewbie26

Members
  • Posts

    3
  • Joined

  • Last visited

phpnewbie26's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Hi, I am working on a website that users can log into from one page and administrate their users from another. first page is index.php and second is admin.php. on the index page I have a form to login with that calls out to a stand alone .php script called "checklogin.php" here is the code... <?php ob_start(); $host=; // Host name $username=; // Mysql username $password="; // Mysql password $db_name="; // Database name $tbl_name="; // 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 $login and $pass $login=$_POST['login']; $pass=$_POST['pass']; // To protect MySQL injection (more detail about MySQL injection) $login = stripslashes($login); $pass = stripslashes($pass); $login = mysql_real_escape_string($login); $pass = mysql_real_escape_string($pass); $sql="SELECT * FROM Registration WHERE login='$login' and pass='$pass'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $login and $pass, table row must be 1 row if($count==1){ session_register("login"); session_register("pass"); header("location:Admin.php"); } else { echo "<script language='javascript'> alert('Sorry, but you must login to view the members area!') </script> <script> window.location='index.php' </script>"; } ob_end_flush(); ?> my admin page has this script on it as a redirect... <?php session_start(); if(!session_is_registered(login)){ header("admin.php"); } ?> my question is...how can I echo out user specific data with this code onto the admin page in a div? since the code is living outside the admin page, I cant figure out how to do it...any help, thanks!
  2. The script gets to the //Check Query part and fails. It echos out the "lid query" and doesn't put anything into the database. I tried to just remove that portion, but it still wouldn't input any data into my table. I am very new at PHP and am basically getting code off the internet and throwing it into some pages and seeing if it works. This is a very simple script, I just dont see why it isn't working?
  3. Hi, I am having an Issue inputting data into my database with this code. I tested the connection, which works fine, but when I try to submit the form I get the "die("lid query: " . mysql_error());". Any Ideas? <!doctype html> <html> <head> <meta charset="utf-8"> <title>Untitled Document</title> </head> <body> <form action="thispage.php" method="POST"> <input type="text" name="name" placeholder="Check-in Name"> <input type="submit" value='submit'></form> <?php if (isset($_POST['submit'])) { $name = $_POST['name']; $host ="localhost"; $username = "username"; $password = "password"; $dbname = "database"; $con = mysql_connect($host, $username, $password, $dbname); //Check Connection if (!$con) { die("Could not connect: " . mysql_error()); } //Select your database mysql_select_db("database",$con); //Check to make sure the database is there if (!$mysql_select_db) { die ('Can't use the db : ' . mysql_error()); } //Run query $insert = mysql_query("insert into Users(name) values ('$name')"); } //Check Query if (!$insert) { die("lid query: " . mysql_error()); } echo "Data inserted"; mysql_close($con); ?> </body> </html>
×
×
  • Create New...