PHP - Select From Db Where Value!=$array

I have a Prepared Statement that runs a SELECT statement and returns 2 records, and I would like to store the Field Value for each Record into an Array.

Here is the code I usually use for queries that return just a single value...

// ******************
// Populate Form. *
// ******************

// Build query.
$q2 = "SELECT response
FROM bio_answer
WHERE member_id=?";

// Prepare statement.
$stmt2 = mysqli_prepare($dbc, $q2);

// Bind variable to query.
mysqli_stmt_bind_param($stmt2, 'i', $memberID);

// Execute query.
mysqli_stmt_execute($stmt2);

// Store results.
mysqli_stmt_store_result($stmt2);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt2)>0){
// Details Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt2, $response);

// Fetch record.
mysqli_stmt_fetch($stmt2);

// Close prepared statement.
mysqli_stmt_close($stmt2);

}else{
// Details Not Found.
$_SESSION['resultsCode'] = 'DETAILS_NOT_FOUND_2133';

// Close prepared statement.
mysqli_stmt_close($stmt2);

// Set Error Source.
$_SESSION['errorPage'] = $_SERVER['SCRIPT_NAME'];

// Redirect to Display Outcome.
header("Location: " . BASE_URL . "/members/results.php");

// End script.
exit();
}//End of POPULATE FORM



Can someone help me out with the syntax so that I get an end result like this...

$answerArray[0] = 'I want to be my own boss!!'
$answerArray[1] = 'Don't waste your time trying to do your own Taxes!'


Thanks,


Debbie

hello, have a question.  im trying to do a select * where id exists in array $id8

here is my array

Code: [Select]
$result8 = mysql_query("SELECT * FROM customers WHERE whosclient = 'Lansoft'");
while($row8 = mysql_fetch_array($result8))
{
$id8=$row8['id'];
}
here is my select code.  it is only returning results for the highest number in the array

Code: [Select]
$result = mysql_query("SELECT * FROM timesheets WHERE status = 3 AND billable = 1 AND client = '$id8' ORDER BY date, starttime");
while($row = mysql_fetch_array($result))
{
Thanks for any help!

Hi

I need to do a SELECT query like

$query = "SELECT name FROM myusers WHERE myidnum = ".$_SESSION['myid'].""; 

and put the results into an array like

$myusers = array("David","John","Lucy","Sarah");

But I cannot figure out how to do this

Can anyone help?

Thanks

Hi

I am trying to have the following as an example:

Code: [Select]
<select name="test[]" multiple="multiple">options here</select>
<select name="test[]" multiple="multiple">options here</select>

Then using $_POST['test'] to grab the boxes in the array. I want to then loop over each box so for example:

Code: [Select]
$boxes = $_POST['test'];

foreach ( $boxes as $box )

    // now here i would of expected $box to be an array of the options,
}

but it's not working like this, all the options from all submitted select boxes come in one array so I cannot distinguish which select box in the array they relate to, is there a way to do this??

I am writing a CRON job that will execute daily.  First it will identify from a MySql table the date in a field 'FAPforSale_repost35'  If the date is the today date it will then execute commands to delete photo images in a directory, delete the directory, and finally remove the record from the database.   I am on step one which is to build the array of records that match the days date.  When I run the code, there are no errors but I am not getting results even though the records in the test table are set for today.  Below is the select

<?php

 define( "DIR", "../zabp_employee_benefits_processor_filesSm/", true );
 
 require( '../zipconfig.php' );
 require( DIR . 'lib/db.class.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/configRecognition.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/libRecognition/MailClass.inc' );
 
 
 
$todayRepost35 = date("Y-m-d");
echo $todayRepost35;



function repostEndSelect()
 
      {
        
        global $db;
            
    $this->db = $db;
        
            
     $data = $this->db->searchQuery( "SELECT `FAPforSale_IDnumber`,  `FAPforSale_image1`,  `FAPforSale_image2`,  `FAPforSale_image3`,  `FAPforSale_repost35`  FROM  `FAP_forSaleTest` Where `FAPforSale_repost35` = '$todayRepost35' ");
    
    
         $this->FAPforSale_IDnumber = $data[0]['FAPforSale_IDnumber'];
        $this->FAPforSale_image1 = $data[0]['FAPforSale_image1'];
        $this->FAPforSale_image2 = $data[0]['FAPforSale_image2'];
        $this->FAPforSale_image3 = $data[0]['FAPforSale_image3'];
        $this->FAPforSale_repost35 = $data[0]['FAPforSale_repost35'];
        
        echo $this->FAPforSale_IDnumber;
        echo $this->FAPforSale_image1;
        echo $this->FAPforSale_image2;
        echo $this->FAPforSale_image3;
        echo $this->FAPforSale_repost35;
        
    } // ends function...
        
echo( ' Finished...' );

?>

Thanks in advance for any suggestions or direction.  Chapter two will be when I start testing the commands to delete.

Hi guys,

I am getting data from a json source:

```

$jsondata = file_get_contents($url);
  $response = json_decode($jsondata, true)
  echo "<pre>"; print_r(array_keys($response));; echo "</pre>";

```

and this returns:

```

Array
(
    [0] => jsonapi
    [1] => data
    [2] => links
)

```

I want  to extract data from specific key in the data array (eg 'title'):

```

    [data] => Array
        (
            [0] => Array
                (
                    [type] => recipes
                    [id] => d6cd7643-6e44-4d26-9ed9-9da7196cef12
                    [attributes] => Array
                        (
                            [internalId] => 7
                            [isPublished] => 1
                            [title] => Deep mediterranean quiche
                            [createdAt] => 2019-05-07T13:34:27+0200
                            [updatedAt] => 2019-05-07T13:34:27+0200
                            [isPromoted] => 1
                            [path] => /recipes/deep-mediterranean-quiche
                            [cookingTime] => 30
                            [difficulty] => medium
                            [ingredients] => Array
                                (
                                    [0] => For the pastry:
                                    [1] => 280g plain flour
                                    [2] => 140g butter
                                    [3] => Cold water
                                    [4] => For the filling:
                                    [5] => 1 onion
                                    [6] => 2 garlic cloves
                                    [7] => Half a courgette
                                    [8] => 450ml soya milk
                                    [9] => 500g grated parmesan
                                    [10] => 2 eggs
                                    [11] => 200g sun dried tomatoes
                                    [12] => 100g feta
                                )

                            [numberOfservings] => 8
                            [preparationTime] => 40
                            [instructions] => 

```

How do I loop through the data array and select just the 'title' and 'difficulty' for example?

Edited May 12, 2019 by ludo1960

Here is my code:

//Grab all the monster in Monster zone 1

$q = $db->query('SELECT * from rpg_monsters where monster_zone = 1');

while ($monsterdata = $db->fetch_assoc($q))
    {
        $monster_chance[] = $monsterdata;
        
    }

and my var_dump:

array (size=4)
0 =>
array (size=8)
'monster_id' => string '1' (length=1)
'monster_name' => string 'Merman' (length=6)
'monster_level' => string '1' (length=1)
'monster_type' => string 'Normal' (length=6)
'monster_hp' => string '10' (length=2)
'monster_dmg' => string '1' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.10' (length=4)
1 =>
array (size=8)
'monster_id' => string '2' (length=1)
'monster_name' => string 'Chris Wilson' (length=12)
'monster_level' => string '2' (length=1)
'monster_type' => string 'Unique' (length=6)
'monster_hp' => string '25' (length=2)
'monster_dmg' => string '3' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.04' (length=4)
2 =>
array (size=8)
'monster_id' => string '3' (length=1)
'monster_name' => string 'Seaman Warrior' (length=14)
'monster_level' => string '2' (length=1)
'monster_type' => string 'Magic' (length=5)
'monster_hp' => string '20' (length=2)
'monster_dmg' => string '2' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.10' (length=4)
3 =>
array (size=8)
'monster_id' => string '4' (length=1)
'monster_name' => string 'Goblin Attacker' (length=15)
'monster_level' => string '2' (length=1)
'monster_type' => string 'Normal' (length=6)
'monster_hp' => string '15' (length=2)
'monster_dmg' => string '2' (length=1)
'monster_zone' => string '1' (length=1)
'chance' => string '0.10' (length=4)

As you can see, the Unique Monster (Chris Wilson) is the lowest chance at only 4%. And all the other mobs at at 10% chance to spawn.   Here is my code for probability:

$rate = (double) '0.03'; // 3%
$max = 1 / $rate; // 100
if (mt_rand(0, $max) === 0) {
    // chance < $rate
    echo "Only 3% probability, holy cow!";
}

My problem is, I'm a bit lost as how to get my probability code inside a loop and having the dynamic $rate correspond to my "chance" row. Although, I could just use ORDER BY rand() in mysql, it wouldn't let me use any probability and chances... hmmm
Edited by Monkuar, 12 October 2014 - 11:12 AM.

I am having a helluva time trying to populate my state option box with a state array.

I have the array set but now how does this get called into the foreach block where the select box is? I can populate it i guess with options manually but I want to get the array to display in the box instead.

I tried everything with the minimal experience I have so I need a little help, I got the select box up and displaying where I want it but I cant populate it with an array call.   See foreach block near the end of the code:

Thanks a bunch!

here is my include file code so far:

<?php
 /*  Program name: form_test_state.inc
  *  Description:  Defines a form that collects a user's
  *                name and mailing address.
  */
$rows = array( "first_name" => "First Name",
                 "last_name" => "Last Name",
                 "phone" => "Phone Number",
                 "city" => "City",
                 "state" => "State",
                 "address" => "Address",
                 "zip_code" => "ZIP Code",
                 "e_mail" => "E-Mail");
    
    $states_list = array('AL'=>"Alabama",'AK'=>"Alaska",'AZ'=>"Arizona",'AR'=>"Arkansas",'CA'=>"California",'CO'=>"Colorado",'CT'=>"Connecticut",'DE'=>"Delaware",'DC'=>"District Of Columbia",'FL'=>"Florida",'GA'=>"Georgia",'HI'=>"Hawaii",'ID'=>"Idaho",'IL'=>"Illinois", 'IN'=>"Indiana", 'IA'=>"Iowa",  'KS'=>"Kansas",'KY'=>"Kentucky",'LA'=>"Louisiana",'ME'=>"Maine",'MD'=>"Maryland", 'MA'=>"Massachusetts",'MI'=>"Michigan",'MN'=>"Minnesota",'MS'=>"Mississippi",'MO'=>"Missouri",'MT'=>"Montana",'NE'=>"Nebraska",'NV'=>"Nevada",'NH'=>"New Hampshire",'NJ'=>"New Jersey",'NM'=>"New Mexico",'NY'=>"New York",'NC'=>"North Carolina",'ND'=>"North Dakota",'OH'=>"Ohio",'OK'=>"Oklahoma", 'OR'=>"Oregon",'PA'=>"Pennsylvania",'RI'=>"Rhode Island",'SC'=>"South Carolina",'SD'=>"South Dakota",'TN'=>"Tennessee",'TX'=>"Texas",'UT'=>"Utah",'VT'=>"Vermont",'VA'=>"Virginia",'WA'=>"Washington",'WV'=>"West Virginia",'WI'=>"Wisconsin",'WY'=>"Wyoming");            
                
              
$submit = "Submit mailing information";
?>
<html>
<head>
  <style type='text/css'>
   <!--
body {
    background: #42413C;
    color: #000;
    font-family: Tahoma, Geneva, sans-serif;
    font-size: 90%;
}
      form {
        margin: 1em 2 2 2;
        padding: 1;
        width: 1100px;
        margin-left: 35%;

      }
      .field {padding-bottom: 1em;
    
}
        label {
        font-weight: bold;
        float: left;
       width: 10%;
margin-right: 1em;
        text-align: right;
        background-color: #9F6;
padding-right: 5px;
        
      }
      select {margin-bottom: 1em;}
      
      #submit {
        margin-left: 15%;
      }
h3 {
width: 500px;
margin-left: 35%;
}


   -->
 </style>
</head>
<body>
<h3>Please enter your mailing information below:</h3>
<?php
 /* loop that displays the form */

  echo "<form action='checkBlankOnly_latest.php' method='post'>";

  foreach($rows as $field => $label)

  if($field == "state")
 {
      echo "<label for='$field'>$label</label>
      <select name='State'>                          <<<<  Insert $states_list array here I am trying to figure out >>>>
  <option value='state'>Alabama </option>
</select> ";
   }
   else  
  {
    echo "<div class='field'><label for='$field'>$label</label>
            <input id='$field' name='$field' type='text' value='".@$$field."'  
   size='25%' maxlength='65' /></div>\n";
  }
  echo "<div id='submit'>
    <input type='submit' value='$submit'></div>";
?>

</form>
</body>
</html>

I want to make a table for each paddler_id (Field) which exists into pushup Database

My code for paddler_id = 1 is


require "../sql.php";

$result = mysql_query("EXPLAIN pushup");
$r = mysql_query("SELECT * FROM paddlerinfo t1 LEFT JOIN pushup t2 on t2.paddler_id=t1.id LEFT JOIN practicedate t3 on t3.practice=t2.practice_id ORDER BY t1.firstname ASC ");
$r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");

echo "<table width='30%' border='1' cellpadding='0' cellspacing='0' style='font-family: monospace'>";
echo "<tr>";
echo "<td>DATE</td>";
while ($row = mysql_fetch_array($result)) {

if (in_array($row["Field"], array("paddler_id", "practice_id", "p_id"))) continue;

echo "<td>",($row["Field"]), "</td>";
}
echo "</tr>";

while (($data = mysql_fetch_array($r1, MYSQL_ASSOC)) !== FALSE) {
   unset($data["p_id"],$data["paddler_id"]);
echo "<tr>";
   foreach ($data as $k => $v) { 
echo "<td>";
      echo"$v";
echo "</td>";
}

echo "</tr>";
}


echo "</table>";

mysql_free_result($result);
mysql_free_result($r);
mysql_free_result($r1);
mysql_close();



The problem is on line $r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");
I want to put something which makes it paddler_id = X where x = 2,3,4,5... and x exists in database and do not print twice the x (because that database may have rows where x = same id


How do i do that??

Hi all, probably a fairly straightforward question, but I can't find the answer I'm looking for:

I have an array 'idents' that contains ID numbers. I now want to write a MySQL query that selects all values of the table-field 'email' where the field 'ID' = any of the IDs stored in 'idents'. Then I want to put those emails in an array 'emails'.

So e.g. my table is as follows:
ID         |   email
----------------------
111111 |   email1
222222 |   email2
333333 |   email3
444444 |   email4
555555 |   email5
666666 |   email6

and the array 'idents' is as follows: '111111','444444','555555'

then I want the query to return 'emails' = array('email1','email4','email5');

Thanks for your help!

Here is my query:

Code: [Select]
$db->query("SELECT cache.*,u.username from search_cache cache LEFT Join users as u ON u.id = 'NEED HELP HERE' where ident = '{$username}' ORDER BY DATE DESC") or error('Unable to send the message.', __FILE__, __LINE__, $db->error());
Here is my data inside my search_cache



Here is my while loop:

Code: [Select]
while($recent = $db->fetch_assoc($rec)){
$data = unserialize($recent['search_data']);

}


Now I can use $data['search_type'] as a array and If I use echo $data['search_type']['2'] it echo's out the user_id 32 as seen in the screenshot at the very end.

Problem is, I want to use that  'NEED HELP HERE'  to join with that id 32 dynamically, how the hell is that possible with mysql or is it? 


Or would it be easier to just add a new row/column named user_id and just join of that instead of trying to do all this? would that be faster?

I am simply trying to insert a value generated from an array in a while loop, but it seems the value is not global and I can't pass it as I like. I did some research on this, but could not find an answer that solved my issue...

Here is my select box code which is working perfect:

<select name="city">
<?php
$sql = "SELECT id, city_name FROM cities ".
"ORDER BY city_name";
$results_set = (mysqli_query($cxn, $sql)) or die("Was not able to produce the result set!");
while($row = mysqli_fetch_array($results_set)) {
echo "<option value=$row[id]>$row[city_name]</option>";
}
?>
</select>

Are any variables defined in a while loop global to the while loop only?

Here is my SQL which you can see my $row[id] being passed thru field city_id... The value is being generated as supposed to based on value like: value="1", value="2" etc.. for the select options for each city name. So the values are there... But I CANNOT get that numerical id to pass to the database when submitting my form.

Any ideas for a workaround to get this value passing as normal?

if (isset($_POST['addPosting'])) {
      $query = "INSERT INTO Postings (id, city_id, title, description) VALUES
('','$row[id]','$_POST[title]','$_POST[description]')";

Hi, I have come up with the following code, I need it to get the details of several scattered products and echo the results, the trick is I don't want it to echo the results one after the other... I want to have the products scattered between unique text on the page but don't want to run the query several times for performance reasons.

E.g.- PAGE to look like this:

$Product_1

unique text/images

$Product_2
$Product_3

unique text/images

$Product_4


Current Code:

Code: [Select]
<?
$result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");
while($row = mysql_fetch_array($result))
  {
    $x = "1";
      while ($x<=3)
{
          echo $x;
          $Product = "Product_";
          $Product = $Product.$x;
          echo $Product;
          $Product = $row['Product_ID'];
          echo $Product;
          $x++;
          echo $x;
        }
  }

At the moment it returns the following results:

Quote

1
Product_1
465
2

2
Product_2
465
3

3
Product_3
465
4

1
Product_1
475
2

2
Product_2
475
3

3
Product_3
475
4


A few problems...

In Blue... it duplicates for product 465
In Red... It repeats again for 475
Also.... it starts with 465, but I want it to go in order as how it appears - $result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");  so should start with 475


I want to get the following result:

Quote

1
Product_1
475
2

2
Product_2
465
3

3
Product_3
234
4

4
Product_4
567
4

(and so on.....)



If anyone could provide me assistance with my troubled 'while loop' statement that would be much appreciated!