PHP - Multiple Returns From A Fetch

Hello, i have a query that returns the rows of certain parts of a databse.

i made a button on the end of each echo, to make sure that, the button being printed with each echo, correlates to that echo. However, the SESSIONS only return the same varaibles each time. The last in the list.

$sql = "SELECT p.Title, p.PerfDate, p.PerfTime FROM performance AS p INNER JOIN production AS r ON p.Title = r.Title";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
       echo '<tr>
<td>'.$row['Title'].'</td>
<td>'.$row['PerfDate'].'</td>
<td>'.$row['PerfTime'].'</td>
<td><button name="availability" value="'.$row['Title'].'">Availability</button></td> 
</tr>';

$_SESSION["Title"] = $row['Title'];
$_SESSION["PerfDate"] = $row['PerfDate'];
$_SESSION["PerfTime"] = $row['PerfTime'];



    }
} else {
    echo "0 results";
}

$_SESSION["name"] = $_GET["name"];

?>

How am i able to make it so each button correlates to each row?

 

There's a screenshot of how it looks for reference 

Edited December 8, 2019 by AdamSteele

I have this code and Im using a while to fetch all the data where users comments are but i want to change it to fetch only 25 rows at a time and each time it refreshes it fetch's 25 more different rows.
Code: [Select]
<?php
include "../../connect.php";
Header('Cache-Control: no-cache');
Header('Pragma: no-cache');
$username = mysql_real_escape_string($_GET['username']);
//If friend is set, then query for it, otherwise return all of the friends comments.
$friend = (isset($_GET['friend'])) ? ' AND b.friend = \'' . mysql_real_escape_string($_GET['friend']) . '\' ' : NULL;

$sql = "SELECT a.username,a.comment,a.timestamp,a.title,a.picture,a.pic_status,a.pic_url,b.id,c.avatar,c.atimestamp,c.onlinestatus FROM (user_comments as a JOIN accounts as c USING(username))JOIN `user_friends_list` as b ON (b.friend = a.username)WHERE (b.username = '$username' $friend AND b.status = 1) ORDER BY a.id DESC";

$result = mysql_query($sql);
$user_xml = "<?xml version=\"1.0\"?>\n";
//$user_xml .= "<root>\n";
if(mysql_num_rows($result) > 0)
{ 
while ($row = mysql_fetch_assoc($result))
{       
$user_xml .= "<comment>\n";
$user_xml .= "<image>" . $row['avatar'] . "</image>\n";
$user_xml .= "<name>" . $row['username'] . "</name>\n";
$user_xml .= "<text>\n";
$user_xml .= "<![CDATA[ ". $row['comment'] ."]]>\n";
$user_xml .= "</text>\n";
$user_xml .= "<time>" . $row['timestamp'] . "</time>\n";
$user_xml .= "<title>" . $row['title'] . "</title>\n";
$user_xml .= "<picture>" . $row['picture'] . "</picture>\n";
$user_xml .= "<status>" . $row['pic_status'] . "</status>\n";
$user_xml .= "<url>" . $row['pic_url'] . "</url>\n";
$user_xml .= "<ntimestamp>" . $row['atimestamp'] . "</ntimestamp>\n";
$user_xml .= "<online>" . $row['onlinestatus'] . "</online>\n";
$user_xml .= "</comment>\n";
}
}
//$user_xml .= "</root>\n";

echo $user_xml; 
?>

So i think i can do something like this but im not to sure.

just add a if statement

Code: [Select]
while ($row = mysql_fetch_assoc($result))
{


$user_xml .= "<comment>\n";
$user_xml .= "<image>" . $row['avatar'] . "</image>\n";
$user_xml .= "<name>" . $row['username'] . "</name>\n";
$user_xml .= "<text>\n";
$user_xml .= "<![CDATA[ ". $row['comment'] ."]]>\n";
$user_xml .= "</text>\n";
$user_xml .= "<time>" . $row['timestamp'] . "</time>\n";
$user_xml .= "<title>" . $row['title'] . "</title>\n";
$user_xml .= "<picture>" . $row['picture'] . "</picture>\n";
$user_xml .= "<status>" . $row['pic_status'] . "</status>\n";
$user_xml .= "<url>" . $row['pic_url'] . "</url>\n";
$user_xml .= "<ntimestamp>" . $row['atimestamp'] . "</ntimestamp>\n";
$user_xml .= "<online>" . $row['onlinestatus'] . "</online>\n";
$user_xml .= "</comment>\n";
}

I only wnat to read 25 comments at a time and when i click a button to read more then it reads 25 more rows but it dose not read the data unless requested... can any one help me?

Okay so, I have always been curious, just never have taken the time to ask someone / learn what the differences are in fetches. What does mysql_fetch_array and mysql_fetch_row do thats different from each other? When pulling data from the database, would I like fetch array, or fetch row? or even fetch assoc? Thanks!

Hello, i have a query that returns multiple results but in my php query it only returns the first result...ive been checking google on while loops but still havent gotten it to work...would love if someone could look at it...thanks
Code: [Select]
//   while ($result= mysql_fetch_array($stmt)){

     while ($stmt->fetch()) {
              break;
       
         //   $stmt->close();


           
 
            // Return unlock code, encoded with JSON
            $result[] = array(
       "l_name"=>$l_name,
           "f_name"=>$f_name,
       "birth"=>$birth,
"expires"=>$expires,

);       
         
           
             
     

            sendResponse(200, json_encode($result));
            return true;
       
        sendResponse(400, 'Invalid request');
        return false

Hi. I am a little confused about PDO, its classes and the general oop aspects of it. If you at the below code:  

<?php

try {
$handler = new PDO('mysql:host=127.0.01;dbname=app', 'root','');
$handlser->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

}catc(PDOException $e) {
echo $e->getMessage():
die();

}

$query = $handler->query('SELECT * FROM table');

while($r = $query->fetch(PDO::FETCH_OBJ)) {

echo $r->message;

}

What's confusing me is that the fetch method is a method within the PDOSTATEMENT class so how come an object hasn't been created before hand in order to use the method? Furthermore it appears the method is a static method within the PDOSTATEMENT class so how come the double semi colon is being used such as: PDOSTATEMENT::FETCH?

Any help would be appreciated. Thanks.

I'm getting frusted over an if else statememt that won't work.  It is calling one variable from the table.  If the variable is in the table it will display one thing, if the variable is absent, it should display something else.  I've tried !empty, isset, even $num_rows =1, but the content in the else doesn't display.  Here's the code:

Code: [Select]

<?
$result = mysql_query( "SELECT * FROM codeWords WHERE Mycode = '$MyCode' " )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
  while ($row = mysql_fetch_array($result))
  {
     extract($row);
     
if (!empty( $MyCode  )) {   
echo "here is the code word";
} else {
echo "you need to go back and get the code";
}
$row_count++;
}
mysql_close;
?>

When the code variable is correct the "here is the code word" displays.  when the code variable is incorrect, what should appear as "you need to go back and get the code" is just blank.

Any thoughts on how to structure the query in such a way that eh incorrect text appears?

Thanks,

this is supposed to display the distinct first two characters of a string(billnmbr) in a combobox
ive tried this on phpmyadmin and it returns 08..
which is correct
when i run this on my server, it returns nothing..
there must be something wrong with the way i called the billnmbr
does anybody have an idea on how i could call and display this correctly?
thanks and have a nice day.

<?php
  $mquery = "select distinct(substring(`billnmbr`, 1, 2)) from `tbltest`";
  $mres =mysql_query($mquery) or die(mysql_error());
   while($mrow=mysql_fetch_array($mres)){
$mm = $mrow['billnmbr'];
 echo "<option value=" . $mrow['billnmbr'] . ">";
 echo $mrow['billnmbr'] . "</option>"; 
} 
 echo " </select>";
  ?>

im not new enough for this to take so long to figure out, but for some reason
$rs = mysql_query("SELECT * FROM cl");

returns the last record instead of all the records in the table. anyone know why it wouldnt take everything?

I'm hoping someone can help me cos my hair's going white with this one. I'm trying to put together a script that acts as web-based interface to an SQL server. There are actually two parts, admin.htm and admin.php. The first part is just a form that passes login credentials to the PHP file. That part seems to work fine, but I'll post the source anyway: -

Code: [Select]
<!DOCTYPE HTML>

<html lang="en">

<head>

<title>SQL admin login</title>

<meta charset="iso-8859-1" />

</head>

<body>

<form action="admin.php" method="post">
<label for="username">Username: -</label>
<br />
<input type="text" name="username" id="username" />
<br />
<br />
<label for="password">Password: -</label>
<br />
<input type="password" name="password" id="password" />
<br />
<br />
<label for="server">Server: -</label>
<br />
<input type="text" name="server" id="server" />
<br />
<br />
<label for="database">Database: -</label>
<br />
<input type="text" name="database" id="database" />
<br />
<br />
<input type="submit" value="Login" />
<input type="reset" value="Reset" />
</form>

</body>

</html>

Following is the content of admin.php. By this point I can see the connection in MySQL Workbench, and when I submit the query 'SELECT * FROM subscribers' it's being stored in '$_POST['query']', but 'mysql_query($_POST['query'],$_SESSION['con']);' is returning nothing. There is definitely a record in that table, and the user I'm logging on with has permission to run the 'SELECT' command against this database, so I can't figure out why mysql_query(); is returning nothing: -

Code: [Select]
<!DOCTYPE HTML>

<?php

session_start();

if(!$_SESSION['con'])
{
   if(!($_POST['username'] || $_POST['password']))
   {
      if(!($_SESSION['username'] || $_SESSION['password']))
      {
      $error="Username and password variables empty.";
      }
   }
   else
   {
      $_SESSION['username']=mysql_real_escape_string($_POST['username']);
      $_SESSION['password']=mysql_real_escape_string($_POST['password']);
      $_SESSION['server']=mysql_real_escape_string($_POST['server']);
      $_SESSION['database']=mysql_real_escape_string($_POST['database']);
      $_SESSION['con']=mysql_pconnect($_SESSION['server'],$_SESSION['username'],$_SESSION['password']);
      if(!$_SESSION['con'])
      {
         $error="Failed to connect to server.";
      }
      else
      {
         $database=mysql_select_db($_SESSION['database'],$_SESSION['con']);
         if(!$database)
         {
            $error="Failed to connect to database.";
         }
      }
   }
}

if(!$_POST['query'])
{
   $error="No query submitted.";
}
else
{
   $result=mysql_query($_POST['query'],$_SESSION['con']);
   if(!$result)
   {
      $error="Query returned nothing.";
   }
}

?>

<html lang="en">

<head>

<title>SQL admin interface</title>

<meta charset="iso-8859-1" />

</head>

<body>

<form action="admin.php" method="post">
<textarea name="query" rows="10" cols="50">SELECT * FROM subscribers</textarea>
<br />
<br />
<input type="submit" value="Submit query" />
</form>

<?php

if($error)
{
   echo $_POST['query']."<br /><br />".$result."<br /><br />".$error;
   die();
}
else
{
   while($row=mysql_fetch_assoc($result))
      {
         echo $row['name']." ".$row['email'];
         echo "<br />";
      }
}

?>

</body>

</html>

Can anyone help?

MOD EDIT: [code] . . . [/code] tags added.

<?php



require("connection.php");




$query = 'SELECT * FROM job_post WHERE id_jobpost= :Id';
$start = $bdd->prepare($query);
$start->execute(array(':Id' => $_GET['id_jobpost'])); 
$result = $start->fetch();

foreach ($result as $results) {
    $jobtitle = $result['jobtitle'];
    $id_jobpost = $result['id_jobpost'];
    $description = $result['description'];
    
}


?> 

https://prnt.sc/uk3913

Whats wrong with this code

There is a school locator script at https://www.ocps.net/parents/pages/FindaSchool.aspx
When we input any address it returns schools located in that locality.

For example:

Use these details and submit the form

Street Number : 3902
Street Name   : Bobolink
Street Type   : Lane
City         : Orlando


It returns a row having three schools Elementary,Middle and High school
On clicking the more button it takes to the respective school details
So for each school I need the respective school names

Audobon Elementary
Glenridge Middle
Winter Park High

Please suggest some ways to achieve this functionality


Thanks



_________________________________________________ ____________________
http://travelinfo.techserveglobal.com/
http://blog.techserveglobal.com/

Well lets say I have a class called Private_Item with a property like $owner. The class itself and constructor will look like the way below: (Note the Private_Item class extends from a parent class called Item, this is not to be worried here)

Code: [Select]
class Private_Item extends Item{
   private $iid;
   // The itemname and category properties already exist for parent class
   private $owner;
   private $quantity;
   private $status = "Available";

   public function __construct($name, $owner, $quantity){
       parent::__construct($name);
       $this->owner = new User($owner);
       $this->quantity = $quantity;
   }
} 

Whenever I define a variable like $item = new Private_Item($itemname, $itemowner, $quantity), the $itemowner is used as reference to instantiate a User object, and then passed to the property $this->owner. In this way, I have actually instantiated two objects at once. One for the item, the other for the user who owns this item.

I have a question about using PDO's fetch class method though. I'd like to use it to retrieve database info and instantiate a Private_Item object immediately after fetching it from MySQL database. The code looks like below:

Code: [Select]
$item = $stmt->fetch(PDO::FETCH_CLASS, "Private_Item");

The real question is, can the user object still be instantiated in the meantime? I am not quite sure about this, and I may end up having only one $item object but its property $item->owner is not. For those of you familiar with advanced PDO stuff, please lemme know if I can instantiate a subsequent object with the method fetch(PDO::FETCH_CLASS). Thanks.

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

Im not sure where to post this but since it includes php il post it here instead of in the mysql forum.

ok so, i have a table and i get the values using while($row = mysql_fetch_array($result)){ and then echo them in rows.

that works fine but i need to add a class to the last row of my table. I would need somehow to fetch the last row of the array and make it echo something different.

Any help is appreciated

Thank you

Hi

I got a different and typical (for me) requirement from client. Client have a mobile. He will upload XML file from his mobile to my web address (http://111.111.111.111:8080/directoryname/

In my web address, i have to fetch that request (means take XML file) and insert those details into database by using php.

Can anyone tell me how can i do this?