Jump to content

Could not connect to MySQL: etc...


zaljereck

Recommended Posts

Hello all,

This is my first post in here, so go easy.

I recently transferred my account from my local ISP to GoDaddy. And now my search criteria is not working. I am getting the follow error message on the page of my search box, instead of the graphics itself:

Could not connect to MySQL:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

 

I thought maybe this would be a simple error when I found out that GoDaddy does not use the "localhost" connect string. So I switched it to the local IP for GoDaddy still to no avail. I am lost after that. My PHP skills are limited. I was taught by a very advanced user who uses shortcuts and different strings self made for his ease. So looking online for solutions for the script was very hard(to me at least), because the lines of code do not match common scripts online.

 

Is this a simple solution?

Does the:

 

global $dbc;

@dbConnect();

 

function work with GoDaddy? Because I have seen maybe different ways to connect to a DB with PHP.

Here's the script I am using to connect and extract results from the DB. Any and all help will be greatly appreciated. Thanks in advance.

 

Using MySQL Version 4:

 

<?
@require("searchheader.php");

?>
<table cellpadding=10 cellspacing=0 border=0>
    <tr>
        <td align=left valign=top>
<?

displayMenu();

?>
</td>
        <td align=right valign=bottom>
<?

if($_GET["f_catid"]){

    $num_cats = 5;
    for($i=1;$i<=$num_cats;$i++){
        $where .= " or c".$i." = ".$_GET["f_catid"];

    }
    $where = substr($where,4,strlen($where));

    $sql = "select * from product where ".$where." order by product_name ASC LIMIT 0,20";
    dbConnect();
    $result = mysql_query($sql,$dbc);

    ?>
    <div class="search_results_menu">
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align: center;"><input type="button" name="submit_top" value="Check Out">
            </form>
            
    <table class="search_results_found" bgcolor="#efefef" cellpadding=3 cellspacing=0 border=1 bordercolor="#000000" style="border:1px solid #000000;">
        <tr bgcolor="#efefef">
                <td class="search_results_title"><b>Manufacturer</b></td>
                <td class="search_results_title"><b>Part Number</b></td>
                <td class="search_results_title"><b>Part Name</b></td>
                <td class="search_results_title"><b>Price</b></td>
                <td class="search_results_title"><b>Image</b></td>
                <td class="search_results_title"><b>Add to Cart</b></td>
        </tr>
    <?
    if(mysql_num_rows($result) > 0){
        while($row = mysql_fetch_assoc($result)){
            ?>
            <tr bgcolor="#efefef">
                <td><?=$row["manufacturer"]?></td>
                <td><a href="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$row["part_number"]?>&linecode=<?=$row["manufacturer"]?>"><?=$row["part_number"]?></a></td>
                <td><?=$row["product_name"]?></td>
                <td>$<?=$row["price"]?></td>
                <td><a href="[url=http://www.wlpsr.com/images/]http://www.wlpsr.com/images/[/url]"<?=$row["part_number"]?>".jpg " onClick="window.open('/images/<?=$row["part_number"]?>.jpg', '<?=$row["part_number"]?>', 'toolbar=yes, directories=no, location=no, status=yes, menubar=no, resizable=yes, scrollbars=yes, height=300, width=400'); return false">View</a></td>
                <td><form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align:center;">
                    </form>
                </td>
            </tr>
            <?
            }
        }
    else{
        ?>
        <tr>
            <td colspan=100 align="center"><b>No products in this category.</b></td>
        </tr>
    </table>
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align: center;"><input type="button" name="submit_top" value="Check Out">
            </form>
            </td>
        </tr>
        <?
        }
    ?>
</td>
</tr>
</table>
</div>
    <?

    }

?>

        <div class="form">
        <form name="search" action="<? echo $_SERVER['PHP_SELF']; ?>" method="GET">
        <input type="text" name="f_keywords" size="17" value="" maxlength="100">
        <input type="image" src="gobutton.gif">
        </form>
        </select>
        <br><br><br>
<?

$trimmed = trim(strip_tags($_GET["f_keywords"]));

//Set the database access information as constants.
if(strlen($trimmed) > 0){
    define ('DB_USER', 'USERNAME');
    define ('DB_PASSWORD', 'THEPASSWORD');
    define ('DB_HOST', 'LOCALIP');
    define ('DB_NAME', 'DBNAME');
    define ('DB_TABLE', 'TABLE');

    //Make the connection to the DB

    global $dbc;
    @dbConnect();

$query = "SELECT * FROM product WHERE manufacturer LIKE '%$trimmed%' OR part_number LIKE '%$trimmed%' OR price LIKE '%$trimmed%' OR product_name LIKE '%$trimmed%' order by manufacturer";

$result = mysql_query($query);
$count = mysql_numrows($result);

if ($trimmed == "")
{
echo "Please enter a search criteria...";
exit;
}

// check for a search parameter
if (!isset($result))
{
    echo "<p>Please enter a search parameter!</p>";
    exit;
    }

$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);

if ($numrows == 0)
{
echo "<h4>Results</h4>";
echo "<p>We are sorry <b>$trimmed</b>  has returned zero results.</p></font>";
}

// next determine if s has been passed to script, if not use 0
if (empty($s))
{
$s=0;
}

// get results
$result =  mysql_query($query,$dbc);

if($numrows < 1){ $return= "results";}
else{ $return = "result"; }
if($numrows > 1){ $return = "results";}
else{ $return = "result"; }



// display what the person searched for
echo "Your search for ", " <b>$trimmed</b>  ", " found <br><b>$numrows $return.</b>";

// begin to show results set
$count = 1 + $s ;

}
if(strlen($trimmed) > 0){
?>
</div>
    <div class="search_results">
    <table cellpadding=0 cellspacing=0 border=0>
        <tr>
            <td align="right">
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align:
            center;"><input type="button" name="submit_top" value="Check Out">
            </td>
        </tr>
        <tr>
        <td>
    <table class="search_results_found" bgcolor="#efefef" cellpadding=3 cellspacing=0 border=1 bordercolor="#000000" style="border:1px solid #000000;">
        <tr>
            <td width="100" class="search_results_title" align="center"> Manufacturer </td><td width="70"
        class="search_results_title" align="center"> Part Num. </td><td width="115" class="
        search_results_title" align="center">         Description </td><td width="60" class="search_results_title" align="center">Price</td><td width="45" class="
        search_results_title" align="center"> Image </td><td width="105" align="center"><b>Add to Cart</b>
            </td>
        </tr>
        </td>
        </tr>

<?

while ($r= mysql_fetch_array($result))

{
$manufacturer = $r["manufacturer"];
$part_number = $r["part_number"];
$product_name = $r["product_name"];
$price = $r["price"];

$count++;
echo "<tr><td>$manufacturer</td><td>";
echo "<a href=\"[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]".$r["part_number"]."&linecode=".$r["manufacturer"]."\">".$r["part_number"]."</a></td><td>";
echo "$product_name</td><td>";
echo "$ $price</td><td>";
echo "<a href=\"[url=http://www.wlpsr.com/images/]http://www.wlpsr.com/images/[/url]".$r["part_number"].".jpg \" onClick=\"window.open('/images/".$r["part_number"].".jpg', '".$r["part_number"]."', 'toolbar=yes, directories=no, location=no, status=yes, menubar=no,  resizable=yes, scrollbars=yes, height=300, width=400'); return false  \">View</a></td><td>";
echo "<form action=\"[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]".$r["part_number"]."&linecode=".$r["manufacturer"]."\" method=\"GET\"><input type=\"text\" name=\"quantity\" size=\"2\" value=\"0\" style=\"text-align:center;\"></td></tr>";

}

?>
        </table>
        <tr>
            <td align="right">
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align:
            center;"><input type="button" name="submit_bottom" value="Check Out">
            </td>
        </tr>
<?
}
?>
    </table>
    <br><br>
    </div>
<?
@require("footer3.php");
?>

 

Mod edit:

 . . . 

tags added.

Link to comment
Share on other sites

dbConnect() isn't defined in that code. Is it in an include()d file somewhere?

 

Also, please refrain from posting duplicate topics.

 

Sorry..I realized that I put the code in the wrong forum and did not deleted it. I'm new made a mistake, I apologize.

 

I remember setting up an include file at first but then decided to do all the coding on one page, so no there is no include file.

 

To ask a question...on lines 32-34:

$sql = "select * from product where ".$where." order by product_name ASC LIMIT 0,20";

    dbConnect();

    $result = mysql_query($sql,$dbc);

 

I have that. Now what would be defined inside the parenthesis? Would it just be UN, PASS and DB name etc..? Like I said, I am a novice at this and was taught over my head. This is for a work project so any help will be appreciated.

 

Thanks again.

Link to comment
Share on other sites

If you want to write a function for it, you can use this as a jumping off point.

 

function dbConnect($host, $user, $pass, $db) {
if( @mysql_connect($host, $user, $pass) ) {
	if( mysql_select_db($db) ) {
		return true;
	} else {
		$errors[] = 'Unable to select DB: ' . mysql_error();
	}
} else {
	$errors[] = 'Unable to connect to database: ' . mysql_error();
}
if( !empty($errors) ) {
	return $errors;
}
}

Link to comment
Share on other sites

If you want to write a function for it, you can use this as a jumping off point.

 

function dbConnect($host, $user, $pass, $db) {
if( @mysql_connect($host, $user, $pass) ) {
	if( mysql_select_db($db) ) {
		return true;
	} else {
		$errors[] = 'Unable to select DB: ' . mysql_error();
	}
} else {
	$errors[] = 'Unable to connect to database: ' . mysql_error();
}
if( !empty($errors) ) {
	return $errors;
}
}

 

Thanks again...I'll try it this way and I'll close this topic if it works  :)

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.