Help Needed! Urgently!

staticfire · #1 (**permalink**) 05-09-07, 04:50 PM

oh god!! I have to get this site running very soon and i'm getting nothing but errors with the login.

Somebody please help.

Here are all my files

login.php

HTML Code:

<head>

<style type="text/css">
INPUT, SELECT, TEXTAREA {
background-color: #000000;
color: #CD0000;
font-family: arial, helvetica;
font-size: 12px;
border: double 1px #CD0000;
padding: 2;
}
</style>

</head>

<body>


<!--This file will create the links section to be displayed on the left of each page-->

<!--begin table-->

<table width="170" border="1" bordercolor="#5C5C5C">

<!--create the title area-->

<tr>
<td width="170" height="25" background="http://www.staticfire.co.uk/images/topbar.png">
<center><b>Login</b></center>
</td>
</tr>

</table>

<table width="170" border="1" bordercolor="#5C5C5C" cellpadding="10">

<tr>
<td width="170" bgcolor="#000000">

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

<font color="#707070">
Username: <input type="text" name="loginname" size="19"><br>
Password: <input type="password" name="password" size="19"><br>
</font>

<br>

<input type="Submit" value="Login">
</form>

<a href="link">Register</a><br>
<a href="link">Forgot Password?</a><br>

</td>

</tr>

</table>

</body>

Register.php

PHP Code:


			


<!--background and link settings-->



<body bgcolor="#000000" link="#707070" vlink="#707070" alink="#707070">





<!--open scrollbar-->



<?php

require 'scrollbar.css';

?>





<!--open page header-->



<?php

require 'banner.php';

?>





<table width="817" align="center">



<tr>



<td width="215" background="http://staticfire.co.uk/images/sidebar_back.png" 

align="center" valign="top">



<br>



<?php

require 'login.php';

?>



<br>



<?php

require 'links.php';

?>



<br>



<?php

require 'top5.php';

?>





<br>



<?php

require 'active_list.php';

?>



</td>                





<!--Start main section-->





<td width="602" valign="top">



<!--Welcome note-->



<table width="100%" align="center" border="1" bordercolor="#CD0000" cellpadding="10">

<tr>

<td>



<center>



<html>



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



<table>



<tr> <td> <font color="#707070"> id: </font> </td> <td><input type="text" name="id" maxlength="20"></td> </tr>

<tr> <td> <font color="#707070"> loginname: </font> </td> <td><input type="text" name="loginname" maxlength="20"></td> </tr>

<tr> <td> <font color="#707070"> createdate: </font> </td> <td><input type="text" name="createdate"> </td> </tr>

<tr> <td> <font color="#707070"> password: </font> </td> <td><input type="text" name="password" maxlength="20"> </td> </tr>

<tr> <td> <font color="#707070"> name: </font> </td> <td><input type="text" name="name" maxlength="30"> </td> </tr>

<tr> <td> <font color="#707070"> Age: </font> </td> <td><input type="text" name="age" maxlength="2"> </td> </tr>

<tr> <td> <font color="#707070"> Location: </font> </td> <td><input type="text" name="location" maxlength="30"> </td> </tr>

<tr> <td> <font color="#707070"> Description: </font> </td> <td><textarea cols="40" rows="5" name="description">

Text here

</textarea>

<tr> <td> <font color="#707070"> email: </font> </td> <td><input type="text" name="email"> </td> </tr>

 

<tr> <td></td>



<td> <font color="#707070"><input type="checkbox" name="option1" value="age_check"> 

I am 13+ or have a parents permission. </font></td></tr><br>



<tr> <td></td>



<td> <font color="#707070"><input type="checkbox" name="option1" value="age_check"> 

I agree to the Terms of Service </font></td></tr><br><br>



</td></tr>

</table>



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



</form>



</html>



</center>



</td>

</tr>

</table>







</td>

</tr>



</table>



<?php

require 'footer.php';

?>

Check_login.php

PHP Code:


			
<?php



$username="staticfire";

$password="xxxxxxxx";

$database="staticfire";



mysql_connect('mysql10.streamline.net',$username,$password);

@mysql_select_db($database) or die("Unable to select database");



$loginname = $_POST['loginname'];

$password = $_POST['password'];



$result = MYSQL_QUERY("SELECT * from members WHERE loginname='$loginname'and password='$password'")

or die ("Name and password not found or not matched");



$worked = mysql_fetch_array($result);



$loginname = $worked['loginname'];

$password = $worked['password'];

$email = $worked['email']; 



if($worked)

 







if(isset($_session['loginname'])){ 



echo"Welcome $_session['loginname']";



}else {echo"You are not logged in";



}











?>

database.php

PHP Code:


			
<!--begin the database page-->



<!--create favicon-->



<LINK REL="SHORTCUT ICON" HREF="http://staticfire.co.uk/favicon.ico"> <br><br>





<!--background and link settings-->



<body bgcolor="#000000" link="#707070" vlink="#707070" alink="#707070">





<!--open scrollbar-->



<?php

require 'scrollbar.css';

?>



<?php



$username="staticfire";

$password="xxxxxxx";

$database="staticfire";



mysql_connect('mysql10.streamline.net',$username,$password);

@mysql_select_db($database) or die("Unable to select database");



$query="CREATE TABLE members(



id          INT           NOT NULL   AUTO_INCREMENT,

loginname   VARCHAR(20)   NOT NULL,

createdate  DATE          NOT NULL,

password    CHAR(255)     NOT NULL,

name        VARCHAR(40),

age         INT(2),

location    VARCHAR(40),

description CHAR(255),

email       VARCHAR(40)   NOT NULL,

userpage    VARCHAR

blogs       VARCHAR

profile     VARCHAR

warn        INT



PRIMARY KEY(id))";



$result=mysql_query($query);



?>





<!--open page header-->



<?php

require 'banner.php';

?>





<table width="817" align="center">



<tr>



<td width="215" background="http://staticfire.co.uk/images/sidebar_back.png" 

align="center" valign="top">



<br>



<?php

require 'login.php';

?>



<br>



<?php

require 'links.php';

?>



<br>



<?php

require 'top5.php';

?>





<br>



<?php

require 'active_list.php';

?>



</td>                





<!--Start main section-->





<td width="602" valign="top">



<!--Welcome note-->



<table width="100%" align="center" border="1" bordercolor="#CD0000" cellpadding="10">

<tr>

<td>



<center><font color="#707070">



<?php



$username="staticfire";

$password="xxxxxxx";

$database="staticfire";



mysql_connect('mysql10.streamline.net',$username,$password);

@mysql_select_db($database) or die("Unable to select database");



$query = "SELECT * FROM members"; 

     

$result = mysql_query($query) or die(mysql_error());





while($row = mysql_fetch_array($result)){



echo 

$row['id']. " - ". 

$row['loginname']. " - ".

$row['createdate']. " - ".

$row['password']. " - ". 

$row['name']. " - ".

$row['age']. " - ".

$row['location']. " - ". 

$row['description']. " - ".

$row['email']. " - ".

$row['userpage']. " - ".

$row['blogs']. " - ".

$row['profile']. " - ".

$row['warn']. " - ";



echo "<br />";

}

?>







</font></center>



</td>

</tr>

</table>







</td>

</tr>



</table>



<?php

require 'footer.php';

?>

Yes i am a noob.

Yes this is my first php site.

I know it's a lot but i'm desperate for help. I will be forever grateful to whoever helps me.
-Thanks

Oh and may i also add that their is a field for the id and create date in the registration form. It's not because i'm stupid but because i can't get them to work automatically

UnrealEd · #2 (**permalink**) 05-09-07, 04:54 PM

could you post your errors please? it would make it a lot easier for us to help

cheers

staticfire · #3 (**permalink**) 05-09-07, 04:55 PM

oops i think i used the wrong highlighters. Sorry this is my first post.

oh yes i should have done that. Heres the error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in e:\domains\s\staticfire.co.uk\user\htdocs\check_lo gin.php on line 29

phpdoctor · #4 (**permalink**) 05-09-07, 06:07 PM

This part on check_login.php looks weird?

PHP Code:


			
$worked = mysql_fetch_array($result); 



$loginname = $worked['loginname']; 

$password = $worked['password']; 

$email = $worked['email'];  



if($worked) 

  







if(isset($_session['loginname'])){  



echo"Welcome $_session['loginname']"; 



}else {echo"You are not logged in"; 



}

Take a look at this: (Untested)

PHP Code:


			


    if ($row = mysql_fetch_array($result))

    {

    $_SESSION['loginname'] = $row['loginname'] ;

    $_SESSION['email'] = $row['email'] ;

    $_SESSION['Loggedin'] = true ;

    echo 'WELCOME '.$_SESSION['loginname'] ;

    }

    else

    {

    echo 'TRY AGAIN' ;

    }

Tell us how it goes...

staticfire · #5 (**permalink**) 05-10-07, 02:08 AM

Thanks for that. It worked fine. I'll try and learn from my mistakes.