--- On Thu, 9/10/09, Tommy Pham <tommyhp2@xxxxxxxxx> wrote:
> From: Tommy Pham <tommyhp2@xxxxxxxxx>
> Subject: Re: Hoping for a hand with a login script
> To: php-general@xxxxxxxxxxxxx
> Date: Thursday, September 10, 2009, 4:13 AM
> --- On Thu, 9/10/09, Watson Blair
> <bestudios.wb@xxxxxxxxx>
> wrote:
>
> > From: Watson Blair <bestudios.wb@xxxxxxxxx>
> > Subject: Hoping for a hand with a login script
> > To: php-general@xxxxxxxxxxxxx
> > Date: Thursday, September 10, 2009, 4:06 AM
> > Hey guys,This is a simple issue I'm
> > sure, however I'm having one hell of a
> > time seeing my way clear of it. I appreciate any
> support
> > you guys could
> > throw my way.
> >
> > So I'm trying to set up a small website that includes
> a
> > store (
> > www.rareintaglio.com), i have all of my HTML hammed
> out and
> > now I'm working
> > on creating an admin login for the sites owner to
> input
> > data from a back
> > end. I have it set up so that he goes to
> /adminlogin.php,
> > enters his info
> > and gains access to the back end of the website using
> > Session variables
> > (valid vs. invalid) however i keep getting this reply
> when
> > i try to run the
> > script:
> >
> > Results: SELECT * FROM adminlog WHARE username =
> > 'gourmet28e' AND password =
> > '*******'
> > Query failed: Query was empty
> > here's the /adminlogin script:
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01
> > Transitional//EN">
> > <html>
> > <?php
> >
> > session_start ;
> >
> > ?>
> > <head>
> > <link rel="stylesheet" type="text/css"
> > href="intaglio.css" />
> > <title></title>
> > <meta http-equiv="content-type"
> > content="text/html;charset=UTF-8" />
> > </head>
> > <body><center>
> > <div id="body">
> > <div id="header"></div>
> > <div id="navbody">
> > <div id="nav">
> > <ul>
> > <li><a
> > href="/index.html">Home</a></li>
> > <li><a
> > href="/shop.html">Store</a></li>
> > <li><a
> > href="/about.html">About</a></li>
> > </ul>
> > </div>
> > </div>
> > <div id="cbody">
> >
> > <?php
> >
> > if ($_SESSION['user'] == invalid)
> > {
> > echo 'Invalid Username or Password, please try
> again';
> > }
> > if ($_SESSION['user'] == valid)
> > {
> > header ("Location: http://www.rareintaglio.com/member.php";);
> > }
> > ?>
> > <form method="post"
> action="/session.php">
> > <table border="0">
> > <tr><td>Admin Name:
> </td></tr>
> > <tr><td><input type="text"
> > name="username" size="30" maxlength="20"/>
> > </td></tr>
> > <tr><td>Password:</td></tr>
> > <tr><td><input type="password"
> > name="password" size="30" maxlength="20"/>
> > </td></tr>
> > <tr><td><input type="submit"
> value="Login"
> > /> </td></tr>
> > </table>
> > </div>
> > <div id="footer"><p>All Pages and Images
> > Copyright @ 2009, Devour.tv Ltd.
> > All Rights Reserved</p></div>
> > </body>
> > </html>
> >
> >
> > and /session.php goes a little like:
> > <?php
> > $host="Rareintag.db.4159106.hostedresource.com"; //
> Host
> > name
> > $username="Rareintag"; // Mysql username
> > $password="**********"; // Mysql password
> > $db_name="Rareintag"; // Database name
> > $tbl_name="adminlog"; // 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");
> >
>
> You need to read the manual more carefully.
> http://www.php.net/manual/en/function.mysql-connect.php
>
>
> > // username and password sent from form
> > $username=$_POST['username'];
> > $password=$_POST['password'];
> > $qury = "SELECT * FROM adminlog WHARE username =
> > '$username' AND password =
> > '$password'";
You might want to learn the basics of SQL syntax.
> > echo '<br />';
> > echo "Query: " . $query;
> > echo '<br />';
> > echo "Results: " . $result;
>
> http://www.php.net/manual/en/function.mysql-query.php
>
> > echo $qury;
> > echo '<br />';
> > $result = mysql_query($query) or die('Query failed: '
> .
> > mysql_error());
> >
> > if($result == 0){
> > $_SESSION['user'] = invalid ;
> > header("Location: http://www.rareintaglio.com/adminlogin.php";);
> > }
> > else
> > {
> > $_SESSION['user'] = valid ;
> > header("Location: http://www.rareintaglio.com/members.php";);
> > }
> > ?>
> >
> > However as I mentioned above i keep getting an error,
> > does anyone know where I took a wrong turn?
> > Thanks,
> > Watson
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
