PHP - Simple Question I Think

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

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

Hello to everyone

I would like to ask for this simple question.. Im trying to put if and else condition on my php code. However this condition is not working..

Code: [Select]
if($file == #3#){
echo "No results found";
}else{ echo "results has been found"; }
This variable $file is the result after i used an API.. If the API does not see any results they would return #3# as the result. This means they returned a transaction code of 3 which you can see here http://developer.textapp.net/WebService/TransactionCodes.aspx means that there was nothing to return.

The condition does not function well even if i make 3 or #3# as part of the condition. Can you help me guys?

thanks

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!?

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'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>

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?

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.

SELECT * FROM `table1` VS SELECT * FROM table1

Which one is the best one to be used? n what is the difference?

Is using backticks can prevent me from sql injection which means better to use??

thanks in advance

Hey guys I have an array and want to make it into a sting and separate each array segment by a comma...is there a function for this or should I just do it in a loop myself?...thanks

Basically I am making a class which displays a set of data.
Now sometimes the data returned from the database will be a unix time stamp so this needs to be displayed in a correct form.
For this I use str_replace

$replace - below this will contain a way of converting the data
Replace is defined by:

$replace = 'date(\'d-m-y\',$row_data[\'lastupdate\'])';



$row.= str_replace('{data}',eval($replace),'<td>{data}</td>');


This just gives me
Parse error: syntax error, unexpected $end in C:\xampp\htdocs\z\src\lib\lib.table.php(348) : eval()'d code on line 1

Is this possible at all?

Hi i have a function strored in a seperate file (included in my main php page for use), my question is a simple one but i cannot seem to find the answer on the web to this:

I call the function as follows passing the variable $name


<?php
myfunction($name)
?>

The function does somehting simple such as:

<?php
function myfunction ($name)
{
   if ($name = 'bob')
  {
     return true;
  }
else return false;
}
?>


How do i then obtain the true or false value of the function from back with my main php page?

Hello.

I have a newbie question regarding arrays:

How can I echo an element's subsequent arrays and elements?

For example

Code: [Select]
$pers = array("Steve" => array("eyes" => "green", "age" => "43", "race" => "caucasian"));    



and if I echo $pers["Steve"] to make it display: green 43 caucasian.

Thanks.

I will state right here that I've never really delved into PHP before, but I'm prying apart the code on my site (a programmer made it for me). I've figured out how to add more checkboxes onto the page, but I've run into a problem.

Code: [Select]
'Artist' => array ( 'Cassiadawn', 'Cryptic', 'Diction', 'Glorfindel', 'Kyrislian', 'Russa', 'Ntkufreak', 'Taliba', 'Thunderbun', 'Velg', 'Lostdollie', 'Pookawitch') 

What I'm trying to do is replace  'Lostdollie', 'Pookawitch' with  'Lostdollie [R]', 'Pookawitch[R]'. How can I do this? I'd really appreciate any help anyone can give me!