Please help -myphpadmin

[tigra123]

Hi There,

I have recently moved an old dynamic website to x10hosting. Created all the tables again in myphpadmin. Problem is that I cant get members to join/register on my website nor can I log into my website even though I have added my record details to table.
No errors are reported.
The register/join page on web site simply reloads itself after form has been filled in for new member to join.
What is going wrong ?- do I not have permissions ?or is it more likely a PHP coding problem. Any help appreciated!!

[Submariner]

More information is needed, like the PHP you are using to process the page and maybe a link to the site itself...

[taha116]

Ok firstly make sure you corrected all your config files like database username may have been "taha_admin" now it might be "tigra123_admin"

make sure that you import the database by creating a table with the same name and going to your original phpmyadmin page and pressing export.. press go and copy all the code it gives you and run it in the "SQL" section of your database that you created.

Basicly correct your settings for stuff like database paths passwrods etc.. whatever else changed besides hosts is important

[tigra123]

still no joy. All path names correct and user names correct.
Could it be that all the SQL quieries are in the php files that are in the CP? I havnt done any quieries directly in myphpadmin? forgive me but Iam not an expert at this!

[trev]

Are the PHP files running with the correct CHMod 755?

[tigra123]

hi, how can I check CHMod 755? I dont know what it is,

many thanks!

[trev]

Its the permissions on the files, either using an FTP client or using the file manager you need to edit the permissions of any file that needs to be executed.

[misson]

cPanel Tutorial: Files - File Permissions, but PHP scripts don't need to have execute permission. The minimum mode is 0600, giving the owner read permission and nothing else.

Please post a minimal test case and a link to a live sample. It's very hard to answer questions about code without seeing it.

[tigra123]

I have changed the permissions and it still doesnt work:dunno:
Edit:
here is the code for authorising a user to login. Since my details are entered into table row, I should be able to login from the website right?

<?php
include_once("config.php");

//Check for required fields from the form
if ((!$_POST[email]) || (!$_POST[password]))
{
header("Location: ../login.php");
exit;
}
//Connect to server
$conn = mysql_connect("localhost","$username","$password") or die(mysql_error());
//Select database
mysql_select_db("$database",$conn) or die(mysql_error());
//Create the query
$sql = "
select * from members
where
email = '$_POST[email]' AND password = password('$_POST[password]') AND status = '1'";
//Issue query
$result = mysql_query($sql,$conn) or die(mysql_error());
//Check the number of return rows
if (mysql_num_rows($result) == 1)
{
session_start();
$_SESSION[auth] = "1";
$_SESSION[id] = mysql_result($result, 0, 'id');
$_SESSION[fname] = mysql_result($result, 0, 'f_name');
$_SESSION[sname] = mysql_result($result, 0, 'l_name');
$_SESSION[user_email] = mysql_result($result, 0, 'email');
header("Location: ../index.php");
}
else
{
header("Location: ../login_error.php");
}

?>

many thanks for looking

[zapzack]

Heh.. This one's simple..

<?php 
include_once("config.php");

//Check for required fields from the form
if ((!$_POST[email]) || (!$_POST[password]))
{
header("Location: ../login.php");
exit;
}
//Connect to server
$conn = mysql_connect("localhost", $username, $password) or die(mysql_error());
//Select database
mysql_select_db($database,$conn) or die(mysql_error());
//Create the query
$sql = "
select * from members
where
email = '$_POST[email]' AND password = password('$_POST[password]') AND status = '1'";
//Issue query
$result = mysql_query($sql,$conn) or die(mysql_error());
//Check the number of return rows
if (mysql_num_rows($result) == 1)
{
session_start();
$_SESSION[auth] = "1";
$_SESSION[id] = mysql_result($result, 0, 'id');
$_SESSION[fname] = mysql_result($result, 0, 'f_name');
$_SESSION[sname] = mysql_result($result, 0, 'l_name');
$_SESSION[user_email] = mysql_result($result, 0, 'email');
header("Location: ../index.php");
}
else
{
header("Location: ../login_error.php");
}

?>

No quotes around variables.. try it now.. And if there are any errors, post them..