Will work for beer money

Codewalkers Forums Sponsor:

You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!

December 17th, 2005, 12:34 AM

icandothat

Moderator

Join Date: Apr 2007

Location: San Diego, CA

Posts: 1,548

Time spent in forums: 2 Days 2 h 20 m 4 sec
Reputation Power: 3

Will work for beer money

I just finished a long term PHP coding gig and I'm looking for work. Share the love.

December 18th, 2005, 09:20 AM

ababab

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: Will work for beer money

Well I can't pay much... but if you can add pagation to this search I'll pay you $25.

[div id="search" style="position:absolute; width:660px; height:115px; z-index:1; left: 29px; top: 244px;"]
[highlight=php]

$rs=mysql_connect ("localhost", "x", "x") or die ('I cannot connect to the database because: ' . mysql_error());

$rs=mysql_select_db ("x");

$sql = "SELECT * FROM `jobs` WHERE 1 ";

if (!empty($_POST['keyword'])){
$keyword = $_POST['keyword'];
$sql .= " AND keyword LIKE '%$keyword%' ";
}

if (!empty($_POST['city']) ){
$city = $_POST['city'];
$sql .= " AND city='$city' ";
}

if (!empty($_POST['state'] ) ){
$state = $_POST['state'];
$sql .= " AND state='$state' ";
}

if (!empty($_POST['catagory'])){
$catagory = $_POST['catagory'];
$sql .= " AND job='$catagory' ";
}

if (mysql_errno != 0){
echo "Error in query. Error is: " .mysql_error();
die();
}
$rs = @mysql_query($sql);

if(mysql_num_rows($rs) == 0){
echo("No Data match!");
}

$bgcolor = "#E0E0E0"; // light gray
while ($row = mysql_fetch_array( $rs ) )
{
if ($bgcolor == "#E0E0E0"){
$bgcolor = "#ffffcc";
}else{
$bgcolor = "#E0E0E0";
}

?>
<div id="results" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="<?php echo $bgcolor; ?>">
<td width="30%" align="center"><?php echo $row['keyword']; ?></td>
<td width="30%" align="center"><?php echo $row['city']; ?></td>
<td width="10%" align="center"><?php echo $row['state']; ?></td>
<td width="30%" align="center"><?php echo $row['job']; ?></td>
</tr>
</table></div><?php } ?></div>

December 18th, 2005, 11:32 AM

bakertrg

Contributing User

Join Date: Apr 2007

Location: Scottsdale AZ, US

Posts: 2,253

Time spent in forums: 2 h 48 m 45 sec
Reputation Power: 4

RE: Will work for beer money

lol, is that open to all?

php Code:

Original - php Code

$displaynum = 5; // this is results per page 
$startpoint = $_GET['startpoint'];
if ($startpoint == "") {
$startpoint = 0;
}

//********************************************** paginate  
// e = entries, s = startpoint d = displaynum u = url data
function paginate ($e, $s, $d, $u) {
    $numpages = floor($e/$d);
    if ($e % $d > 0){
        $numpages += 1;
    }
    $page = $s/$d + 1;
    $nextpage = $page + 1;
    $previouspage = $page - 1;
    
    echo "This is page $page of $numpages. There are $e total listings.  <br>";
    if ($previouspage > 0){
        $val = ($previouspage - 1) * $d;
        echo "<a href='?startpoint=$val$u'>previous</a>|";
    }
    for ($cnt = 1; $cnt <= $numpages ; $cnt ++){
        $val = ($cnt - 1) * $d;
        echo "<a href='?startpoint=$val$u'>$cnt</a>";
        if ($numpages > 1 && $cnt < $numpages) {
            echo "|";
        }
    }
    if ($nextpage <= $numpages){
        $val = ($nextpage - 1) * $d;
        echo "|<a href='?startpoint=$val$u'>next</a>";
    }
}

echo "<div id='search' style='position:absolute; width:660px; height:115px; z-index:1; left: 29px; top: 244px;'>";

$connect=mysql_connect ("localhost", "x", "x") or die ('I cannot connect to the database because: ' . mysql_error());

$db=mysql_select_db ("x");

$sql = "SELECT * FROM `jobs` WHERE 1 ";

if (!empty($_REQUEST['keyword'])){ 
$keyword = $_REQUEST['keyword']; 
$url .= "&keyword=".$keyword;
$sql .= " AND keyword LIKE '%$keyword%' "; 
}

if (!empty($_REQUEST['city']) ){ 
$city = $_REQUEST['city'];
$url .= "&city=".$city; 
$sql .= " AND city='$city' "; 
}

if (!empty($_REQUEST['state'] ) ){ 
$state = $_REQUEST['state'];
$url .= "&state=".$state; 
$sql .= " AND state='$state' "; 
}

if (!empty($_REQUEST['catagory'])){ 
$catagory = $_REQUEST['catagory'];
$url .= "&catagory=".$catagory; 
$sql .= " AND job='$catagory' "; 
}

$sql .= "LIMIT $startpoint, $display_num";

$rs = @mysql_query($sql); 
$entries = mysql_num_rows($rs);
if($entries == 0){ 
echo("No Data match!"); 
} else {
   echo "
     <div id='results' >
     <table width='100%' border='0' cellspacing='0' cellpadding='0'>
   ";
   while ($row = mysql_fetch_array($rs)){ 
      $bgcolor = ($bgcolor=="#ffffcc")?"#E0E0E0":"#ffffcc";
      echo "
        <tr bgcolor='$bgcolor'>
           <td width='30%' align='center'>".$row['keyword']."</td> 
           <td width='30%' align='center'>".$row['city']."</td> 
           <td width='10%' align='center'>".$row['state']."</td> 
           <td width='30%' align='center'>".$row['job']."</td> 
        </tr>
      ";
   } // close while
   echo "<tr><td colspan='4'>";
       paginate($entries, $startpoint, $diplaynum, $url);
   echo "</td></tr>";
   echo "</table> </div>";
} // close else
exho "</div>";

 
 
$displaynum = 5; // this is results per page 
$startpoint = $_GET['startpoint'];
if ($startpoint == "") {
$startpoint = 0;
}
 
//********************************************** paginate  
// e = entries, s = startpoint d = displaynum u = url data
function paginate ($e, $s, $d, $u) {
    $numpages = floor($e/$d);
    if ($e % $d > 0){
        $numpages += 1;
    }
    $page = $s/$d + 1;
    $nextpage = $page + 1;
    $previouspage = $page - 1;
    
    echo "This is page $page of $numpages. There are $e total listings.  <br>";
    if ($previouspage > 0){
        $val = ($previouspage - 1) * $d;
        echo "<a href='?startpoint=$val$u'>previous</a>|";
    }
    for ($cnt = 1; $cnt <= $numpages ; $cnt ++){
        $val = ($cnt - 1) * $d;
        echo "<a href='?startpoint=$val$u'>$cnt</a>";
        if ($numpages > 1 && $cnt < $numpages) {
            echo "|";
        }
    }
    if ($nextpage <= $numpages){
        $val = ($nextpage - 1) * $d;
        echo "|<a href='?startpoint=$val$u'>next</a>";
    }
}
 
echo "<div id='search' style='position:absolute; width:660px; height:115px; z-index:1; left: 29px; top: 244px;'>"; 
 
 
 
$connect=mysql_connect ("localhost", "x", "x") or die ('I cannot connect to the database because: ' . mysql_error()); 
 
$db=mysql_select_db ("x"); 
 
$sql = "SELECT * FROM `jobs` WHERE 1 "; 
 
if (!empty($_REQUEST['keyword'])){ 
$keyword = $_REQUEST['keyword']; 
$url .= "&keyword=".$keyword;
$sql .= " AND keyword LIKE '%$keyword%' "; 
} 
 
if (!empty($_REQUEST['city']) ){ 
$city = $_REQUEST['city'];
$url .= "&city=".$city; 
$sql .= " AND city='$city' "; 
} 
 
if (!empty($_REQUEST['state'] ) ){ 
$state = $_REQUEST['state'];
$url .= "&state=".$state; 
$sql .= " AND state='$state' "; 
} 
 
if (!empty($_REQUEST['catagory'])){ 
$catagory = $_REQUEST['catagory'];
$url .= "&catagory=".$catagory; 
$sql .= " AND job='$catagory' "; 
} 
 
$sql .= "LIMIT $startpoint, $display_num";
 
 
$rs = @mysql_query($sql); 
$entries = mysql_num_rows($rs);
if($entries == 0){ 
echo("No Data match!"); 
} else {
   echo "
     <div id='results' >
     <table width='100%' border='0' cellspacing='0' cellpadding='0'>
   ";
   while ($row = mysql_fetch_array($rs)){ 
      $bgcolor = ($bgcolor=="#ffffcc")?"#E0E0E0":"#ffffcc";
      echo "
        <tr bgcolor='$bgcolor'>
           <td width='30%' align='center'>".$row['keyword']."</td> 
           <td width='30%' align='center'>".$row['city']."</td> 
           <td width='10%' align='center'>".$row['state']."</td> 
           <td width='30%' align='center'>".$row['job']."</td> 
        </tr>
      ";
   } // close while
   echo "<tr><td colspan='4'>";
       paginate($entries, $startpoint, $diplaynum, $url);
   echo "</td></tr>";
   echo "</table> </div>";
} // close else
exho "</div>";

December 18th, 2005, 12:05 PM

System

Join Date: Apr 2007

Posts: 665

Time spent in forums: < 1 sec
Reputation Power: 2

Message Moved

Thread moved from 'PHP Coding' to 'Barter Zone' by tkarkkainen.

Reason:

December 18th, 2005, 09:38 PM

lig

"Forum Nazi"

Codewalkers Demi-God (4500 - 4999 posts)

Join Date: Apr 2007

Location: Jacksonville, Fl

Posts: 4,720

Time spent in forums: 4 Days 20 m 53 sec
Reputation Power: 6

RE: Will work for beer money

MySQL is looking for web developers - worldwide.

http://www.mysql.com/company/jobs/webdeveloper.html

Always good to know what is out there. *sigh* I'd apply but all my stuff is intranet so no URLS

December 20th, 2005, 12:46 AM

ababab

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: Will work for beer money

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/x/public_html/x/searchwithpaging.php on line 75

I am getting this message.

What should i do?

December 20th, 2005, 01:10 AM

bakertrg

Contributing User

Join Date: Apr 2007

Location: Scottsdale AZ, US

Posts: 2,253

Time spent in forums: 2 h 48 m 45 sec
Reputation Power: 4

RE: Will work for beer money

I can't see your code, hopefully you changed the code to match your table etc.

first you should get rid of the @ sign on your query it suppresses errors.

echo your query when it's complete so you can see if it has the proper query you're expecting.

you may be getting 0 results, or else you may be having trouble with mysql_num_rows() I have had this kind of problem in the past. It's not always clear to me why this function fails at certain times.

December 20th, 2005, 01:38 AM

ababab

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: Will work for beer money

the query is fine... It is running and working well on another page. The mysql_num_rows()works as well on other searches...so.. I will try and figure it out...if I have anymore questions I'll send them.

I will send the money either tonight or tomorrow..no problem

I have to become a member of pay pal still.

Thanks for your help

December 20th, 2005, 03:04 AM

bakertrg

Contributing User

Join Date: Apr 2007

Location: Scottsdale AZ, US

Posts: 2,253

Time spent in forums: 2 h 48 m 45 sec
Reputation Power: 4

RE: Will work for beer money

if you want to test the pagination code you can switch to adding a second query.

use the first query

"SELECT count(id) AS entries FROM table WHERE blah blah blah ";

to get the same results as mysql_num_rows() and you'll see that the pagination works.

#10

December 21st, 2005, 03:57 AM

ababab

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: Will work for beer money

the code isnt working... I have been working on it for a while. have any more suggestions?