PHP - Simple Question On Variable

I'm trying to loop through a database and assign the results to a variable that is created with the loop with the variables name based on which instance is currently running in the loop.  I'll go ahead and include the code I thought might work, but I obviously have no idea what I'm doing in this case

$i = 0;
while ($i < $num_results) {
$ip = ($i++);
$result = ("$res_" . "$ip");
$loop_date = ("$res_" . "$ip" . "_date");
$get_result = "SELECT * FROM table WHERE id = '$result'";
$que_result = mysql_query($get_display);
while ($sub_res = mysql_fetch_array($que_result, MYSQL_BOTH)) {
$loop_date = $sub_res['date'];
}
$i++;
}
echo $res_1_date;

Can anyone please clue me in on how I can get this to work please.  It works with $result but it isn't working with the last $res_1_date... As I'm writing this I see where the problem is but just not quite sure how to make it work...

Hi there,

I am working on a PHP web form and I have a very simple situation I guess, I have a variable named: $MyVal

When I do

print_r($MyVal);
To see whats inside, I get:

SimpleXMLElement Object ( [0] => 8.23 )
Now I am assigning this variable into a session variable so that I can do calculations with it.

So I assign:

$_SESSION['MySesVal'] = $MyVal;
But after assigning to session variable, when I do my calculations:

$finalValue = $_SESSION['MySesVal'] * 4;

I get 0. So is it because the actual $MyVal variable has some XML stuff as:

SimpleXMLElement Object ( [0] => 8.23 )

So what is the right way to properly assign $MyVal variable to a session variable to do calculations.

Please reply.

All comments and feedbacks are always welcome.

Thank you!

I can't figure out why im getting an error with this code.

if ($notif = mysql_query("SELECT * FROM notifications_1 WHERE recieverid='". $_SESSION['id']."' ORDER BY read ASC, id DESC") or die (mysql_error())); {

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 'read ASC, id DESC' at line 1

hello all I'm VERY new to php and I just have a simple question

how do I bold the output text of this string

echo $row['name']."<BR>";

Hello everyone! I am a new user and I have a simple question. How do I set a password for a user to log in to my site with PHP? I have no MySQL database just a iOS code/host app. I know this isn’t secure but only me and my friends are on the site. Any help is appreciated. 

Hello there fellow programmers,

I was just wondering if there was any difference between doing this:

Code: [Select]
echo "Say Something Here";
and this

Code: [Select]
echo "Say ";
echo "Something ";
echo "Here";
Thank you in advance.

Notice: I am aware of the fact that they will output the same thing, my question is regarding resources.

I'm teaching myself php and mysql -- and my coding is a little rough.   But what i'm trying to do is display information from a mysql table in another table on a website.  I can do this just fine simply displaying the table, but i want a little something different.  I am only displaying one column of the table, instead of displaying it all in one column, i want to display the information in 5 columns.  for example.....  the table from mysql has names scott, john, james, mary, simon.  with the code I have i can make it display like this:
                                                                                         scott scott scott scott scott
                                                                                         john john john john john
                                                                                         james james james james james
                                                                                         mary mary mary mary mary
                                                                                         simon simon simon simon simon
i want it to diplay like this:
                                                                                          scott john james mary simon
                                                                                          new names will continue down

here is my code:

<?php

require ("connectigb.php");


$result = mysql_query ("SELECT pledgeName FROM pledgewall");

$fields_num = mysql_num_fields($result);


echo "<center> <h1>TSA It Gets Better Pledge Wall</h1>";
echo "<table border='1' align='center' style='width:960px;'><tr>";


while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
      if ($cell != "") {
for ($j=0; $j<5; $j++) {
        echo "<td>$cell</td>";
   }
   }

    echo "</tr>\n";

}
mysql_free_result($result);
echo "</table></center>";
?>

any ideas on what i can do here, i'm sure this is a simply fix.  i just haven't come across it yet.  thanks for the help in advance.

Hey! I have a drop down field for my "register" form, but this is clearly easy to edit, I just used tamperdata for firefox and yeah...pretty easy, is there any way that you could prevent tampering with the values when submitting this form!?

Hi guys, this function below is for card validation, however anycard i enter i get the invalid card number, this is not connected to any gateways, this is just an Luhn card validation demonstration.

can you tell me please why i get that?

<?php
  if ($_POST['pay'])
    {

$cardNo = addslashes(strip_tags($_POST['cardNo']));









function luhnCheck($cardNo) {
    $cardNo = str_replace(" ", "", trim($cardNo));
    if(!is_numeric($cardNo) or strlen($cardNo)>19) return false;
    $skip = $newNum = $total = 0;
    for($i=0;$i<=(strlen($cardNo)-1);$i++) {
        if($skip ==0) {
            $tmpNum = ($cardNo[$i]*2);
            $total += (strlen($tmpNum)==2 ? (substr($tmpNum, 0, 1)+substr($tmpNum, 1)) : $tmpNum);
            $skip = 1;
        }else{
            $total += $cardNo[$i];
            $skip = 0;
        }
    }
    return (($total % 10) == 0);
}

/* Example Usage */
if(luhnCheck($_GET['cc'])) {
    echo("Valid Number.");
}else{
    echo("Invalid Number.");
}





}





?>


<form name="confirm" method="post" action="">

<input type="text" name="cardNo">
 
                <input type="submit" name="pay" value="Pay Now">
                
  </form>

I know it could be a issue with this line if(luhnCheck($_GET['cc'])) { but im wondering where should and how put this cc in my form?

regards

I've seen this,
Code: [Select]
<?php } ?>
in a lot of scripts at the very end of the script. What does this piece of code do?

Hi, I'm working on a product page and I got it to list all the products in one column of a table, but when I add a second column it just duplicates the first column.  What do I need to change? 

Code: [Select]
<?php
require_once("functions.php"); 
?> 
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
td {
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: #30C;
border-right-color: #30C;
border-bottom-color: #30C;
border-left-color: #30C;
}
</style>
</head>

<body>
<form action="" method="post" name="catalog">
<?php 

DatabaseConnection();  

  $query = "SELECT * FROM treats";
        $result_set = mysql_query($query) or die(mysql_error());

        $output = "<table>";
        while ($row = mysql_fetch_array($result_set))
        {
            $output .= (" 
<tr>
<td width=\"400px\">" . $row['product_title']."<br /> ".$row['product_Description']."<br />" .$row['price'] . "<br />  Quantity: <input name=\"quantity\" type=\"text\" size=\"2\" /> </td>  
<td width=\"400px\">" . $row['product_title']."<br /> ".$row['product_Description']."<br />" .$row['price'] . "<br />  Quantity: <input name=\"quantity\" type=\"text\" size=\"2\" /> </td>  
</tr>
");
        }
        $output .= "</table>";
        echo $output;
?>   
</form>
</body>
</html>

Lets say I have:

$var=5;

What would an output look like to get me:

1<br>
2<br>
3<br>
4<br>
5<br>

Im at a complete loss!


Thanks!

if someone can help me out with this, its quite simple but I can't seem to get it to work..

Basically, this is the code I have for now, the issue is if I have 0 product or items, I don't want the sorting option to show up on the page,    from the code below, what line can I add tosay that if there is no products in a category, not to show the SORT feature.

thanks in advance if anyone can help.


{if isset($orderby) AND isset($orderway)}
<!-- Sort products -->
{if isset($smarty.get.id_category) && $smarty.get.id_category}
   {assign var='request' value=$link->getPaginationLink('category', $category, false, true)}
{elseif isset($smarty.get.id_manufacturer) && $smarty.get.id_manufacturer}
   {assign var='request' value=$link->getPaginationLink('manufacturer', $manufacturer, false, true)}
{elseif isset($smarty.get.id_supplier) && $smarty.get.id_supplier}
   {assign var='request' value=$link->getPaginationLink('supplier', $supplier, false, true)}
{else}
   {assign var='request' value=$link->getPaginationLink(false, false, false, true)}
{/if}
<form id="productsSortForm" action="{$request|escape:'htmlall':'UTF-8'}">
   <select id="selectPrductSort" onchange="document.location.href = $(this).val();">
      <option value="{$link->addSortDetails($request, $orderbydefault, $orderwaydefault)|escape:'htmlall':'UTF-8'}" {if $orderby eq $orderbydefault}selected="selected"{/if}>{l s='--'}</option>
      {if !$PS_CATALOG_MODE}
      <option value="{$link->addSortDetails($request, 'price', 'asc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'price' AND $orderway eq 'asc'}selected="selected"{/if}>{l s='Price: lowest first'}</option>
      <option value="{$link->addSortDetails($request, 'price', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'price' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='Price: highest first'}</option>
      {/if}
      <option value="{$link->addSortDetails($request, 'name', 'asc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'name' AND $orderway eq 'asc'}selected="selected"{/if}>{l s='Product Name: A to Z'}</option>
      <option value="{$link->addSortDetails($request, 'name', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'name' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='Product Name: Z to A'}</option>
      {if !$PS_CATALOG_MODE}
      <option value="{$link->addSortDetails($request, 'quantity', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'quantity' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='In-stock first'}</option>
      {/if}
   </select>
   <label for="selectPrductSort">{l s='Sort by'}</label>
</form>
<!-- /Sort products -->
{/if}

Hi.  I have an ID in md5 format but in the database its not.  I pass the md5 ID to a page and then I am trying to load the correct record via a look up in the database of that ID.  Im wondering is this code possible?



<?php $query = mysql_query("SELECT * FROM table WHERE ".md5(tableID)." = $ID"); ?>



Thanks

Hi, I am trying to convert a php function into perl and need to understand the following line in red :        function pagination($query, $per_page = 10,$page = 1, $url = '?'){       
     $query = "SELECT COUNT(*) as `num` FROM {$query}";
     $row = mysql_fetch_array(mysql_query($query));
     $total = $row['num'];
        $adjacents = "2";      $page = ($page == 0 ? 1 : $page); 
     $start = ($page - 1) * $per_page;        
  
     $prev = $page - 1;       
     $next = $page + 1;
        $lastpage = ceil($total/$per_page);
     $lpm1 = $lastpage - 1;
     
     $pagination = "";
     if($lastpage > 1)
     {  .........................................     What will be the output of this line above in red.   Thank you very much. Regards. Tonya