Jump to content

Clueless please help


carylson

Recommended Posts

Im not sure why I am receiving this error, any help is appreciated:

 

The error:

Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /hsphere/local/home/dtsabai/parrecsol.com/cp/login.php on line 13

Warning: mysql_query(): A link to the server could not be established in /hsphere/local/home/dtsabai/parrecsol.com/cp/login.php on line 13

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/dtsabai/parrecsol.com/cp/login.php on line 14

 

The Code:

<?php

$dbhost = 'mysql401.ixwebhosting.com:3306';

$dbuser = '***';

$dbpass = '***';

$dbname = '***';

 

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

 

mysql_select_db($dbname);

 

if ($_REQUEST['fcn'] == "login") {

 

if ($_REQUEST['frmUsername'] == "" || $_REQUEST['frmPassword'] == "") {

echo "Invalid login.  Please complete all form data and try again.";

}

else {

$UserInfoSQL = mysql_query("SELECT * FROM Users WHERE Username = '". $_REQUEST['frmUsername'] ."' AND Password = '". $_REQUEST['frmPassword'] ."'");

$UserInfo = mysql_fetch_array($UserInfoSQL);

 

if ($UserInfo) {

$_SESSION['LoggedIn'] = True;

$_SESSION['ID'] = $UserInfo['ID'];

$_SESSION['Username'] = $UserInfo['Username'];

$_SESSION['AdminLevel'] = $UserInfo['AdminLevel'];

 

echo "Login successful.  Hello, ". $_SESSION['Username'] ."!";

}

else {

echo "Invalid login.  The specified user could not be found.  Please double check your information and try again.";

}

}

}

?>

            .... some html

 

Lines 13/14:

$UserInfoSQL = mysql_query("SELECT * FROM Users WHERE Username = '". $_REQUEST['frmUsername'] ."' AND Password = '". $_REQUEST['frmPassword'] ."'");

$UserInfo = mysql_fetch_array($UserInfoSQL);

Link to comment
https://forums.phpfreaks.com/topic/84213-clueless-please-help/
Share on other sites

I don't see anywhere in your code where you've connected to the database with mysql_connect().  Neither do a I see reference to an include or require file that might do so.

 

Bottom line: You must connect to the database before you can run queries against it.

Link to comment
https://forums.phpfreaks.com/topic/84213-clueless-please-help/#findComment-428831
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.