PHP - Simple Mysql_query Question

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

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. 

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

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

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>";

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}

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!

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.

what does the # symbol do in php(e.x index.php?cat=1#privacy)? How can i use it? From what i 've seen you use it for changing a whole div without reloading the page like tabs..

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

SELECT COUNT(*) obviously counts all records matching the WHERE clause,

however...

Field1 / Field2
1 / A
   / A
1 / B
1 / A

I want to count all records where Field2 is "A", but if Field1 is set to "1" then that record counts as half. So above would return a result of 2 (one and two halfs = 2)

I'm sure SQL can do this without the need to perfrom PHP calculations.

Hope this makes sense. Thanks in advance.

this question seems so stupid, but i really want to know the best way to write this code.

let say i have this code:

if(empty($num))
{
header("Location:index.php");
}

is it okay if i write it down like this?

if(empty($num))
{
  header("Location:index.php");
}

i mean there is a whitespace behind header()

thanks in advance

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?