PHP - Mysql Query To Generate Array, Sort By Field

when i run the below code i get an error... Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in... but when i take out the h>0 then there is no errors in the code. in table users, i need all columns in the array. How to get h>0 working?

$query = "SELECT * FROM users WHERE h>0 ORDER BY id";
$result = mysqli_query($link, $query);

$data = array();
while($row1 = mysqli_fetch_array($result))
{
	$data[] = $row1;
} 

print_r($data);

Edited by kalster, 27 October 2014 - 07:38 PM.

I have tried many ways of storing an array of data that comes from a multiple selection form into a mysql table, including serialization.  I am currently trying to do it by forming a string, and using the string in the insert query, but keep getting errors, or just nothing happening.  I am not sure what I am doing wrong. 

Code: [Select]
$categoryString = array();

if ($categoryArray){
foreach ($categoryArray as $category){
$categoryString[] =  $category.'<br />';}
}
 $categoryquery= "INSERT INTO categoryname VALUES('$categoryString')";

mysql_query($categoryquery);
Thank you for your time as always.

Hello Guys,

I have a question

I have the following query


$result3 = mysql_query("SELECT * FROM table1 WHERE ad_id='$id2'")
or die(mysql_error());  


$row3 = mysql_fetch_array( $result3 );

// Grab all the var
$features = $row3['features'];


I am turning it into an array (comma separated)


$feature2 = explode(",", $features);
print_r($feature2);
)

The result is like so


Array ( [0] => 5 [1] => 9 [2] => 13




I want to query the features for just the ids (F_name) are for the features . This query will show all.. I would like to just display the f_name values from the array query.


// build and execute the query
$sql = "SELECT * FROM features";
$result = mysql_query($sql);
 
// iterate through the results
while ($row = mysql_fetch_array($result))
{
  echo $row['f_name'];
  echo "<br />";
}



Please Advise..

Thanks, Dan

Hi all,

I have the following code that queries a MySQL database and outputs results on-screen.

Code: [Select]
$result= mysql_query
        ("
        SELECT email,firstname,lastname FROM tablename WHERE ID IN('".$IDs."')
        ");
        if (!$result) {die('Error: Could not search database. ' );}
   
        while($row = mysql_fetch_assoc($result))
        {
            echo $row['firstname'],"&nbsp;",$row['lastname'],"<br />";
            $emails[]=$row['email'];
        }
        var_dump($emails); var_dump($IDs);

However, the two var_dump's output the following (in the case of 2 results for the query):

array(6) { => string(14) "email1@email.com" [1]=> string(23) "email2@email.com" [2]=> string(14) "email1@email.com" [3]=> string(23) "email2@email.com" [4]=> string(14) "email1@email.com" [5]=> string(23) "email2@email.com" } string(67) "9543219aa68ffa1d434dc8530f23fe48','d4384b2b493867706b0bcedda012ed48"

($IDs is an imploded array)

Even though the MySQL table only contains one email per ID, both emails are listed 3 times in $emails, instead of just once. Can anyone see why this is? I'm stuck.

Thanks!

I have these two tables... schedule (gameid, homeid, awayid, weekno, seasonno) teams (teamid, location, nickname) This mysql query below gets me schedule info for ALL 32 teams in an array...

$sql = "SELECT
h.nickname AS home,
a.nickname AS away,
h.teamid AS homeid,
a.teamid AS awayid,
s.weekno
FROM schedule s
INNER JOIN teams h ON s.homeid = h.teamid
LEFT JOIN teams a ON s.awayid = a.teamid
WHERE s.seasonno =2014";
$schedule= mysqli_query($connection, $sql);
if (!$schedule) {
die("Database query failed: " . mysqli_error($connection));
} else { 
// Placeholder for data
$data = array();
while($row = mysqli_fetch_assoc($schedule)) {
if ($row['away'] == "") {$row['away']="BYE";}
$data[$row['homeid']][$row['weekno']] = $row['away'];
$data[$row['awayid']][$row['weekno']] = '@ '.$row['home'];
}
}

However, I only want to get info for one specific team, which is stored in the $teamid variable. This should be very easy, right? I have tried multiple things, including this one below (where I added an AND statement of "AND (h.teamid=$teamid OR a.teamid=$teamid)"), but this one still outputs too much...

$sql = "SELECT
h.nickname AS home,
a.nickname AS away,
h.teamid AS homeid,
a.teamid AS awayid,
s.weekno
FROM schedule s
INNER JOIN teams h ON s.homeid = h.teamid
LEFT JOIN teams a ON s.awayid = a.teamid
WHERE s.seasonno =2014
AND (h.teamid=$teamid OR a.teamid=$teamid)";
$schedule= mysqli_query($connection, $sql);
if (!$schedule) {
die("Database query failed: " . mysqli_error($connection));
} else { 
// Placeholder for data
$data = array();
while($row = mysqli_fetch_assoc($schedule)) {
if ($row['away'] == "") {$row['away']="BYE";}
$data[$row['homeid']][$row['weekno']] = $row['away'];
$data[$row['awayid']][$row['weekno']] = '@ '.$row['home'];
}
}

Below is the array that the above outputs. In a nutshell, all I want is that 1st array ([1]) which has, in this example, the Eagles full schedule. It's not giving me too much else and I guess I could live with it and just ignore the other stuff, but I'd rather be as efficient as possible and only get what I need...

Array
(
[1] => Array
(
[1] => Jaguars
[2] => @ Colts
[3] => Redskins
[4] => @ 49ers
[5] => Rams
[6] => Giants
[7] => BYE
[8] => @ Cardinals
[9] => @ Texans
[10] => Panthers
[11] => @ Packers
[12] => Titans
[13] => @ Cowboys
[14] => Seahawks
[15] => Cowboys
[16] => @ Redskins
[17] => @ Giants
)

[27] => Array
(
[1] => @ Eagles
)

[28] => Array
(
[2] => Eagles
)

[4] => Array
(
[3] => @ Eagles
[16] => Eagles
)

[14] => Array
(
[4] => Eagles
)

[15] => Array
(
[5] => @ Eagles
)

[3] => Array
(
[6] => @ Eagles
[17] => Eagles
)

[] => Array
(
[7] => @ Eagles
)

[16] => Array
(
[8] => Eagles
)

[25] => Array
(
[9] => Eagles
)

[11] => Array
(
[10] => @ Eagles
)

[7] => Array
(
[11] => Eagles
)

[26] => Array
(
[12] => @ Eagles
)

[2] => Array
(
[13] => Eagles
[15] => @ Eagles
)

[13] => Array
(
[14] => @ Eagles
)

)

Hi All,

First time posting here. I've googled the problem, but can't seem to find a response that's the same.

All I want to do is have a list of id numbers and for each id number in the array, submit a MySQL query to retrieve information relating to the id number.

When I execute the code below however, I end up with only the last item in the array being printed in the echo statement.

Any clues?

Thanks,

Code: [Select]
// get array of ids
$ids = getIDs($ids);

// loop through input list
foreach ($ids as &$id) {
getVarDetails($id);
}

function getVarDetails($local)
{
$con = mysql_connect('localhost:3306', 'root', '********');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

// set database as Ensembl
mysql_select_db("Ensembl", $con);

$result = mysql_query("SELECT * FROM variations WHERE name = '$local' LIMIT 1");
$row = mysql_fetch_array($result)

while($row = mysql_fetch_array($result))
{
echo $row['name'] . " " . $row['id'];
echo "<br />";
}

// close connection
mysql_close($con);
}

Hi all   Going to try and explain this as best as I can.   I currently have a query that sorts a list of records by number of points, then wins, 2nd places, 3rd places etc, the query is as follows  

SELECT  COUNT( `points` ) AS `rides`, SUM( `points` ) AS `pts`, SUM(IF(`points`=3,1,0)) AS `wins`, SUM(IF(`points`=2,1,0)) AS `2`,
SUM(IF(`points`=1,1,0)) AS `1`, SUM(IF(`points`=0,1,0)) AS `0`,  rider_name
FROM tbl_heat
WHERE card_id = 38
GROUP BY `rider_name` 
ORDER BY pts DESC, wins desc, `2` desc, `1` desc, `0` desc
LIMIT 8

  this query has resulted in this result   '5','15','5','0','0','0','Jaroslaw Hampel'

$bl = array(); 
$link1 = array_rand($cds); 
$link2 = array_rand($cds); 
$link3 = array_rand($cds); 
$link4 = array_rand($cds); 
$A = 0;
while (!in_array($link1, $bl)){
$link1 = array_rand($cds);
$bl[$A] = $link1;
$A++;
}
while (!in_array($link2, $bl)){
$link2 = array_rand($cds);
$bl[$A] = $link2;
$A++;
}
while (!in_array($link3, $bl)){
$link3 = array_rand($cds);
$bl[$A] = $link3;
$A++;
}
while (!in_array($link4, $cds)){
$link4 = array_rand($cds);
$bl[$A] = $link4;
$A++;
}
echo $link1;
echo $link2;
echo $link3;
echo $link4;

Pretty much I'm trying to generate 4 number's between the min and max of an array but I don't want any duplicates. So it checks if the number exists in a bl array if it does it generates another number, well thats the theory. Doesn't work like that though.

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

How should it look if I want to make a query where a field value should be lower than another field?

Code: [Select]
....WHERE total_points<max_points");

Code: [Select]
$new_array2=array_diff($my_array,$itemIds);

$updatedb = mysql_query("UPDATE content_type_ads SET field_expire_value = '666' WHERE $new_array2 = field_item_id_value");
"$new_array2" has only 12 digit numbers for each item in the array, and I want to match them to the "field_item_id_value" field in the table, updating the "field_expire_value" field for the record where they match.  I know I am close because the UPDATE code works before I add the WHERE statement (it of course adds '666' to EVERY field, but for a noobie it's a start!).

Here is how I get categories for article listing. Article can be written in several categories at once. So I have this code:


Code: [Select]
$category = '1,5,23,46'; //Category IDs

$get_cats = explode("," , $category);
$cats = "";

for ($i = 0; $i<count($get_cats); $i++ ) {
$cat  = trim($get_cats[$i]);
$catSlug = get_value_of($cat, "inc/cat_ids.php");
$catName = str_replace("-"," ",$catSlug);
$cats .= "<a href=\"index.php?category=$catSlug\">".strtoupper($catName)."</a>, ";
}
$cats = substr($cats,0,-2);

As you can see there's get_value_of function that is used to read the category from the file. File is cat_ids.php and looks like this:
Quote

1='category-name-1';
2='category-name-2';
3='category name-3';
4='category-name-4';
5='category-name-5';
etc.



I want to improve this in order not to read the file at each step ("for" loop).
Means, one can load the file and then generate a list of (links) category compared to the numbers (Ids).
So if $category is "1,3,4" I want to get list like this (by reading cat_ids.php):
category-name-1, category name-3, category-name-4

With current function I read value for every ID from file in every step. So if article have 10 or more categories script load file 10 or more times. Looking for a solution to do this from a reading file only once.


Thanks.

Hi guys,

I'm trying to sort an array. The array has information about listings. ID, name, info etc.

An unrelated set of data also contains the listing ID's and I have made a function to sort this array and show an new order for the ID's. I now need to sort the original array by this new ID order...

This snippet shows that the original listings array can be sorted by link_id:
sort($this->links, $this->link->link_id); //This works. It sorts links by link ID!

In a foeach loop I have created this:
$sleeps_array[] = array("ID" => $link->link_id, "Sleeps" => $sleeps); // Makes an array of arrays of a custom field with listing ID.

It makes this:
array ( 0 => array ( 'ID' => '9', 'Sleeps' => '2', ), 1 => array ( 'ID' => '3', 'Sleeps' => '4', ), 2 => array ( 'ID' => '6', 'Sleeps' => '6', ), )

I can then sort this array of arrays with this function:

function compare_sleeps($a, $b){
return strnatcmp($a['Sleeps'], $b['Sleeps']);
} # sort alphabetically by name
usort($sleeps_array, 'compare_sleeps');

It then gives me a sorted array according to "Sleeps" (as in, the number of people a property can cater for). It has the correct order of ID to then output but how do I organise the original array by ID with this new array?

Sounds complicated, I hope you got that!

Cheers, RJP1

Is there a way to use sort($Array) on numbers but reverse it. So instead of 1 to 3 itll do 3 to 1 ? AKA descending order?

Can't find a function that would do unless theres a second sort function ?

Thanks