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.
