PHP - Php Retrieve Multiple Data From Mysql

i have 8 division (div), i want to display 4 rows in 4 division and the remain 4 rows in the next 4 division here is my code structure for carousel

<div class="nyie-outer">    
<div class="container">
    <div  id="nyieFull" class="carousel slide carousel-multi-item" data-interval="false" data-ride="carousel">
        <div class="outer-controls-top">
        <div class="nyie-title"><h5>THIS IS NYIE</h5></div>
        <div class="controls-top">    
            <a class="btn-floating" href="#nyieFull" data-slide="prev"><i class="fa fa-chevron-left"></i></a>
            <a class="btn-floating" href="#nyieFull" data-slide="next"><i class="fa fa-chevron-right"></i></a>
        </div>
        </div>
        <div class="carousel-inner" role="listbox">
            <div class="carousel-item active">
                 first row

                 second row

                 third row

                 fourth row
            </div><!--/.First four rows here-->
            <div class="carousel-item">

                  fifth row

                 sixth row

                 seven throw

                 eighth row

            </div><!--/.second four rows here-->
        </div
    </div>    
</div> 
</div>

 

 

sql code   

CREATE TABLE  product(
prodId INT(11) NOT NULL UNIQUE AUTO_INCREMENT, 
image VARCHAR(255) NOT NULL,
prodName VARCHAR(255) NOT NULL,
prodPrice VARCHAR(255) NOT NULL,
description TEXT NOT NULL
PRIMARY KEY (prodId) 
);

php code

<?php 
include_once('db.php');
$sql = "SELECT image,prodName, prodPrice, description FROM product ORDER BY prodId ASC LIMIT 4";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
    // output data of each row
        while($row = mysqli_fetch_array($result)) {
            $activeprod =  '
            <div class="col-lg-3">
            <a href="more.php" class="newAdded">    
            <figure class="figure">   
               <img src="images/'. $row['image'] .'" alt="" class="img-responsive" >
                <figcaption class="figure-caption">
                    <span class="prodName"><b>Name: </b>'. $row['prodName'] .'</span>
                    <span class="prodPrice"><b>price: </b>'. $row['prodPrice'] .'</span>
                    <span class="desc"><b>description: </b>'. $row['description'] .'</span>    
                </figcaption>    
            </figure> 
            </a>
            </div>
            ';
    }
} 
?>

how can i echo that result in those rows 

 

 

 

Hi Guys

Just need some advice to go in the right direction.

I'm working on a csv upload script (part of a bigger thing i'm building), so i read in the csv to a multipdimensional array and then build a query that inputs all rows in one query - i read this is the most efficient way to import multiple rows of data at once(rather than multiple insert statements). Just for illustration here's the code i use to build the query so you understand what i'm on about:

Code: [Select]
$sql = "INSERT INTO teams (company, teamname, teamnum, amountraised, country, president) VALUES ";

// $rows is a count of the rows in the csv

for($i=1; $i<$rows; $i++){

$sql.="('{$myarray[$i][0]}','{$myarray[$i][1]}','{$myarray[$i][2]}','{$myarray[$i][3]}','{$myarray[$i][4]}','{$myarray[$i][5]}')";
echo $i . "<br/>";

if($i >= 1 && $i < $rows - 1)
{
$sql.= ",";
}
}

Anyway, the issue is that one of the fields("teamnum") needs to be unique - so i've set this as unique on the table in mysql.

But when i run my query it doesn't import anything if one of the records isn't unique. What i really want is for it to import the ones it can and catch the ones it cant import to present to the user.

So my question is - to acheive the above would i need to rewrite the query so that it inserts each row one at a time, instead of all together?

Or can someone point me in the right direction for a better solution?

Probably something very simple i've missed i am sure...

Thanks chaps!

Hi all .
In my scripts , there is a textarea that allow user to enter multiple phone number , message and date .
If there are 3 phone numbers in textarea , how can I insert 3 of them into sql with the same data of message and date?
Such as :

phone number : 0102255888,0235544777,0896655444
message:hello all
date:10/10/2011

and when it's insert into table , it will become:

1. 0102255888 | hello all | 10/10/2011
2. 0235544777 | hello all | 10/10/2011
3. 0896655444 | hello all | 10/10/2011

Here is the code I tried , but it will just save the last phone number .

Code: [Select]
           $cellphonenumber = explode(',', $_POST['cellphonenumber']);
           $message = $_POST['inputtext'];
           $date = $_POST['datetime'];



foreach($cellphonenumber as $value)
{

$sql="INSERT INTO esp( Recipient , Message , Date)
VALUES
('$value','$message','$date')";

}

 
        mysql_query($sql) or die ("Error: ".mysql_error());
 
        echo "Database updated.";
Any hints or advices ?

Thanks for every reply .

i have a mysql table which contains name like

mid           mname

101           AAA
102          BBB
103          CCC

now i have to print this name in a html table like AAA, BBB, CCC

i am getting this by while loop in a variable but when loop changes then value also change so please tell me how i get this only in one variable & print

Hey everyone.

I am creating a website so my family can select from the list of present my daugther has asked for.  I have them logging in, and that works.  I have the table data set and the search and table display works.  But I would like to display the list (as in the code below) but with a checkbox in the first column (add a column).  From that the authenticated user can click on the item they have purchased and that selection will be moved to another table (called purchased).  I have that code.  The only thing I cannot figure out is to present the data in list form with a checkbox (like you would see on an order form).

Here is the display code (there is no error checking at this point):


<head><LINK REL="SHORTCUT ICON" HREF="cmwschl.ico"></head>

<body bgcolor="#C0C0C0">

<font face="Arial" color="#000080">Books from the Selected Series</font> </h1>
<hr font color="Navy" font size="3">
<center>

<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="170" bgcolor="#FFCC66"><center><b><font color="navy" size="2" face="Trebuchet MS"><b><center>Book Number</center></font></b></center></td>
<td width="140" bgcolor="#FFCC66"><center><b><font color="navy" size="2" face="Trebuchet MS"><b><center>Book Group</center></font></b></center></td>
<td width="100" bgcolor="#FFCC66"><center><b><font color="navy" size="2" face="Trebuchet MS"><b><center>Book Title</center></font></b></center></td>
</tr>

<?php
$con = mysql_connect("localhost","twilson","R00tb33r!") or die('Connection: ' . mysql_error());;
mysql_select_db("CMWWeb", $con) or die('Database: ' . mysql_error());
?>
<?
$group = $_POST['bookgrp'];

//if ($Prod <> 0) {
$sql = "SELECT * FROM `OpenBooks` WHERE `bookgrp`= '$group'";
$results = mysql_query($sql);
if ($results) { //this will check if the query failed or not
 if (mysql_num_rows($results) > 0) {  //this will check if results were returned
    while($copy = mysql_fetch_array($results)) {
       $variable1=$copy['booknum'];
$variable2=$copy['bookgrp'];
$variable3=$copy['booktitle'];
//table layout for results

print ("<tr>");
print ("<td><center>$variable1</center></td>");
print ("<td><center>$variable2</center></td>");
print ("<td><left>$variable3</left></td>");
print ("</tr>");    }
  } else {
    echo "No results returned";
  }
} else {
  echo "Query error: ".mysql_error();
}
mysql_close($con);
?>
</table>    
</center>

Hi, I want to be able to retrieve records from db tables to build an xml file. The problem I am having is that I don't know how to retrieve a value after using foreign key to get appropriate value. You see below I want to make a new attribute to store to var $newAttr.

Code: [Select]
<?php
$doc=new DOMDocument();
mysql_connect("localhost","root");
mysql_select_db("xmlDB");

$edges=mysql_query("SELECT * FROM edge");
while($row=mysql_fetch_assoc($edges)) {
if($row['flag']=='val') {
$curValue=mysql_query("SELECT val FROM value,edge WHERE val.edge_id=edge.edge_id");
if($curRowIsAttribute=mysql_query("SELECT is_Attribute FROM value,edge WHERE value.is_Attribute='Y' AND value.edge_id=edge.edge_id")) {
//create attribute node
$newAttr=$dom->createAttribute();//HELP HERE PLEASE THEN I SHOULD BE ABLE TO COMPLETE NEXT TWO LINES BELOW!

//set attribute value
...

//append attribute to current element
...

}//END IF
}//END IF
}//END BIG WHILE 
?>

Any help much appreciated!

Hi everyone, I am having trouble passing/displaying the values inside of a selected list.
I created a add/remove list using Jquery and I tried to display the values passed using foreach and for loops but it is still not working. The values I am trying to get are $existing_mID[$j], which is inside of the option value attribute.

Please kindly let me know what should I do in order to get the values and I really appreciate your help.

<?php
$selected = $_POST['selectto'];
if(isset($selected))
{
    echo "something in selected<br />";
    for ($i=0;$i<count($selected);$i++)
    echo "selected #1 : $selected[$i]";
    foreach ($selected as $item)
    echo "selected: item: $item";
}
?>

This is the form

Hi

I have coded a drop down menu with php and i am trying to retrieve the data when a user select a option from the menu and the data is retrieved from the database. So far i have tried and nothing is displaying when i tried to process the php form.

Sales.php Page

<form action="saleprocess.php" method="GET">
<?php
echo 'Product Model:';
$query="SELECT * FROM products";
/* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */
$result = mysql_query ($query);
echo "<select name=product_model value=Select>Product Model</option>";
// printing the list box select command
while($rows=mysql_fetch_array($result)){//Array or records stored in $nt

echo "<option name=product_model value='.$rows[product_id].'>$rows[product_model]</option>";
/* Option values are added by looping through the array */
}
echo "</select><br>";
?>
<input type='submit' name='submit' value='Create'></input> <br>
</form>

********************************************************************************
Salesprocess.php page

<?php
include("connect.php");

if(isset($_GET['product_id'])){

$product_id = $_GET['product_id'];


$query = mysql_query("SELECT * FROM products WHERE product_id= $product_id");

while($rows = mysql_fetch_assoc($query))
{
echo 'Product Model<br>';
echo $rows['product_id'];
echo $rows['product_model'];


}
}
?>

Muchly appreciated if someone can help me

Hi all,

I have the following code that generates a table of results from a MySQL query:

$i=1;
        while($arr = mysql_fetch_array($result, MYSQL_NUM))
        {
            $table .= "<tr>" 
                              ."<td width='5px';><input type='checkbox' name='transcheck".$i."'></td>"
                              ."<td id='parent".$i."A'>".$arr[0]."&nbsp;".$arr[1]."</td>"
                              ."<td id='parent".$i."B'>".$arr[2]."</td></tr>"
                              ."<tr style='display:none'><input type='hidden'; name='transemail".$i."'; value='".$arr[9]."'></tr>";
        $i++;
        }
        $table .= "</table>";
echo $table;


As you can see it generates a table containing (amongst other things):
checkboxes:       transcheck1,2........9...etc.
hidden inputs:    transemail1,2........9...etc.

This table is inside a form, so that the above gets posted to another php file. What I now want to do in this 2nd php file, is to retrieve all the checkboxes and hidden inputs and then to display the values of the hidden inputs, where the corresponding checkbox has been checked. So e.g. if transcheck1, transcheck3 and transcheck12 have been checked, then I want to display transemail1, transemail3 and transemail12.

I can see that this should be relatively straightforward, but I'm fairly new to this stuff, could someone pls help me out?

Thanks!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=322859.0

I have code for displaying result from database:

foreach ($_SESSION["products"] as $cart_itm)
        {
           $product_code = $cart_itm["code"];
		   $results = $mysqli->query("SELECT * FROM products WHERE product_code='$product_code' LIMIT 1");
		   $obj = $results->fetch_object(); 

Now, I display data with: $obj->product_name     When I get the list, how to put inline numbers (1 2 3 4 ...)?   1       products1 2       products1 3       products1 4       products1..

I have some php code on view invoice and it's getting all the data I need to from three database tables but for some reason it's not getting the data for one specific column and unsure why

I have done a echo sql and it is echoing the sql query ok and have ran the sql query in phpmyadmin and is displaying the column in phpmyadmin that is not displaying on the php page so am bit confused, below is the coding I have. I took out a lot of it and tried to keep to the relevant parts

<?php
$sql = "SELECT t1.id, t1.invoice_number, DATE_FORMAT(t1.invoice_date,'%d/%m/%Y') AS invoice_date, t1.user_id, t2.invoice_number, t2.service_name, t2.service_price, t3.user_id, t3.customer_name, t3.customer_phone, t3.customer_email, t2.service_name, t2.service_price, t1.invoice_total, t1.balance, t1.notes, DATE_FORMAT(t1.payment_date,'%d/%m/%Y') AS payment_date, t1.payment_method
FROM invoices as t1
LEFT JOIN invoice_products as t2
ON t1.id = t2.invoice_id
LEFT JOIN users as t3
ON t1.user_id = t3.user_id
WHERE t1.user_id = '".$_SESSION['user_id']."' and t1.id = '".$_GET['id']."'";

$result = mysqli_query($connect, $sql);

                if(mysqli_num_rows($result) > 0)
                {
                if($row = mysqli_fetch_array($result))  
                {
                ?>

                Notes: <?php echo $row['notes'];?>

                <?php
                    }
                    }
                    ?>

 

hey i am using a MySql database and i need to create a dynamic HTML table with one of its columns as checkboxes.so i have to create multiple checkboxes.but these checkbox values are to be stored in a mysql table and then later retrieved when form reloads.and depending on previous state when form was submitted, the newly created checkboxes have to be checked in the same manner.so how do i store multiple checkbox values in my table and also how do i retrieve them?
please help.

I am trying to create a code where the user enters the zip code and if found in the database, a location will be retrieved. I am getting two undefined variables as errors. I am still learning the POST and GET method and I fear that is where I am getting something mixed up. I have also attached an image of my DB.

Thank you so much any input is greatly appreciated.

Notice: Undefined variable: address in C:\xampp\htdocs\index.php on line 53

Notice: Undefined variable: zip in C:\xampp\htdocs\index.php on line 54

index.php file code:

 

<?php

     include ('header.php');
     include ('function.php');

     ?>


        <div class="wrapper">
           <div>
               <?php
               echo'<form method="POST" action"'.getLocations($conn).'">
                   <input type="text" name="zip" class="search" placeholder="Zip code"><br>
                   <button type="submit" value="submit" id="submit">Submit</button>
                   </form>';
               getLocations($conn);
              ?>         
           </div>
        </div>
        
        <div>
             <!--foreach($zip as $zip) : -->
            <?php 
                  echo $address['address'];
                  echo $zip['zip']; 
            ?>
        </div>
    
    
 function.php file code:
    
    
    <?php
    
    $dBServername = "localhost";
    $dBUsername = "root";
    $dBPassword = "";
    $dBName = "addresses";
    
    // Create connection
    $conn = mysqli_connect($dBServername, $dBUsername, $dBPassword, $dBName);
    
    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    function getLocations($conn) {
        if (isset($_POST['submit'])){
            
             // Validate Zip code field
            if (!empty ($_POST['zip']) && is_numeric ($_POST['zip'])) {
                
            $zip = (int)$_POST['zip'];
        
            
        $query = "SELECT * FROM locations WHERE zip = '$zip'";
        
        //get the results
        $result = mysqli_query($conn, $query);
        
        //fetch the data
        $zip = mysqli_fetch_all($result, MYSQLI_ASSOC);
        var_dump($zip);
        
        
        mysqli_free_result($result);
        
        //close connection
        mysqli_close($conn);
    
        
       }
    } 
      
    }