Help

[delightful]

i sorted out my php files etc to show on my localhost connection to make sure everything was going ok, i clicked to go through to next page and that worked fine.

i entered my details in mysql so that i could check the the login section was working. once i clicked enter nothing happened.

i was told it would be session_start or the connection hasn't been put down right or even my mysql query in php code isnt right.

can someone help at all

thanks

sarah

[tsinka]

Hi,

please post some code 🙂

It's hard to guess anything without some code. Adding mysql_error() to your mysql_??? calls might help ...

Example:

$link = mysql_connect("host","user","pass") or die ("Connection error: ".mysql_error());

Additionally, add error_reporting(E_ALL); on top of the script you're having troubles with.

Generally: Enable error_reporting=E_ALL in php.ini and make sure that all of your scripts work without any warnings/errors.

Thomas

[delightful]

session_start();
include("dogs.inc");
switch (@$GET['do'])
{
case "Login":
$connection = mysql_connect($localhost, $root,$password)
or die ("Couldn't connect to server.");
$db = mysql_select_db($MemberDirectory, $connection)
or die ("Couldn't select database.");
$sql = "SELECT loginName FROM Member
WHERE loginName='$POST[fusername]'";
$result = mysql_query($sql)
or die ("Couldn't execute query.");

this is my php code i have been using, but something is wrong, i dont know if its not connecting with mysql or the apache server or if the session is not starting. Please help me. I hope this helps.

thanks

sarah

[tsinka]

Hi,

do not use switch in this case. It seems like you're having a form with method="post". Avoid mixing get and post variables in that case.

Do something like:

<form method="post" ...>
  ... inputs for name and password ...
  <input type="submit" name="login" value="Enter" />
</form>

Then:

session_start(); 
include("dogs.inc"); 

if (isset($_POST['login'])) {
  $onnection = mysql_connect($localhost, $root,$password) or die ("Connection error: ".mysql_error()); 
  mysql_select_db($MemberDirectory, $connection) or die("Selection error: ".mysql_error()); 
  $sql = "SELECT loginName FROM Member WHERE loginName='{$_POST['fusername']}'"; 
  $result = mysql_query($sql,$connection) or die("SQL error: ".mysql_error()); 

  // check the login data and so on
} else {
  echo "do parameter missing!<br>\n";
}

Do you have some password validation ? The password field is missing in the SQL query.

Thomas

[delightful]

thanks i will try that, i dont have a password for mysql, not yet anyway, want to get login working first

Thanks

Sarah