PHP - Php Page Layout When Query Result Returns Multiple Rows

Hi,

i have a database with multiple records. One of those values is an image. When i query the database and i want only the images as a result it gives the result in a field. It then fills up the field horizontal and when there is no more field left it starts a new row. That is what i want.

But now i want some extra info next to the picture so i put that in a table with two colums like this:

echo '<table border="1" width="400"><td><a href="'.$row['website'].'"> <img src="'.$row['prod_img'].'">
               '.$row['prod_name'].' <a href="'.$row['website'].'">'.$row['website'].'</td></table>
            ';}}

But i still want the result to fill up the field and when the field is full i want the next results on a row below this....

Anyone?

Ok so I am pretty good with mysql and performing queries to get the data that I need. However, I have a question for any of you gurus out there that may be able to help me with an issue that I always run into with certain types of queries. Say I have 2 tables like this:

Galleries
id name 1 My Photos
Gallery Photos
id gallery_id photo 1 1 photo1.jpg 2 1 photo2.jpg 3 1 photo3.jpg
Now usually when I pull this info from the database I have to do 2 separate queries in order to get the data and then link them so I would do something like.


<?php
//make the gallery query
$query = "SELECT * FROM galleries";
$results = mysql_query($query);

//setup an array for the galleries data
$gallery_data = array();

//loop through the galleries
for($i=0;$i<mysql_num_rows($results);$i++){
//add the gallery info to the gallery data array
$gallery_data[$i] = mysql_fetch_array($results);

//make the photos query with the gallery id
$photo_query = "SELECT * FROM gallery_photos WHERE gallery_id='".mysql_real_escape_string($gallery_data[$i]['id'])."'";
$photo_results = mysql_query($photo_query);

//setup the photos array
$photo_data = array();

//put the photos in the array
for($n=0;$n<mysql_num_rows($photo_results);$n++){
$photo_data[$n] = mysql_fetch_array($photo_results);
}

//add the photos to the gallery array
$gallery_data[$i]['photos'] = $photo_data;
}

//now to display it is like this
if(is_array($gallery_data)){
foreach($gallery_data as $gallery){
echo $gallery['name'];

//show the photos
if(is_array($gallery['photos'])){
foreach($gallery['photos'] as $photo){
echo $photo['photo'];
}
}
}
}
?>


So my question is there a way to get all of this data at one time. I know how to do multiple queries in one and to do joins but they can only return one row as far as I know of. The only other way that I know how to do this is by ordering them by name and selecting them directly from the photos table and then just getting the gallery name like this:


SELECT *,(SELECT name FROM galleries WHERE id=gallery_photos.id) AS gallery_name FROM gallery_photos ORDER BY gallery_id


Then I could just do one loop and see if the name has changed and if so to output the new name. But I would like to know if there is a way to get a second set of results as an array from a query so I could just select the galleries and photos all in one query. Any help is appreciated.

Hey, I was wondering if there is a way to pull multiple rows at once using a list of unique identifiers. For example, I want to pull the rows with the IDs of 4,13,91 and 252

I know the WHERE part of this query is incorrect, but I'm putting it to hopefully help you guys understand what I'm looking for.

$result = mysql_query("SELECT * FROM $table WHERE id='4' OR '13' OR '91' OR '252'");
while($row = mysql_fetch_array($result))
{
echo($row['name']);
}


Or is the best way simply to do it one query at a time without a while statement? There could be as many as a few dozen records being pulled per page.

I insert data in mysql table row using multiple method : 1#2#3 . 1 is ID of country, 2 is Id of state, 3 is ID of town . now i have this table for real estate listings. for each list(home) i have country/state/town (1#2#3). in country table i have list of country - in country table i have list of state - in country table i have list of town. i need to The number of houses in country / state / town . my mean is :
Code: [Select]
USA [ 13 ] <!-- This Is equal of alabama+alaska+arizona -->
----Alabama [8] <!-- This Is equal of Adamsville+Addison+Akron -->
-------Adamsville [2]
-------Addison[5]
-------Akron[1]
......(list of other City)
----Alaska [ 3 ]
-------Avondale[3]
......(list of other City)
----Arizona [ 2 ]
-------College[2]
......(list of other City)
Lisintg Table :

Code: [Select]
ID -- NAME -- LOCATION -- DATEJOIN -- ACTIVE
 1 -- TEST -- 1#2#3    -- 20110101 -- 1
 2 -- TEST1 -- 1#2#3    -- 20110101 -- 1
 3 -- TEST2 -- 1#3#5    -- 20110101 -- 1
 4 -- TEST3 -- 1#7#6    -- 20110101 -- 1
Country Table :

Code: [Select]
id       -- name 
 1        -- USA 
stats Table :

Code: [Select]
id        -- countryid -- name 
 1        -- 1             -- albama
 2        -- 1             -- alaska
 3        -- 1             -- akron
town Table :
Code: [Select]
id        -- countryid -- statsid -- name 
 1        -- 1             -- 1         -- adamsville
 2        -- 1             -- 1         -- addison
 3        -- 1             -- 1         -- akron
Thanks For Any Help.

Given the below 3 database tables I am trying to construct a SQL query that will give me the following result:

customer_favourites.cust_id
customer_favourites.prod_id OR product.id
product.code
product.product_name
product.hidden
product_ section.section_id (MUST BE ONLY THE ROW WITH THE LOWEST SECTION ID, I.E. ROW ID #44108)
product_ section.catpage (MUST BE ONLY THE ROW WITH THE LOWEST SECTION ID, I.E. ROW ID #44108)
product_ section.relative_order (MUST BE ONLY THE ROW WITH THE LOWEST SECTION ID, I.E. ROW ID #44108)

I currently have....

SELECT customer_favourites.cust_id, customer_favourites.prod_id, product.code, product.product_name, product.hidden, product_section.section_id, product_section.relative_order, product_section.catpage  
FROM customer _favourites  
INNER JOIN product ON customer_favourites.prod_id = product.id  
INNER JOIN product_section ON product_section.product_code = product.code  
WHERE `cust_id` = '17' AND `hidden` = '0' GROUP BY `code`  
ORDER BY `section_id` ASC, `relative_order` ASC, `catpage` ASC LIMIT 0,30

This gives me what I want but only sometimes, at other times it randomly selects any row from the product_section table.

I was hoping that by having the row I want as the last row (most recent added) in the product_section table then it would select that row by default but it is not consistent.

Somehow, I need to be able to specify which row to return in the product_section table, it needs to be the row with the lowest section_id value or it should by the last row (most recent).

Pulling my hair out so any help is gratefully received.  
customer_favourites

id     cust_id   prod_id
70    4            469
product

id        code           product_name    hidden
469    ABC123     My Product        0
product_section

id                  section_id      catpage    product_code    relative_order     recommended
44105         19                   232            ABC123             260                    1
44106          3                     125            ABC123              87                      1
44107          2                     98              ABC123             128                     1
44108          1                    156             ABC123             58                        0

 

Hi all,

I'm currently working on an admin page and I'm trying to figure out how I can make an update query where all information will be updated.
The code below is where I extract all the Users and their status from the database and now I when the statuses are updated in the text fields they need to be send to the database. Does anyone know how this could be done?

Thnx Ryflex

<?php

    require_once('auth.php');
    require_once('config.php');

$global_dbh         = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
                      or die("Could not connect to database");
                      mysql_select_db(DB_DATABASE, $global_dbh)
                      or die("Could not select database");

$user_query = "SELECT *
   FROM members";
$user_result = mysql_query($user_query);
?>
<form ID="gotoresource" NAME="gotoresource" METHOD="POST" ACTION="admin_exec.php"> 
<table width="500" border="1" align="center" cellpadding="2" cellspacing="0">
<tr>
<td><b>ID</b></td>
<td><b>User</b></td>
<td><b>Status</b></td>
</tr>
<?php
while($row = mysql_fetch_assoc($user_result))
{
echo "<tr>";
echo "<td>"; 
echo $row['member_id'];
echo "</td>";
echo "<td>"; 
echo $row['login'];
echo "</td>";
?>
<td>
<input type="text" name="status" value="<?php echo $row['status'];?>" />
</td>
    <?php
echo "</tr>";
}

?>
<input type="image" src="/images/button.gif" alt="Submit button">
</form> 
<html>
<head>
<title>AdminPage</title>
<link href="loginmodule.css" rel="stylesheet" type="text/css" />
</head>
<body>

</body>

</html>

Why does this return null rather than 'john must write the book'?
Code: [Select]
<?
abstract class User {
protected $name;
protected $role;

function __construct($name,$role){
$this->name = $name;
$this->role = $role;
}

abstract function run_errand();
}

class Author extends User {
public function run_errand(){
echo $this->name . "must write the book";
}
}

class Editor extends User {
public function run_errand(){
echo $this->name . "must edit the book";
}
}

class Boss {
private $users = array();

public function review(User $user){
$this->user[] = $user;
}

public function delegate(){
if(count($this->users)){
foreach($this->users as $user){
if($user->role == "author"){
echo $user->run_errand();
}
}
}
}
}

//client code
$boss = new Boss();
$boss->review(new Author('John','author'));
var_dump($boss->delegate()); //returns null
?>

Hi I don't want errors on my page been reported on the web browser for all to see so I use this.
$total2 = mysql_num_rows($qCheckUser) or die ("Error1");
however if the query returns zero rows I get Error1 on the web page. This is not an error and
I don't want to taje out the or die()

Any sugestions.

Hi,
it's my first post so hello to you and i hope you will be forgiving:)
I've made a basic script, which takes a urls from the form(each of them is  the new row) and then search each of those urls for an email. The problem is that only the email from the last url is returned.
print_r("show link:". $urls[$i]."<br>"); shows all urls in the form, but the print_r("show current_url:". $current_url); shows only the last one.


Code: [Select]
<?php


$urls = explode("\n", $_POST['urls']); 

$db = new mysqli('localhost', 'root', 'root', 'urls');  

if (mysqli_connect_errno()) {
echo 'B&#322;&#261;d: ';
exit;
}


for ($i=0; $i<count($urls); $i++){

print_r("show link:". $urls[$i]."<br>");

$current_url = file_get_contents($urls[$i]);
print_r("show current_url:". $current_url); 


preg_match( "/[\._a-zA-Z0-9-]+@[\._a-zA-Z0-9-]+/i", $current_url, $email);//email


print_r ("show email:".$email[0]);


$zapytanie = "INSERT INTO urle set adres = '$email[0]' "; 

$wynik = $db->query($zapytanie);




}

if ($wynik) {
echo $db->affected_rows ."pozycji dodano.";
} else {
echo mysql_errno() . ":" . mysql_error() .   "Wyst&#261;pi&#322; b&#322;&#261;d przy dodawaniu urli  ";
}

$db->close();

?>

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>";
  ?>

Hey guys! I've been having trouble with this all day. I'm wanting to display my results in rows. Like, 4 results in 1 row, then another 4, then another 4, etc. like this:
IMAGE  IMAGE IMAGE IMAGE
IMAGE IMAGE IMAGE IMAGE
IMAGE IMAGE IMAGE IMAGE

I'm nto sure how to do that. I want to display pictures. Here is my code for the page:
bag.php:
Code: [Select]
<?php
session_start();
include("config536.php");
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>

<?php
if(!isset($_SESSION['username'])) {
echo "<ubar><a href=login.php>Login</a> or <a href=register.php>Register</a></ubar><content><center><font size=6>Error!</font><br><br>You are not Logged In! Please <a href=login.php>Login</a> or <a href=register.php>Register</a> to Continue!</center></content><content><center><font size=6>Inventory</font><br><br></center></content>";
}

if(isset($_SESSION['username'])) {
echo "<nav>$shownavbar</nav><ubar><img src=/images/layout/player.gif><a href=status.php>$showusername</a>.......................<img src=/images/layout/coin.gif> $scredits</ubar><content><center><font size=6>Inventory</font><br><br>";

$action = $_GET['action'];
$gid = $_GET['itemid'];

$irow = "SELECT * FROM uitems WHERE username='$showusername'";
$iquery = mysql_query($irow);
while($ir = mysql_fetch_array($iquery)) {
$uid = $ir['uitemid'];
$iid = $ir['theitemid'];
$iun = $r['username'];
$il = $ir['location'];


$tirow = "SELECT * FROM items WHERE itemid='$iid'";
$tiquery = mysql_query($tirow);
while($tir = mysql_fetch_array($tiquery)) {
$tiid = $tir['itemid'];
$tin = $tir['name'];
$tiim = $tir['image'];
$tid = $tir['description'];
$tirr = $tir['rarity'];
$tit = $tir['type'];
$tiu = $tir['uses'];
$tis = $tir['strength'];
$tide = $tir['defense'];
$tih = $tir['heals'];

echo "<img src=/images/items/$tiim><br>$tin<br><br>";
}
}

}
?>

</html>I have no errors, everything works great! It's just I'm not sure how to display them the way I want them. Right now they are displayed like this:
IMAGE
IMAGE
IMAGE
IMAGE

Any help is greatly appreciated, thank you!

Hi all ! The following code has two similar queries. Query 1 and Query 2. While Query 1 works just fine, Query 2 simply fails persistently. I have not been able to figure out why?   I have checked every single variable and field names but found no discrepancy of any sort or any mismatch of spelling with the fields in the database.   I would be grateful if anybody can point out what is preventing the second query from returning a valid mysqli object as the first one does. Here is the code for the two.

<?php
$db_host = "localhost";
$db_user ="root";
$db_pass ="";
$db_database ="allscores";

//////////////// CHECKING VARIABLE FILEDS IN A UPDATE QUERY //////////////////////////////////
//////////////// QUERY 1 /////////////////////////////////////////////////////////////////////

/*
$db_database ="test";
$db_table ="users";
$RecNo = 1;			
		
$field1 = 'name';
$field2 = 'password';
$field3 = 'email'; 
$field4 = 'id';
$val1 = "Ajay";
$val2 = "howzatt";
$val3 = "me@mymail.com";


					$con = mysqli_connect($db_host,$db_user,$db_pass,$db_database) or die('Unable to establish a DB connection');
					$query = "UPDATE $db_table SET $field1 = ?,
							$field2 = ?, $field3 = ?
							WHERE $field4 = ? ";   // session terminated by setting the sessionstatus as 1 
					$stmt = $con->prepare($query);
					var_dump($stmt); 
					$stmt->bind_param('sssi',$val1,$val2,$val3,$RecNo);
					if($stmt->execute())
					{
						$count = $stmt->affected_rows;
						echo $count;
					}		
//////////////// QUERY 1  END /////////////////////////////////////////////////////////////////////
*/



//////////////// QUERY 2 /////////////////////////////////////////////////////////////////////

$con = mysqli_connect($db_host,$db_user,$db_pass,$db_database) or die('Unable to establish a DB connection');
$table = 'scores';
$date = date('Y-m-d H:i:s');


/*
$prestr 	= "Mrt_M_";		
$STATUS		= $prestr."Status";
$S_R1 		= $prestr."Scr_1";
$S_R2 		= $prestr."Scr_2";
$PCT 		= $prestr."PPT";
$DPM 		= $prestr."DSP";
$TIMETAKEN 	= $prestr."TimeTaken";
*/


$STATUS		= "Mrt_M_Status";
$S_R1 		= "Mrt_M_Scr_1";
$S_R2 		= "Mrt_M_Scr_2";
$PPT 		= "Mrt_M_PPT";
$DSP 		= "Mrt_M_DSP";
$TIMETAKEN 	= "Mrt_M_TimeTaken";

$TimeOfLogin	=	$date;	
$no_of_logins	=	10;
$time_of_nLogin	=	$date;
$m_scr_row1		=	5;
$m_scr_row2		=	5;
$m_ppt			=	20;
$m_dsp			=	60;
$m_time			=	120;
$date			=	$date;
$RecNo			=	24;

		$query = "UPDATE $table SET 
				TimeOfLogin = ?,
				no_of_logins = ?,
				time_of_nLogin = ?,
				$S_R1 = ?,					
				$S_R2 = ?,					
				$PPT = ?,						
				$DSP = ?,						
				$TIMETAKEN = ?,				
				$STATUS = '1',				
				TimeOfLogout = ?,
				WHERE RecNo = ?";			
		$stmt = $con->prepare($query);

		var_dump($stmt);

		$stmt->bind_param('sisiiddssi',$TimeOfLogin,$no_of_logins,$time_of_nLogin,$m_scr_row1
					$m_scr_row2,$m_ppt,$m_dsp,$m_time,$date,$RecNo);
		if($stmt->execute()) echo " DONE !";


?>	

Thanks to all

 $result = mysql_query("SELECT *  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays the total rows in the table.

$result = mysql_query("SELECT COUNT(friend_system_accepter)  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays '1', which is incorrect.   I want to echo out the number of rows where 'friend_system_accepter' = $myusername   Thanks

Assuming I have a result object:

$result = mysqli_query($sql_string);

How can I get specific rows, i.e. multiple rows are returned 8 total, but I was rows 2-6. Thanks.

Me again.. I'm fetching data from MySQL but each person in people.php is displayed two times instead one.. The issue must be inside models_category_tbl table, because each person have more then one result. Any advice is appreciated. What should I do?

I would like to display people something like that:

1 John Doe 1 IT developer, 3 mechanic

models/model = person

category = occupation/skills

MySQL:

model_index table
+---------+------------+-------------+-------------------+---------------+----------------+
|model_id | model_name | model_title | model_description | model_country | model_slug	  |
+---------+------------+-------------+-------------------+---------------+----------------+
| 1 	  | John Doe   | Johns title | Johns desc        | Hungary       | john-doe 	  |	
+---------+------------+-------------+-------------------+---------------+----------------+

models_category_tbl table
+-------------+---------------------+---------------------+
| category_id | model_category_name | model_category_slug |
+-------------+---------------------+---------------------+
| 1           | it developer        | it-developer        |
| 2           | photographer	    | photographer        |
| 3           | mechanic            | mechanic            |
+-------------+---------------------+---------------------+

models_category_ids table
+----+----------+-------------+
| id | model_id | category_id |
| 1  | 1        | 1           | 
| 1  | 1        | 3           |
+----+----------+-------------+

 

PHP function to fecth data:

        public function getAllModels1 () {

        $sql = "SELECT * FROM models_index  JOIN models_category_ids ON models_index.model_id=models_category_ids.model_id JOIN models_category_tbl ON  models_category_tbl.category_id=models_category_ids.category_id" ;
            $stmt = $this->conn->prepare($sql);
            $stmt->execute();
            $result = $stmt->fetchAll((PDO::FETCH_OBJ));
            
            return $result;            
    }

 

people.php

<?php 
declare(strict_types=1);
ob_start();
include "includes/connect.php";
include "includes/functions.php";
 

   	$model = new ModelsData();
	$models = $model->getAllModels1();


	foreach ($models as $model) { ?> 


	<a href="model.php?id=<?= $model->model_id ?>"><img src="<?= $model->model_img_path ?><?=$model->model_img_name ?>"></a>	 
 
	<?php echo $model->model_id . " " .  $model->model_name . " " . $model->category_id .  " " . $model->model_category_name  ; ?>
	

	<h3><?= $model->model_name ?></h3>

 
<?php }  ?>

 

Output:

 1 John Doe 1 IT developer 
 1 John Doe 3 mechanic