error messages from index.php or results.php?

bufhal

Hello;
can anyone help me out and show me how to get rid of these errors:

Warning: array_unique(): The argument should be an array in /home/www/immunizewny.org/index5.php on line 132
Warning: array_unique(): The argument should be an array in /home/www/immunizewny.org/index5.php on line 134
Warning: sort() expects parameter 1 to be array, boolean given in /home/www/immunizewny.org/index5.php on line 136
Warning: sort() expects parameter 1 to be array, boolean given in /home/www/immunizewny.org/index5.php on line 138
Warning: Invalid argument supplied for foreach() in /home/www/immunizewny.org/index5.php on line 156
Warning: Invalid argument supplied for foreach() in /home/www/immunizewny.org/index5.php on line 165

Here is index.php-thanks for any help.

<?php 
// Connection to the db server and select active db 
$SQLlink = @mysql_connect("13.com", "nyaic", "jn"); //creates a connection
if (!$SQLlink) 
  Die("Couldn't connect to the db server."); // display error message on error 
if (!mysql_select_db("nyaic", $SQLlink))
  Die("Couldn't access database.");          // display error message on error 
// perform query 
$data   = mysql_query("SELECT date, agency, city FROM agencies");
if (!$data) 
  Die(mysql_error());                        // display MySQL error message on error 
$agencies = Array(); 
while($row = mysql_fetch_array($data)) {     // assign results into arrays 
  $dates[]    = $row["date"]; 
  $agencies[] = $row["agency"]; 
  $cities[]   = $row["city"];
} 

$dates = Array_Unique($dates);               // remove duplicate values 
$agencies = Array_Unique($agencies); 
$cities = Array_Unique($cities); 

Sort($dates);                                // sort arrays 
Sort($agencies); 
Sort($cities); 

$date_out   = "<select name='date'   onchange=\"window.open('results.php?action=date&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 
$agency_out = "<select name='agency' onchange=\"window.open('results.php?action=agency&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 
$city_out   = "<select name='city'   onchange=\"window.open('results.php?action=city&value='+this.value, 'agencyWin', 'location=yes,left=20,top=20');\">"; 

$date_out   .= "<option>-- select date ---</option>";

$agency_out .= "<option>-- select agency ---</option>";

$city_out   .= "<option>-- select city ---</option>"; 

forEach ($dates as $value) 
  $date_out   .= "<option value='$value'>$value</option>"; 

forEach ($agencies as $value) 
  $agency_out .= "<option value='$value'>$value</option>"; 

forEach ($cities as $value) 
  $city_out   .= "<option value='$value'>$value</option>"; 

$date_out   .= "</select>\n";
$agency_out .= "</select>\n";
$city_out   .= "</select>\n"; 
echo $date_out.""; 
echo $agency_out.""; 
echo $city_out."<BR>";

?>

The_Chancer

The only array it isn't halting on is $agencies which you specified as an array(), have you tried this with the rest as well ?

But saying that $dates[]=$foo; should set it as such anyway....

Unsure if there is only one record if it would associate it as an array, or leave it as a normal variable though - try using the $foo=array(); as you have for agencies for dates and cities.,...

Either that or print_r($foo); for each of the dates and cities.. see what that gives you.

bufhal

Hi Chancer;
I am very new to this
can you edit the file to show what you mean?
I am uncertain how to proceed to get rid of the errors. The dropdowns will be populated with multiple records and a user's click on an entry will bring results.php. If you need that file, I can post it as well..
Thank you😕

bufhal

I added the two other arrays for cities and dates an it got rid of the errors.
Thank you very much!
While I have you on the phone, Chancer, can you offer your keen insight on one more issue?
I am using phpmyadmin to upload a text file to a MySql database(that populates the dropdowns). I have tried Excel CVS files and they do not work. The text file is comma-delimited with a semi-colon ending the rows. I leave the first column blank for auto-increment and everything uploads to phpmyadmin ok-even the id is auto-incremented. However, the information does not show in my results.php. But when I "insert" on record at a time manually, it shows.
Any ideas?
I know that was a mouthfull but any advice is apprecited...
bufhal

The_Chancer

OK - glad the array worked...

The trick about this is try everything - and you'll learn very quickly. The more mistakes you make and correct yourself - the more you learn and it sticks in your head...

As for uploading the CSV, if it appears in the PHPMyAdmin - then it is in your table... no questions asked...

Try this snippet:

$query=mysql_query("SELECT * FROM `table` ");
while($e=mysql_fetch_assoc($query))
{
     print_r($e);
     echo "<br />Next record:<br />";
}

This will echo out each part of each row within the database.

All you have to do is replace table with your actual table name.

bufhal

Hi, thanks..
I tried to put your code within mine and no matter where I put it, I am getting errors. Should I substitute your code for a couple of lines in mine?

bufhal

Could not get the snippet to work Could it have something to do with the results.php webpage? Something is not jibbing...

The_Chancer

The snippet should be used wherever you want. As long as you have the DB connection info before it.

When you say it doesn't work... what are the errors it produces ?

bufhal

Here is the error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/immunizewny.org/index5_test.php on line 115

Still getting "No Results" from the querys.
Here is the results.php code--perhaps it is something wrong here and that is why I cannot get results from the DB

<?php 
if (!IsSet($action) || !IsSet($value))       // check if both vars are set 
  Die("Both vars must be set"); 

if (Trim($value) == "")                      // check if value is non-blank 
  Die("Value can't be left blank"); 

if ($action != "date" && $action != "agency" && $action != "city") 
  Die("Unknown action requested"); 

// Connection to the db server and select active db 
$SQLlink = @mysql_connect("supr", "buf", ""); //creates a connection

if (!$SQLlink) 
  Die("Couldn't connect to the db server."); // display error message on error 

if (!mysql_select_db("buf", $SQLlink))
  Die("Couldn't access database.");          // display error message on error 

// escape data from user 
if (ini_get('magic_quotes_gpc')) {           // unescaping data if needed 
  $value = StripSlashes($value); 
} 
$value = mysql_escape_string($value);        // escaping data for MySQL db 


$data  = mysql_query("SELECT * FROM agencies WHERE $action = '$value'"); // perform a query

if (!$data) 
  Die(mysql_error());                        // display MySQL error message on error 

$agencies = Array(); 

while($row = mysql_fetch_array($data)) { 
  $agencies[] = $row; 
} 

$output = "<table border=1>\n"; 
if (mysql_num_rows($data) == 0) {            // in the case of no results found - display alert message 
  $output .= "<tr><td colspan=4>No results found</td></tr>"; 

} else {
    $output .= "<tr>";
    $output .= "<td align=\"center\"><b>Date</b></td>";
    $output .= "<td align=\"center\"><b>Agency</b></td>";
    $output .= "<td align=\"center\"><b>City</b></td>";
    $output .= "<td align=\"center\"><b>Time</b></td>";
    $output .= "<td align=\"center\"><b>Day</b></td>";
    $output .= "<td align=\"center\"><b>Location</b></td>";
    $output .= "<td align=\"center\"><b>Building or Room</b></td>";
    $output .= "<td align=\"center\"><b>Street</b></td>";
    $output .= "<td align=\"center\"><b>Zip</b></td>";
    $output .= "<td align=\"center\"><b>Phone</b></td>";
    $output .= "<td align=\"center\"><b>Contact</b></td>";
    $output .= "</tr>";
  forEach ($agencies as $agency) {           // display row for each result (eg. you can have more agencies in one town) 

$output .= "<tr>";
$output .= "<td align=\"center\">".$agency["date"]."</td>";
$output .= "<td align=\"center\">".$agency["agency"]."</td>";
$output .= "<td align=\"center\">".$agency["city"]."</td>";
$output .= "<td align=\"center\">".$agency["time"]."</td>";
$output .= "<td align=\"center\">".$agency["day"]."</td>";
$output .= "<td align=\"center\">".$agency["location"]."</td>";
$output .= "<td align=\"center\">".$agency["building_room"]."</td>";
$output .= "<td align=\"center\">".$agency["street"]."</td>";
$output .= "<td align=\"center\">".$agency["zip"]."</td>";
$output .= "<td align=\"center\">".$agency["phone"]."</td>";
$output .= "<td align=\"center\">".$agency["contact"]."</td>";

$output .= "</tr>\n"; 
  } 
} 

$output .= "</table>\n"; 

echo $output; 

?>