PHP - Problems With Fetch Array

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

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

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 users online section and i am using an aray and implode so the comma is displayed on every username but the last, but it displays the same usernames several times. This could be due to the switch i am using to define user group. Heres the code:

$online_query = $db->query("SELECT user_id, user_group, user_username
                            FROM ".DB_PREFIX."sessions");
while ($online_info = mysql_fetch_object($online_query)) {

switch($online_info->user_group)
        {
            case 1:
                $userClass = 'admin';
                break;
            case 2:
                $userClass = 'mod';
                break;
            case 3:
            case 0:
            default:
                $userClass = 'user';
                break;
        }

$users2[] = "<span class=\"{$userClass}\">{$online_info->user_username}</span>"; 

echo '<p>' . implode(', ', $users2) . '</p>';
}

is there something i am doing wrong?

Hello,   Can anyone tell me what I'm doing wrong here?  I am trying to run a query against a table for scenes from movies.  Each movie would have up to 8 scenes.  For the life of me I can't get this loop to work.  The movie id is being passed in the url, tested to make sure it's being passed and it is.  The code is pasted below. 

require_once ('../mysqli_connect.php');

$movie_id = $_GET['movie_id'];

$q = "SELECT * FROM scenes WHERE movie_id = $movie_id";

$r = @mysqli_fetch_array($dbc, $q);

$row = @mysqli_fetch_array($r, MYSQLI_ASSOC);

while ($row = @mysqli_fetch_array($r, MYSQLI_ASSOC));{
 
echo '<a href=" '.$row['scene_id'].'.mp4 ">'.$row['scene_name'].'</a>';}

In advance thanks a million!!
Edited by Zane, 28 May 2014 - 10:01 AM.

I am trying my hand at using an array i have never done it before, and I am having some problems getting it work work. if someone could point me in the right direction?

Thanks



<?php

$active_keys = array();
foreach($_GET['img'] as $key => $filename)
{
    if(!empty($filename))
    {
        $active_keys[] = $key;
    }
}



?>

Hi All,   I'm new to PHP (not to coding) - and I've been able to bang out most answers using books, the web and brue force - but this one has me stumped. (If it's been covered before, sorry, I'm being lazy for not searching)...   So, here's the problem:   I have a call to my internal system that returns XML data via a SOAP call. The call works great - data is returned as I would expect.   Like I've read, I put said data into a variable usng simpleXML like this: $xml = simplexml_load_string($response3); ($response3 being where the raw data is)   When I do a var_dump of $xml, I get this:   SimpleXMLElement Object
(
    [ICProductAvailByWhseResult] => SimpleXMLElement Object
        (
            [errorMessage] => SimpleXMLElement Object
                (
                )

            [arrayAvailability] => SimpleXMLElement Object
                (
                    [ICProductAvailByWhse.output.Availability] => Array
                        (
                            [0] => SimpleXMLElement Object
                                (
                                    [productCode] => xxx       
                                    [description1] => yyy          
                                    [description2] => zzz
                                    [warehouse] => aaa
                                    [netAvailable] => bbb
                                )

                            [1] => SimpleXMLElement Object
                                (
                                    [productCode] => xxx
                                    [description1] => yyy          
                                    [description2] => zzz
                                    [warehouse] => aaa
                                    [netAvailable] => bbb
                                )

                            [2] => SimpleXMLElement Object
                                (
                                    [productCode] => xxx
                                    [description1] => yyy          
                                    [description2] => zzz
                                    [warehouse] => aaa
                                    [netAvailable] => bbb
                                )
  **** Edited, I got real data, not xxx,yyy, etc... ****   Now the issue:  It seems like I have everything in place - all I need now is to get my data off to variables for display. I've tried everything I can think of and I just can't seem to get it.   I ran $xml->getName() and it gave me: ICProductAvailByWhseResult   So, simple I think, I should be able to print something like $xml->ICProductAvailByWhseResult[0]->warehouse and I should get something, right? Nope.   So I try $xml->ICProductAvailByWhseResult[1]->warehouse and I get a notice that I'm trying to get to a property of a non-object.   What am I missing?  I come from a VB backgound, so I understand array's and such - but this one has be stumped.   And help would be greatly appreciated...   Thanks!!  

I'd like some help debuging my code, I can't seem to figure out why it isn't creating the variables... Here it is:


<?php
$template_settings = array(
"index"=>"index.php",
"announcements"=>"announcements.php"
);

extract($template_settings, EXTR_PREFIX_ALL, "template_");
echo $template_index;
?>


No matter what I do $template_index still equals null and I'm wondering what I'm doing wrong. There are no errors of anykind.

Problem: my checkbox array chkBrand[] is not saving data when I click the save button called cmdSave. Each checkbox specifies a brand connected to a model number. Multiple brands can be connected to each model number. (Don't ask, it's what the customer wants.)

So, if I check the checkbox in row 0 and row 3, only row 0 shows up. If I check the boxes in row 0, 1, 5, only rows 0, 1 show up in chkBrand and $newchkbrandarr.

First, my routine to see which button is checked is at the top of the php file. Here it is.

else if (isset($_POST['cmdSave'])) //Try to save items first.
    {
$newchkbrandarr=$_POST['chkBrand']; //Checkbox for each brand.
$oldchkbrandarr=$_SESSION['oldchkbrandarr'];
$olddata=$_SESSION['olddata']; //Non-brand Fields strung together.
$brandlist=$_SESSION['brandlist']; //List of brands displayed.

crPrintarr('chkBrand raw',$_POST['chkBrand']); //DEBUG. Prints array to screen.
//===At this point chkBrand[] contains: 1

//Turn nulls in checkboxes to zeros.
$cnt=count($newchkbrandarr);
for ($j=0; $j<$cnt; $j++)
{
$newchkbrandarr[$j]=$newchkbrandarr[$j]+0;
} //for j

//Make sure that at least one brand is checked.
$cnt=count($newchkbrandarr);
crPrintarr('newchkbrandarr',$newchkbrandarr); //DEBUG
//===At this point, $newchkbrandarr contains: 1, 0

$s='Elements in newchkbrandarr cnt='.$cnt;
$s.=', count brandlist='.count($brandlist);
crDebug($s); //DEBUG
$cnt2=0;
$cnt=count($newchkbrandarr); //Find number of elements.
for ($j=0; $j<$cnt; $j++)
{
$cnt2=$cnt2+$newchkbrandarr[$j]+0;
//$s='arrpos '.$j.': newchkbrandarr='.($newchkbrandarr[$j]+0).', cnt2='.$cnt2;
//crDebug($s); //DEBUG
} # for j


Here is my code to construct the array of checkboxes, one per table row. Each checkbox has its array position explicitly defined as $x. $x starts at zero, and is incremented by 1 for each table row (each check box).


    $x=0;
    while ($row = mysqli_fetch_array($result)) 
     {
$br=trim($row['brand']); //Brand name to display
$brandvar=$br;
$brandlist[]=$br; //Save every found brand for later.
//First find if brand is checked on table "brands". 
        $query2 = "SELECT brand ".
        "FROM brands ".
        "WHERE ".
        "(partid=".$partidvar.") ".
        "AND (brand='".$br."') ".
        "ORDER BY brand ".
        ";";
        $cntchk=crqryCount($query2,false); //If $cntchk>0 then brand is checked.
        //$s="Is brand stored already? <br/>$query2";
        //crDebug($s); //DEBUG
        
        $query2 = "SELECT brand ".
        "FROM zzbrands ".
        "WHERE (brand='".$br."') ".
        "AND (prodnameoverride=1) ".
        "ORDER BY brand ".
        ";";
$override=crqryCount($query2,false); //Can this brand override product name?

$s="\n";
     $s.='<tr><td>'.
         '<input type="text" value="'.$br.'" id="txtBrand[]" name="txtBrand[]" '.
         'size="20" readonly class="mydisabled" />';
     $s.='<td align="center">';
     $s.='<input type="checkbox" name="chkBrand['.$x.']" '.
         'id="chkBrand['.$x.']" value="1" ';
     if ($cntchk>0)
     {
     $s.='checked="checked" ';
     $oldchkbrandarr[$x]=1;
     }
     else {
     $oldchkbrandarr[$x]=0;
     }
     $s.='/>';


Any ideas what I might be missing?

I have a db table with 1500 street names inside - id, tfare, ptown, pcode, area.

The 'area' column is specific to the company i work for and each street belongs to an 'area' number defined by the company.

Currently each area is '0' - unassigned. The company areas are numbered 1 - 18. I need to list each street (LIMIT 10 at a time), and have an input box for the area to be edited and saved.

The following code works perfectly well when dealing with 1 record at a time (LIMIT 0, 1), but breaks when i change the LIMIT to 10.

I'm trying to show the dinosaur management that we need to upgrade our paper, yes, paper system to computers. I'm a transport manager, but in my spare time since 2004 I'm fluent in HTML and CSS, but only in the last few months really decided to give PHP and MySQL a *real* go.

I'm 'guessing' I need to look into arrays for this to work? I've tried searching about but I dont even know how to articulate what i need to search for, so I have to publicly ask for help via this long winded post, sorry

Here is my code:



<?php

include($_SERVER['DOCUMENT_ROOT'].'/!SYSTEM/bootstrap.php');

if(isset($_POST['savearea']))
{
    $id = $_POST['hideID'];
    $area = $_POST['area'];
   
    $sql = "UPDATE bmth_streetindex SET area='$area' WHERE id='$id'";
   
    if ($query = mysql_query($sql)or die(mysql_error()))
        {
         print "saved ???";
        }
}

    // grab data from bmth street index where the area is = 0 (which means its area is un-assigned)
    $sql = "SELECT * FROM bmth_streetindex WHERE area='0' LIMIT 0, 10";
    $rs = mysql_query($sql) or die(mysql_error());


print $HTML::form('action="" name="inputAreaForm" method="POST"')."\n\n";
   
    // 'while' thru and print them 1 at a time
    while($row = mysql_fetch_array($rs))
    {
        $id = $row['id'];
        $tfare = $row['tfare'];
        $ptown = $row['ptown'];
        $pcode = $row['pcode'];
        $area = $row['area'];
        $urlQ = $tfare. ", " .$ptown. ', ' .$pcode;
       
        print "<div>\n";
       
            print "\n<input type=\"hidden\" name=\"hideID\" value=\"$id\">";
           
            print "\n[$id] $tfare, $ptown, $pcode &nbsp;&nbsp;&nbsp;";
            print "\nArea <input type=\"text\" name=\"area\" value=\"$area\" />";
            print "\n<input type=\"submit\" name=\"savearea\" value=\"Save Area\">";
           
            print "\n<a href=\"http://www.google.com/maps?q=$urlQ&hl=en&ie=UTF8&z=17\" target=new>SHOW ON MAP</a>";
           
        print "\n<>\n<hr>\n\n";
    }

print $HTML::endForm();


?>




Thank you for taking the tie to read this, I hope someone can point me in the right direction for what i need to look into making this work

The code here is suppose to allow the user to match up a word ($word) with a list of definitions ($word_defs).  I can't get the list of definitions to stick.  When the user does make a guess it shows that he is always correct.  How can i fix these problems?

 Outside entry code:
Code: [Select]
<?php
require_once "include/session.php";
require_once "include/word_defs.php";
 
$word = array_keys($word_defs); 
$word_defs = array_unique(array_values($word_defs));

$params = (object) $_REQUEST;
$session = new Session();
 
if (isset($params->guess)) {
  $word = $params->word;
  if ( $params->word == $word_defs[$term] ) {
    $response = "correct"; 
  } else {
    $response = "incorrect"; 
  }
  $choices->word_def[$params->word_def] = "selected";
} else {
  $word = $word[ rand( 0, count($word)-1 ) ];
}
?>

Body code:

Code: [Select]
word: <?php echo $word ?>


<form action="?" method="get">
definition:
<select name="word_defs">
<?php foreach ($word_defs as $word_def): ?>
<option <?php echo $choices->word_def[$word_def] ?> ><?php echo $word_def?></option>
<?php endforeach ?>
</select>
 
<input type="submit" name="guess" value="Guess" />
 
<input type="hidden" name="word" value="<?php echo $word?>" />
</form>

<h3><?php echo $response ?></h3>

I have a text field in my database that I'm pulling the contents of and parsing into an array, at which point depending on the users action I'm either adding to the end or searching for a specific value and removing it.  I'm then converting the array back to a string and placing it back into the text field in the database.

Everything works fine except for either an empty array value or a new line forcing its way to the front. Causing, naturally an empty value loaded onto the page that displays this part of the db.

While I know theres a couple things in there that aren't necessary I was just too lazy to take them out before posting after attempting to find a way around this problem. But here is the bulk of the code.  I appreciate any help!

$to_add = "SELECT * FROM teams WHERE name = '$teamname'";
$que_to_add = mysql_query($to_add);
while ($fetch_members = mysql_fetch_array($que_to_add, MYSQL_BOTH)) {
$members = explode("\n", $fetch_members['members']);
$members = array_filter($members);
foreach ($members as $key => $value) {
$value = trim($value);
$new_insert[] = $value;
}
}
$new_insert = array_filter($new_insert);
foreach ($new_insert as $key => $value) {
if ($value != "") {
$to_insert = ($to_insert . "\n" . $value);
}
}
$to_insert = ($to_insert . "\n" . $for_insert);
$insert_ready = "UPDATE teams SET members = '$to_insert' WHERE name = '$teamname'";
$insert = mysql_query($insert_ready);