PHP - Adding Numbers Returned From Mysql Query

Search not functioning. The drop down box to search on Club_Name and Email is blank, clicking search results unchanged ... all suggestions appreciated ... newbie at php.  Thanks.

<!-- Code below is not functional, trying to query search results, search box with drop down box for two fields-->
<table width="50%">
         <tr>
            <td height="30"  align="left" bgcolor="#FFFFFF" class="form1" >
            {$letter_links}
            </td>
            <td height="30"  align="right" bgcolor="#FFFFFF" class="form1" >
            <input type=hidden name="sorter" value="{$sorter}">
               <table><tr>
               <form name="search_form" action="{$form.action}" method="post">
               <td class="form1" ><input type="text" name="search" value="{$search}"></td>
               <td class="form1" ><select name="s_type" style="">
               {section name=s loop=$types}
               <option value="{$smarty.section.s.index_next}" {if $types .sel}selected{/if}>{$types .value}</option>
               {/section}
               </select></td>
               <td class="form1"><input type="button" value="{$button.search}" class="button" onclick="javascript: document.search_form.submit();" name="search_submit"></td>
               </form>
               </tr></table>
            </td>
         </tr>
         </table>
   <!-- Code below successfully displays query results -->
     <form method="post" action="{$file_name}?sel=approve" enctype="multipart/form-data" name="form1" onsubmit="foo(); return false;">
      <table cellspacing="2" cellpadding="10" border="1">
        <tr align="center"><td>Num</td><td>Club Name</td><td>Login</td><td>Country</td><td>Region</td><td>City</td><td>Address</td><td>Web site</td><td>Email</td><td>Contact Name</td><td>Contact Phone</td><td>Swinging</td><td>Alcohol</td><td>Food</td><td>Entertainment</td><td>Fees</td><td>Approved/<br/>Rejected</td><td>Actions</td></tr>
        {foreach item=item from=$contest key=key name=foo}         
         <tr align="center"><td><input type="hidden" name="all_approves[{$item.id}]" value="{$item.id}"/>{$key+1}</td><td>{$item.name}</td><td>{$item.login}</td><td>{$item.country_name}</td><td>{$item.region_name}</td><td>{$item.city_name}</td><td>{$item.address}</td><td>{$item.web_site}</td><td>{$item.email}</td><td>{$item.contact_name}</td><td>{$item.contact_phone}</td>
<td>
{math equation="x - 1" x=$item.swinging   assign=index_pos}
{$xml_swing[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.alcohol   assign=index_pos}{$xml_alco[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.foot   assign=index_pos}{$xml_foot[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.entertainment   assign=index_pos}{$xml_entertainment[$index_pos].value}</td>
<td>{math equation="x - 1" x=$item.fees   assign=index_pos}{$xml_fees[$index_pos].value}</td><td>
         <span>  {if $item.is_approved eq '1'} Approved {else} Rejected {/if}</span></td><td align="center"><a href="{$file_name}?sel=edit&id_content={$item.id}">[&nbsp;Edit&nbsp;]</a><br/><a href="{$file_name}?sel=delete&id_content={$item.id}">[&nbsp;Delete&nbsp;]</a><br/><a href="{$file_name}?sel=approve&id_content={$item.id}">[&nbsp;Approve&nbsp;]</a><br/><a href="{$file_name}?sel=reject&id_content={$item.id}">[&nbsp;Reject&nbsp;]</a></tr>
      {/foreach}
      </table>
     </form>

I'm trying to develop some php that will execute a MySQL query and move the results into XML.  In this particular instance, only one record is expected to be returned, and that one row will contain all the customer data, such as last name, first name, address1, etc.

While I can get my code to work and create the xml if I hard-code in all the keys (MySQL column names), I would like it to dynamically step through all the keys/MySQL column names so that if the db changes later (add more columns, for instance) the code generating the XML won't need to be altered.   

It should take the MySQL column name, create an element based on the column name, then create a text node and insert the value. 

Currently I'm just at the spot of testing by echoing the appropriate key/value pairs.  The code is stopping after the first key/value without going through the rest of the columns.  What do I need to do in order to get it to dynamically step through each column and get the key/value?

Here's the relevant code:
if($_POST['buscode'])

{echo "buscode is: ".$_POST['buscode']."<HR>";}
else 

{echo "ERROR WITH RETRIEVING BUSCODE<HR>";}
$buscode = $_POST['buscode'];
$query = "SELECT * " 

."FROM customers " 

."WHERE buscode = '$buscode'";
echo "Query will be: ".$query."<HR>";
$result = mysql_query($query);
if($result){echo "Success retrieving data from ats_ajax.<HR>";}
else{echo "Error retrieving data from ats_ajax\; MySQL error is:".mysql_error($result)."<HR>";}

////////////////////////////////////////
//  Let's test getting the keys and values from the array....
///////////////////////////////////////
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{

echo "This is step ".$i."<BR>"; 

$key = key($row);

echo "Key is: ".$key."<BR>";

echo "Value is: ".$row[$key]."<BR>";

$i++;

}//close of while

I'm hoping this is a simple question.
When I use the code below, my twitter search query appears in BOLD within the returned results. I would like to style the search term differently. I can use CSS to style the avatar, author, and other information within the returned results etc, but I can't figure out how to style the search term ($q) within the returned twitter information. Any help would be much appreciated.

<?php

class twitter_class
{    
    function twitter_class()
    {
        $this->realNamePattern = '/\((.*?)\)/';
        $this->searchURL = 'http://search.twitter.com/search.atom?lang=en&q=';
        
        $this->intervalNames   = array('second', 'minute', 'hour', 'day', 'week', 'month', 'year');
        $this->intervalSeconds = array( 1,        60,       3600,   86400, 604800, 2630880, 31570560);
        
        $this->badWords = array('somebadword', 'anotherbadword');
    }

    function getTweets($q, $limit=15)
    {
        $output = '';

        // get the search result
        $ch= curl_init($this->searchURL . urlencode($q));

        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']);
        $response = curl_exec($ch);

        if ($response !== FALSE)
        {
            $xml = simplexml_load_string($response);
    
            $output = '';
            $tweets = 0;
            
            for($i=0; $i<count($xml->entry); $i++)
            {
                $crtEntry = $xml->entry[$i];
                $account  = $crtEntry->author->uri;
                $image    = $crtEntry->link[1]->attributes()->href;
                $tweet    = $crtEntry->content;
    
                // skip tweets containing banned words
                $foundBadWord = false;
                foreach ($this->badWords as $badWord)
                {
                    if(stristr($tweet, $badWord) !== FALSE)
                    {
                        $foundBadWord = true;
                        break;
                    }
                }
                
                $tweet = str_replace('<a href=', '<a target="_blank" href=', $tweet);
                
                // skip this tweet containing a banned word
                if ($foundBadWord)
                    continue;

                // don't process any more tweets if at the limit
                if ($tweets==$limit)
                    break;
                $tweets++;
    
                // name is in this format "acountname (Real Name)"
                preg_match($this->realNamePattern, $crtEntry->author->name, $matches);
                $name = $matches[1];
    
                // get the time passed between now and the time of tweet, don't allow for negative
                // (future) values that may have occured if server time is wrong
                $time = 'just now';
                $secondsPassed = time() - strtotime($crtEntry->published);

                if ($secondsPassed>0)
                {
                    // see what interval are we in
                    for($j = count($this->intervalSeconds)-1; ($j >= 0); $j--)
                    {
                        $crtIntervalName = $this->intervalNames[$j];
                        $crtInterval = $this->intervalSeconds[$j];
                            
                        if ($secondsPassed >= $crtInterval)
                        {
                            $value = floor($secondsPassed / $crtInterval);
                            if ($value > 1)
                                $crtIntervalName .= 's';
                                
                            $time = $value . ' ' . $crtIntervalName . ' ago';
                            
                            break; 
                        }
                    }
                }
                
                $output .= '
                <div class="tweet">
                    <div class="avatar">
                        <a href="' . $account . '" target="_blank"><img src="' . $image .'"></a>
                    </div>
                    <div class="message">
                        <span class="author"><a href="' . $account . '"  target="_blank">' . $name . '</a></span>: ' . 
                        $tweet . 
                        '<span class="time"> - ' . $time . '</span>
                    </div>
                </div>';
            }
        }
        else
            $output = '<div class="tweet"><span class="error">' . curl_error($ch) . '</span></div>';
        
        curl_close($ch);
        return $output;
    }
}

?>


The HTML I have been using with this code is here
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Twitter</title>
</head>
<body>
<?php
  require('twitter.class.php');
  $twitter = new twitter_class();
  echo $twitter->getTweets('example search term', 10);
?>
</body>
</html>
This is not my code. It is from a tutorial that can be accessed from here >> http://www.richnetapps.com/php-twitter-search-parser/

here is my code... please help

<form method="get" action="shit3.php">
<input maxlength="50" size="50" type="text" name="q"> <input type="submit" value="SEARCH">
</form>

<?php

if (@$_GET['q']) {

 $var = $_GET['q'] ;
 $trimmed = trim($var);

$limit=1;

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

   if (!isset($var))
       {
          echo "Container not found!";
    exit;
   }

mysql_connect("localhost", "xxx", "yyy") or die(mysql_error());
mysql_query("SET NAMES 'cp1251'");

mysql_select_db("agaexpor_container") or die("Unable to select database"); //select which database we're using

$query = "select * from containertracking where vin like \"%$trimmed%\"
 order by vin";

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

if (empty($s)) {
 $s=0;
 }

$query .= " limit $s,$limit";
 $result = mysql_query($query) or die("Couldn't execute query");

$count = 1 + $s ;

while ($row= mysql_fetch_array($result)) {
 $vin = $row["vin"];
 $container = $row["container"];

 echo "$count.) VIN: $vin <br />";
 echo "container is: $container <br />";
 
 $count++ ;
 }

}
?>

I was just wondering when you run a mysql query what the easiest way to find out the number of rows returned.  Just so I can do a number of results found on a search.  Thanks. 

This is my current script
<?php
$iFile = "accounts.txt"; //Put your list lagger's info in this txt file in the same directory as this script. Format is UserID(space)AuthKey

$login = file($iFile, FILE_SKIP_EMPTY_LINES);

if(!is_file($iFile)) echo "The logins file couldn't be found...".sleep(999999);

foreach($login as $line_num => $line)
{
$login = explode(" ", htmlspecialchars(str_replace("    "," ",$line)));
////////////////
//////////////
///////////
/////////
 if(stristr($login[1], "\n")) $login[1] = substr($login[1], 0, strlen($login[1])-2);

$MobLink = "http://mobsters-fb-apache-dynamic-lb.playdom.com/mob_fb/";
$RefreshStat = file_get_contents($MobLink."refresh_stat?user_id=".$login[1]."&auth_key=".$login[0]);


$Mob_Name = explode("<mob_name>", $RefreshStat);
$Mob_Name = explode("<", $Mob_Name[1]);
$Name = $Mob_Name[0];
$Cash = explode("<cash>", $RefreshStat);
$Cash = explode("<", $Cash[1]);
$CurrentCash = $Cash[0];
echo $Name."-$".number_format($CurrentCash)." - ".$login[1]."\n";
}







sleep(99999);






?>



The Script runs through for 100 different accounts, is it possible to add all the Cash values that get echo'd?

So I'm querying my database to add the results (mapID's) into a PHP array.
The MySQL query I used in the below code would usually return 10 values (only 10 mapID's in the database)

Code: [Select]
while($data = mysql_fetch_array(mysql_query("SELECT mapID FROM maps"))){
$sqlsearchdata[] = $data['mapID'];
}
Instead the page takes ages to load then gives this error:
Quote

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 16 bytes)

It says the error begins on the first line of the above code. I'm assuming this is not the right way to add the value from the MySQL array into a normal PHP array.

Can anyone help me?

Hi

Please take a look at my code snippet. I don't know how to get the number of rows returned from a MySQL stored procedure so that I can handle it accordingly. Any ideas please?

Thanks

Hi all

I am adding some positive and negative numbers.

But i am getting strange output. Can anyone help me

Here is the code.

Code: [Select]
$sum=7.50+6.45+12.90+12.00+13.00+0.61+32.00+4.00+27.00+18.00+10.88+129.50+92.94-100.00-38.25+76.80-305.33;
echo "<br>Total: ".$sum;

Basically i have to get Total is 0

but i am getting total is 5.6843418860808E-14

Can anyone help me out Please

Hi iam currently writing some code for my website and i have a number of records that i simply want to display in a table format, i have done this in a while loop and it works well, however i only want to display a maximum of 10 records per page as my div needs to be a fixed height and was wondering how i could include a next button that would act as like a page number. The thing is at any given point there could be from 1 record to display to 500, so i need a way of allowing the user to quickly navigate to the other records. How can i do this without using mulitple pages.

Hope this makes sense.

Heres my code

Code: [Select]
<?php echo"<table width='100%' border='1' align='center'><tr><th>Referal Name</th><th>Amount Received</tr>";
while ($row = mysql_fetch_array($sql_info))
{
extract($row);
echo "<tr><td align='center'>".$username."</td><td align='center'>".$cumulative_referral."</td></tr>";
}
echo "</table>";


?>
Thanks for your help

Hi all,

for some reason I cant see this blantantly obvious query.

I have 3 rows in my database, all with an id of 1, their is a column called price which contains three different float values, how the hell do I write a query in php for this?!
Code: [Select]
$q = mysql_query("SELECT price FROM mytable WHERE id=1")
????Thanks!

Hi All Again

I am building a job site with a CV match system. Part of the match is education. I have a number of select boxes in a form for the number of qualifications for each individual applicant. What I would like to know is what is the correct way to put this into a MySQL database and I do not mean the insert code!

i.e. English Grade 3. Maths Grade 2.

I am getting them to put in total number of grades over 1, then 2 etc. When the query is made I would like the recruiter have the option of not just selecting the grades but subject with it. Should I put English then a , then the grade? It needs to be set up so I can run the query.

Thanks for looking and as per last request thanks for your time and help

Here is my code:
// Start MySQL Query for Records
$query = "SELECT codes_update_no_join_1b" .
"SET orig_code_1 = new_code_1,
       orig_code_2 = new_code_2" .
"WHERE concat(orig_code_1, orig_code_2) = concat(old_code_1, old_code_2)";
$results = mysql_query($query) or die(mysql_error());
// End MySQL Query for Records


This query runs perfectly fine when run direct as SQL in phpMyAdmin, but throws this error when running in my script??? Why is this???

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= new_code_1, orig_code_2 = new_code_2WHERE concat(orig_code_1, orig_c' at line 1

Hey again guys! I'm back already today. XD Okay, so... I'm building a script, right. I have a form that is a simple text field. I do NOT want to use javascript. I want to be able to use PHP to be able to do this. Here is the form exactly as it is now:

Code: [Select]
<form action="<?php echo "$PHP_SELF"; ?>" method="POST">
<input type="text" name="price">

How would I only allow a number, and up to 5 digits long, like, for example, a zip code. I know I can always limit the char space, but they might be able to "inject" it?

On another note for forms, what would I have to do to get rid of people being able to run a script through a form; is it the strip_tags(); function?
Thanks for your help in advance guys!

Hello,

i'm trying to server-side validate input from POST to insert it into mysql if the requirements for the insert are met.

i was using jquery before but this isn't reliable at all, i want the data to get inserted into mysql only if the length is 19 chars and only if it starts with 3227580 the next 12 digits can be any number.

So basically: IF chars=19 and data=3227580* insert into mysql -- else show error

Thank you for help.