PHP - Results Not Displaying - Fetch Array Error

Hi,

I'm wondering if theres a shortcut to a potential problem I have.
I'm currently running a query on my website to pull all the fields from a table in my database, for the data to be used on various parts of the page.

Usually I would do something as follows

Code: [Select]
$result = mysql_query("SELECT * FROM table WHERE page='1'");

while ($row=mysql_fetch_array($result))
 {
 $title = $row["title"];
 $data = $row["data"];
 }

And so on and so forth. I would then call the appropriate data by echoing $data for example.
However, my table contains a lot more rows than i've mentioned (Around 25 or so). Rather than assigning each to a variable and having a large portion of variable assignments at the top of the page, is there any clever way of putting all of these values inside of an array.
So for example, I could call $array_data["title"] or $array_data["data"]??
So it keeps the same key, but puts it inside of an array that I don't have to loop through each time?

Hope that makes sense!

Thanks,
Edd

Hello

i want to fetch the content from my MySQL db for one table and show it on a page, i'm using this code:
Code: [Select]
<?php include("inc/connect.php"); ?>
<?php
$result = $_REQUEST['result'];
?> Code: [Select]
<?php
$query = mysql_query("select * from listtest order by id asc");
while($result = mysql_fetch_array($query))
{
?>
  <tr>
    <td><?php echo $result['id']; ?></td>
    <td><?php echo $result['code']; ?></td>
    <td align="center"><a href="edit.php?id=<?php echo $result['id']; ?>">View</a></td>

    <td align="center">&nbsp;</td>
  </tr>
<?php } ?>

it's throwing me this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in 32qgtf.php on line 30

What am i doing wrong ?

/Edit: line 29/30 is the mysql query / fetch.

Basically, I have the following code ($c2 is my connection variable):
Code: [Select]
$rid = $_GET['id'];
$q = mysql_query("SELECT * FROM reports WHERE id = $rid", $c2) or die(mysql_error());
$report = mysql_fetch_array($q);
$report is used later on to gather more information that is outputted to the user.

However, if in the URL, someone were to put id=1', they would have an error message spit out to them (something along the lines of: 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 '\'' at line 1), indicating a SQL Injection exploit.

How would I go about fixing this, and also preventing SQL Injection?

Thanks a bunch,
Mark

Hello,

So I have a weird error where if I fetch more than a certain number of rows from a mysql table, it triggers a 500 Internal Server Error.

I am using Apache Web Server (through GoDaddy) and the offending code is below:

Code: [Select]
set_time_limit(0);
$this->Connect();
$Output = array();
$search = "SELECT * FROM <table> WHERE user_id = ?";
if($Statement = $this->MySQLi->prepare($search)){
  $Statement->bind_param("i", $UserId);
  $Statement->execute();
  $Statement->bind_result(<result variables>);
  $count = 0;
  while($Statement->fetch() && $count++ < 70){
ChromePhp::log(<result variables>);
  }
  $Statement->close();
}
$this->Disconnect();

ChromePhp::log is a way of dumping things to the Javascript Console in your browser from within a PHP script just as a heads-up. So when I set the stop number as 70, everything is fine. If I try to fetch more than that it triggers a 500 internal server error on Apache Server port 443. I have looked through the error logs and can't figure out the cause but this is almost certainly a server configuration issue? I'd appreciate any feedback, especially anyone familiar with GoDaddy's hosting services

Thanks

I've been using this code for a long time and realised it's very repetitive, but the id_column I want changes all the time


function getRows()
{
$query = mysql_query($sql);
$rows = array();

while($row = mysql_fetch_assoc($query))
{
$rows[$row['id_column']] = $row;
}

return $rows;
}


So I wrote this function that will automatically create an array with a column I choose if I wish, but I'm not sure if it's very efficient.


function getRows($query, $column_id = false)
{
$rows = array();

while($row = mysql_fetch_assoc($result))
{
if($column_id === false)
{
$rows[] = $row;
}
else
{
if(isset($row[$column_id]))
{
$rows[$row[$column_id]] = $row;
}
else
{
$rows[] = $row;
}
}
}

        return $rows;
}


I would appreciate some input as to make it better.
Thanks.

Hey guys tried to search for this but didn't find anything usefull about the issue.

So what i have is mssql_fetch_array in a while loop in the loop i have it assign a specified row as a variable that i can print later on in the page.

Code: [Select]
while($row = mssql_fetch_array($query) {
     $tables = "<tr>";
     $tables .= "<td> {$row['specifiedrow']} </td>";
     $tables .= "</tr>";
}Then i call it in the html table as

Code: [Select]
<? php echo $tables; ?>

I have done this with mysql_fetch_array before and it would print the entire database row associated with that row in the table.

But as it is now it only returns the last row from the database.  Is there something i am missing.

Thanks for any help

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given...


im tryin to put class inside code if $dayNumber and $dan are equal

i tried few ways but all are complicated since i have to call some functions this end up as "simple" solution but i dont know where did i get wrong PS that should be possible?

Code: [Select]
else {
                  echo "<td width='40'";
  $moj_id = $_SESSION['id'];
  $query_event = mysql_query("SELECT * FROM events WHERE id_user='$moj_id' GROUP BY 'event_date'") ;
  $test = mysql_fetch_array('$query_event');
  $date_event = $test['event_date'];
  sscanf($date_event, "%d-%d-%d", $godina, $mjesec, $dan);
  if ($dan==$dayNumber && $mjesec==$month && godina==$year)
  {

  echo " class='radni'";
  }
 
 
  echo"><a href='day_info.php?dan=",$dayNumber,"&mj=",$month,"&gd=",$year,"'>" . $dayNumber . " </a></td>\n";
                  $dayNumber++;                           
              }

Hi,   Does anyone have a clue how I might solve this little issue:   I have a MySQL query, for example:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM staff";
    
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){

    if($row['clock'] < time()) {
    echo "<b>"$row['name']. " - ". $row['age']"</b>";
    echo "<br />";

    } else {

    echo $row['name']. " - ". $row['age'];
    echo "<br />";

    }
}
?>

Taking data from the following table setup:   name - age - clock Timmy Mellowman - 23 - 09:00:00
Sandy Smith - 21 - 12:00:00
Bobby Wallace - 15 - 14:00:00   What im trying to achieve is compare the current time to the time in the clock column and depending if it's earlier or later, change the styling of the results.   The above code does appear to work somewhat however it seems to change the styling of all results in one go, rather than individually when it passes the time in the cell, which is what im looking for.   Thanks

This is really blowing my mind... the code is as follows the table, the column names everything is right and contains information but the variables aren't being filled... I don't get it... Anyone have any ideas or options I might not have thought of for debugging?


                        $item_name = ("SELECT * FROM items WHERE id = '$grab_item'");
$que_items = mysql_query($item_name);
while ($item_todel = mysql_fetch_array($que_items, MYSQL_BOTH)) {
$name = $item_todel['name'];
$desc = $item_todel['desc'];
}
echo ($name . "<br>" . $desc . "<br>" . $grab_item);


the only variable thats set is grab_item, fetch_array throws no errors, if I plug in the query straight to the sql I get all the proper information... It's just not filling the two variables....

Okay, this is getting on my nerves now, my head is throbbing probably just need a break from it all now.

I'm currently getting the following message;

Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\duff3\test3.php on line 25

Can anyone figure out and explain why this isn't working for me, I believe I am calling the function correctly and then putting the result into a while loop.

Code: [Select]
<?php
    function getPageContent($selectedPage)
    {
        $sql =  "SELECT * ";
        $sql .= "FROM  tbl_pages ";
        $sql .= "WHERE tbl_pages.pageCategoryId = ".$selectedPage." ";
        $sql .= "AND active = 1 ";
        $sql .= "LIMIT 1";
        $result = mysql_query($sql) or die ("Error in page sql query:". $sql);
        
        return $pageSet;
        
    }
    
?>




Code: [Select]
<?php require_once ''.$_SERVER['DOCUMENT_ROOT'].'/duff3/commonResources/dbConnection/dbQueryClass.php'; 

?>
<?php
        #FUNCTIONS IS A TEMP FILE UNTIL OO PHP COMES INTO PLAY 
        require_once ("commonResources/includes/functions.php");
        # if page isn't set then set it to default.
        if(isset($_GET["page"]))
        {
            $selectedPage = $_GET["page"];
        }
        else
        {
            $selectedPage = 1; 
        }
        #call function to select all page 
        $pageSet = getPageContent($selectedPage);
?>
<!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>
    <?php
                 while ($row = mysql_fetch_array($pageSet)) 
                { # Start while loop
                    echo $row["pageTitle"]; 
                ?>
    </title>
   
            <link rel="shortcut icon" href="commonResources/images/container/favicon.ico" />
            <link rel="stylesheet" type="text/css" href="<?php $_SERVER["DOCUMENT_ROOT"] ?>/duff3/commonResources/css/style.css" />
   
            <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
           
            <!-- PUT COMMON JAVASCRIPT FILES IN AN INCLUDE 05/05/2011 -->
            <script type="text/javascript" src="commonResources/javaScript/jQuery.js"></script>
            <script type="text/javascript" src="commonResources/javaScript/jQueryTest/menu.js"></script>
        <?php
            require_once ("".$_SERVER["DOCUMENT_ROOT"]."/duff3/commonResources/includes/tinymce.php");
        ?>
   
</head>
<body>
        <div id="viewContainer"><!--OPEN DIV FOR VIEW CONTAINER -->
       
            <div id="headerContent"><!--OPEN DIV FOR HEADER CONTENT -->
           
                <div class="logoContent"><!--OPEN DIV FOR LOGO CONTAINER -->
               
                    <a href="index.html"><img src="<?php  $_SERVER["DOCUMENT_ROOT"] ?>/duff3/commonResources/images/container/logo.png" alt="Hannah Jane Duff" longdesc="Hannah Jane Duff Home Link" /></a>
                   
                </div><!--CLOSE DIV FOR LOGO CONTAINER -->
               
            </div><!--CLOSE DIV FOR HEADER CONTENT -->
           
           
           
           
        <!-- TEMP TAKE OUT AND PUT INTO HEADER AREA -->   
           
           
           
<div id="mainContent"><!--OPEN DIV FOR MAIN CONTENT-->
                <div class="centreContent"><!--OPEN DIV FOR CENTRE CONTENT-->
               
                    <div id="menuContent"><!--OPEN DIV FOR MENU CONTENT-->

                        <div id="menu">
                            <ul class="menu">
                                <li><a href="index.html" class="main"><span>Home</span></a></li>
                                <li><a href="" class="main"><span>bio</span></a>
                                    <div><ul>
                                        <li><a href=""><span>violin</span></a></li>
                                        <li><a href=""><span>piano</span></a></li>
                                        <li><a href=""><span>singing</span></a></li>
                                        <li><a href="" class="parent"><span>teaching</span></a>
                                            <div><ul>
                                                <li><a href="" class="parent"><span>aberdeen</span></a>
                                                    <div><ul>
                                                        <li><a href="#"><span>aberdeen 1</span></a></li>
                                                    </ul></div>
                                                </li>
                                                <li><a href=""  class="parent"><span>bradford</span></a>
                                                    <div><ul>
                                                        <li><a href=""><span>bradford 1</span></a></li>
                                                    </ul></div>
                                                </li>
                                                <li><a href=""  class="parent"><span>leeds</span></a>
                                                    <div><ul>
                                                        <li><a href=""><span>leeds 1</span></a></li>
                                                    </ul></div>                       
                                                </li>
                                              </ul></div>
                                        </li>
                                        <li><a href="" class="parent"><span>influences</span></a>
                                            <div><ul>
                                                <li><a href=""><span>classical</span></a></li>
                                                <li><a href=""><span>folk</span></a></li>
                                             </ul></div>
                                       </li>
                                       <li><a href="" class="parent"><span>other</span></a>
                                            <div><ul>
                                                    <li><a href=""><span>folk&prime;d</span></a></li>
                                                <li><a href=""><span>string quaret</span></a></li>
                                             </ul></div>
                                        </li>               
                                    </ul></div>     
                                </li>
                                <li><a href="" class="main"><span>publicity</span></a>
                                   <div><ul>
                                        <li><a href="" class="parent"><span>news</span></a>
                                            <div><ul>
                                                <li><a href=""><span>may 2011</span></a></li>
                                                <li><a href=""><span>march 2011</span></a></li>
                                            </ul></div>
                                        </li>
                                        <li><a href=""><span>gallery</span></a></li>
                                        <li><a href=""><span>other</span></a></li>
                                   </ul></div>
                                </li>
                                <li><a href="" class="main"><span>recordings</span></a>
                                    <div><ul>
                                        <li><a href=""><span>all</span></a></li>
                                        <li><a href=""><span>new york dolls</span></a></li>
                                        <li><a href=""><span>classical</span></a></li>
                                    </ul></div>       
                                </li>
                                <li><a href="" class="main"><span>contact</span></a></li>
                            </ul></div>     
                    </div><!--CLOSE DIV FOR MENU CONTENT-->
                   
                    <div class="paraBlock"><!--OPEN DIV FOR PARA BLOCK -->
                        <p><?php echo $row["pageContent"]; ?></p>
                    </div><!--CLOSE DIV FOR PARA BLOCK-->
                   
<div class="clearArea"><!--OPEN DIV FOR CLEAR AREA-->
                   
                    </div><!--CLOSE DIV FOR CLEAR AREA-->
                   
                </div><!-- CLOSE DIV FOR CENTRE CONTENT-->
               
            </div><!--CLOSE DIV FOR MAIN CONTENT-->
           
            <div id="footerContent"><!--OPEN DIV FOR FOOTER CONTENT-->
           
                <div class="leftFooter"><!--OPEN DIV FOR LEFT FOOTER-->
               
                    &copy;&nbsp;&nbsp;<?php echo date(Y); ?> All Rights Reserved &nbsp;|&nbsp; Design by <a href="http://www.innovationation.co.uk/">Innovationation UK</a>
                   
                </div><!--CLOSE DIV FOR LEFT FOOTER-->
               
                <div class="rightFooter"><!--OPEN DIV FOR RIGHT FOOTER-->
               
                    <a href="">Copyright | </a>
                    <a href="">Disclaimer | </a>
                    <a href="">Privacy Policy  </a>
                    <a href="">Terms of Use | </a>
                    <a href="">Site Map | </a>
                    <a href="loginArea/login.php">Admin</a>
                   
                </div><!--CLOSE DIV FOR RIGHT FOOTER-->
               
            </div><!--CLOSE DIV FOR FOOTER CONTENT-->
            <?php } ?>
        </div><!--CLOSE DIV FOR VIEW CONTAINER-->
       
</body>
</html>             

I have a problem:   I have some PHP code as show below and every time I add the code at the while loop which starts while($select_stmt->fetch()), I immediately get an error and my page did not display. I downloaded the Zend Studio IDE and at the same line it highlights an error which states "Multiple annotations found at this line. Syntax error unexpected ->, unexpected ')'.   I have no clue how to resolve the error as I am new to PHP programming and the "Fix" option from the compiler offers no suggestions.   See the attached code file       Attached Files  code.txt   357bytes   2 downloads

Hello,

Im trying to display some results from mysql database, however none display.
Can anyone tell me where im going wrong please?

Code: [Select]
 
</head><body>
<div id="listhold">
<div class="list">
<a href="Restaurants.html">Restaurants</a><br />

<?php
mysql_connect("","",""); 
mysql_select_db("") or die("Unable to select database"); 
$result = mysql_query("SELECT name FROM business WHERE type ='restaurant' ORDER BY name");
$number_of_results = mysql_num_rows($result);
$results_counter = 0;
if ($number_of_results != 0) 
{while ($array = mysql_fetch_array($result))
$results_counter++;
if ($results_counter >= $number_of_results);}
?>
</div>

I have a PHP while loop that pulls from an SQL database and displays the contents in a table with two columns.

// Check Connection
    if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

// Select Data Table
    $result = mysqli_query($con,"SELECT * FROM Recommendations") or die(mysqli_error);

// Split Data
    $mid = ceil(mysqli_num_rows($result)/2);

// Display Content
    while ($rows = mysqli_fetch_array($result)) {
        $Name = $rows['Name'];
        $Author = $rows['Author'];
        $Cover = $rows['Link to Cover'];
        $Link = $rows['Link to Profile'];
    echo "<table><tr><td>
    <a href='" . $Link . "' >$Name</a>
    <br />
    $Author
    <br />
    <a href='" . $Link . "' ><img src='" . $Cover . "' /></a>
    </td>
    <td>
    <a href='" . $Link . "' >$Name</a>
    <br />
    $Author
    <br />
    <a href='" . $Link . "' ><img src='" . $Cover . "' /></a>
    </td></tr></table>";
    }
?>

I want to be able to display the looped results side by side in columns of two. Example: 1 2 3 4
5 6   I've tried using pseudo classes to display only the even and odd results in the different table columns, but honestly have no idea how to do this. I'm new to PHP, so my apologies if the results are really obvious. Thanks in advance!

My error happens on line #81

I'm trying to create a list that groups information by username. Only part of it is working. The first query ($get_item_sql) is grouping the information perfectly but the second query ($get_sold) is lumping the $item_price and $item_amount_due as one total for each one and outputting the same amounts into every username. I'm stuck on this and would appreciate your help.

For example:  Username   item fees   image fees item sales  item price  total due
                       Jim                   2               $0.40      $100.00        $3.00     $3.40
                       Kelly                 5               $1.00      $100.00        $3.00     $4.00

This example shows the columns in red as being the problem where Kelly didn't sell anything so her "item sales" and "item price" should be $0.00 but is carrying Jim's totals into hers.

Hope this helps!  Thank you!     

$get_item_sql = mysql_query("SELECT id, username, date, ROUND(price,2) AS price, SUM(item_fee) AS fee, item_fee, SUM(sold) AS sales, SUM(ROUND(price,2)) AS total FROM product WHERE MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username" )
or die(mysql_error());

if (mysql_num_rows($get_item_sql) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_info = mysql_fetch_array($get_item_sql)) {
   $item_username = $item_info['username'];
   $item_date = $item_info['date'];
   $item_price = $item_info['price'];
   
   $item_fee = $item_info['fee'];
   $image_fees = $item_fee * .20;
   $item_sold = $item_info['sales'];
   
  
 $get_sold = mysql_query("SELECT SUM(ROUND(price,2)) AS total, SUM(ROUND(sold,2)) AS sales, date, username FROM product WHERE sold = '1' AND MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username")
or die(mysql_error());

if (mysql_num_rows($get_sold) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_sold2 = mysql_fetch_array($get_sold)) {
   
   
   $item_sales = $item_sold2['total'];
   $item_price = ($item_sold2['total']) * .03;
  
$item_amount_due = $image_fees + $item_price; 

  
  

$content .= "<form action=\"add_artist.php\" method=\"post\"><table class=\"anotherfont\" width=\"670\" border=\"0\">

<tr><td width=\"201\">{$item_username}</td>
                    <td width=\"109\">{$item_fee}</td>
<td width=\"109\">{$image_fees}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_sales}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_price}</td>
<td width=\"109\"><input name=\"balance_due\" type=\"text\" value=\"{$item_amount_due}\" /></td>
</tr><br /></table></form>"; 

   }
  }
  }
  }