PHP - Allowing User Choose From Multiple Rows

I have code written for image uploading, but it doesn't allow multiple images on a single upload, and doesn't re-size.

Anyone willing to share a good upload script that will do the following?:
-Allow multiple image uploads (10+ per submission),
-Re-size images on upload, and
-Rename images.

Thanks
Brett

Hi All,

Can't get this code working. the statement works fine directly on the table, just not when executed from the PHP file:

Code: [Select]
<strong>Multi Update</strong><br>

<?php
$host="localhost"; // Host name
$username="user_name"; // Mysql username
$password="Password"; // Mysql password
$db_name="dbname"; // Database name
$tbl_name="tablename"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT 
  mik1vm_product.product_id,
  mik1vm_product.product_sku,
  mik1vm_product.product_name,
  mik1vm_product.product_in_stock,
  mik1vm_product.product_in_stock_cardiff
FROM $tbl_name";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Product Id</strong></td>
<td align="center"><strong>SKU</strong></td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>In Stock</strong></td>
<td align="center"><strong>In Stock Cardiff</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><? $product_id[]=$rows['product_id']; ?><? echo $rows['product_id']; ?></td>
<td align="center"><input name="product_sku[]" type="text" id="product_sku" value="<? echo $rows['product_sku']; ?>"></td>
<td align="center"><input name="product_name[]" type="text" id="product_name" value="<? echo $rows['product_name']; ?>"></td>
<td align="center"><input name="product_in_stock[]" type="text" id="product_in_stock" value="<? echo $rows['product_in_stock']; ?>"></td>
<td align="center"><input name="product_in_stock_cardiff[]" type="text" id="product_in_stock_cardiff" value="<? echo $rows['product_in_stock_cardiff']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $tbl_name SET product_sku='$product_sku[$i]', product_name='$product_name[$i]', product_in_stock='$product_in_stock[$i]' , product_in_stock_cardiff='$product_in_stock_cardiff[$i]' WHERE product_id='$product_id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:test.php");
}
mysql_close();
?>
The page loads fine, but just doesn't update the DB.

Thanks in advance for any help.

Code: [Select]
- Generation Time: Aug 02, 2010 at 06:22 AM
-- Server version: 5.0.91
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `leapaddemo`
--

-- --------------------------------------------------------

--
-- Table structure for table `rp_user_occupants`
--

CREATE TABLE `rp_user_occupants` (
`occupant_id` int(11) NOT NULL auto_increment,
`occupant_name` varchar(100) NOT NULL,
`occupant_dob` date NOT NULL,
`occupant_relation` varchar(100) NOT NULL,
`occupant_ssn` varchar(100) NOT NULL,
`rp_user_id` int(11) NOT NULL,
PRIMARY KEY (`occupant_id`),
KEY `rp_user_occupants_ibfk_1` (`rp_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;

--
-- Dumping data for table `rp_user_occupants`
--

INSERT INTO `rp_user_occupants` VALUES(1, 'sanju', '2010-06-04', 'myself', '123654', 1);
INSERT INTO `rp_user_occupants` VALUES(2, 'jinson', '2010-07-07', 'frnd', '234245', 2);
INSERT INTO `rp_user_occupants` VALUES(3, 'james', '2010-07-16', 'frnd', '234245', 2);
INSERT INTO `rp_user_occupants` VALUES(4, 'sanju', '2010-07-30', 'friend', '789', 55);
INSERT INTO `rp_user_occupants` VALUES(5, 'james', '2010-07-30', 'friend', '852', 55);
INSERT INTO `rp_user_occupants` VALUES(6, 'james', '2010-07-09', 'friend', '789', 56);
INSERT INTO `rp_user_occupants` VALUES(7, 'syam', '2010-07-16', 'friend', '852', 56);
INSERT INTO `rp_user_occupants` VALUES(8, 'jinson', '2010-07-16', 'friend', '456', 56);
INSERT INTO `rp_user_occupants` VALUES(9, 'james', '2010-07-02', 'friend', '789', 58);
INSERT INTO `rp_user_occupants` VALUES(10, 'syam', '2010-07-10', 'friend', '852', 58);
INSERT INTO `rp_user_occupants` VALUES(11, 'asdas', '2010-07-29', 'asdas', '', 60);
INSERT INTO `rp_user_occupants` VALUES(12, 'sdfgd', '2010-07-30', 'sdfgdf', '', 60);
INSERT INTO `rp_user_occupants` VALUES(13, 'syam', '2010-07-28', 'friend', '111111111', 61);
INSERT INTO `rp_user_occupants` VALUES(14, 'james', '2010-07-28', 'friend', '222222222', 61);
INSERT INTO `rp_user_occupants` VALUES(15, 'jinson', '2010-07-15', 'friend', '333333333', 61);
INSERT INTO `rp_user_occupants` VALUES(16, 'james', '2010-07-28', 'friend', '111111111', 62);
INSERT INTO `rp_user_occupants` VALUES(17, 'syam', '2010-07-29', 'friend', '222222222', 62);
INSERT INTO `rp_user_occupants` VALUES(18, 'jinson', '2010-07-29', 'friend', '333333333', 62);
INSERT INTO `rp_user_occupants` VALUES(19, 'siva', '1977-07-07', 'wewee', '111111111', 59);
INSERT INTO `rp_user_occupants` VALUES(20, 'ASIT', '2002-07-11', 'FRIEND', '619072345', 63);
INSERT INTO `rp_user_occupants` VALUES(21, 'Arati', '2010-07-17', 'Married', '619052731', 63);
INSERT INTO `rp_user_occupants` VALUES(22, 'aaaaaa', '2010-07-29', 'aaaaaaaa', '111111111', 64);
INSERT INTO `rp_user_occupants` VALUES(23, 'aaaaa', '2010-07-14', 'aaaaaaaaaaaa', '111111111', 64);
INSERT INTO `rp_user_occupants` VALUES(24, 'bbbbbbbbb', '2010-07-30', 'bbbbbbbbbbb', '111111111', 64);
INSERT INTO `rp_user_occupants` VALUES(25, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(26, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(27, 'james', '1986-04-22', 'friend', '3433434', 2);
INSERT INTO `rp_user_occupants` VALUES(28, 'james', '2010-07-06', 'friend', '45645456', 2);
INSERT INTO `rp_user_occupants` VALUES(29, 'syam', '2010-07-13', 'dfg', '545454', 2);
INSERT INTO `rp_user_occupants` VALUES(30, 'jhhgj', '2010-07-13', 'hgj', '657677657', 2);
INSERT INTO `rp_user_occupants` VALUES(31, 'syam', '2010-07-30', 'friend', '111111111', 88);
INSERT INTO `rp_user_occupants` VALUES(32, 'james', '2010-07-30', 'friend', '111111111', 88);
INSERT INTO `rp_user_occupants` VALUES(33, 'test occupant', '2000-07-21', 'test', '000', 89);
INSERT INTO `rp_user_occupants` VALUES(34, 'test occupant', '2010-07-16', 'test relation', '000', 89);
INSERT INTO `rp_user_occupants` VALUES(35, 'james', '2010-07-07', 'fff', '222222222', 2);
INSERT INTO `rp_user_occupants` VALUES(36, 'james', '2010-07-01', 'fgdfg', '123456789', 2);
INSERT INTO `rp_user_occupants` VALUES(37, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(38, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(39, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(40, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(41, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(42, 'werwerw', '2010-07-15', 'esdf', '23423232', 82);
INSERT INTO `rp_user_occupants` VALUES(43, 'dhoni', '2010-07-29', 'dhoni', '222222222', 90);
INSERT INTO `rp_user_occupants` VALUES(44, 'dhoni', '2010-07-29', 'dhoni', '333333333', 90);
INSERT INTO `rp_user_occupants` VALUES(45, 'ertertert', '2010-07-15', 'fff', '345453455', 82);
INSERT INTO `rp_user_occupants` VALUES(46, 'dgfg', '2010-07-15', 'dfgdf', '444332222', 91);
INSERT INTO `rp_user_occupants` VALUES(47, 'dhoni', '2010-07-28', 'frnd', '222222222', 92);
INSERT INTO `rp_user_occupants` VALUES(48, 'dhoni', '2010-07-28', 'frnd', '222222222', 92);
INSERT INTO `rp_user_occupants` VALUES(49, 'fdgdfg', '2010-08-06', 'fgdg', '233223', 91);
INSERT INTO `rp_user_occupants` VALUES(50, 're', '2010-07-31', 'errrre', '223422342', 91);

I want to edit these fields based on 'rp_user_id' field. I have to show them and update them to database. How. Please help me.

I have ran this code before and it worked but not it won't update.  Can anyone see what I am doing wrong?



Code: [Select]
<?
if(isset($_POST[sort_invest]))   {   // if form was submitted
 
$id = $_POST['sel_record'];
$sort = $_POST['sort'];

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

$sql = "UPDATE invest SET id='$id[$i]', sort='$sort[$i]' WHERE id='$id[$i]'";

$sql_result = mysql_query($sql,$con)
or die (mysql_error());
}
  }

// if form was submitted or if it came from another page
if (isset($_POST['order_invest']) || isset($_POST['sort_invest'])) {

?>       
      <p><strong>Order Invest</strong></p>
     
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">     
<?   
$sql = "SELECT id, sort, title FROM invest ORDER BY sort ASC";
$sql_result = mysql_query($sql,$con) or die(mysql_error());

     while ($row = mysql_fetch_array($sql_result)) {   
            $id = $row["id"];     
            $title = $row["title"];
            $sort = $row["sort"];
?>
          <input type="hidden" name="sel_record[]" value="<? echo "$row[id]"; ?>">

<table width="545" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="69"><input type="text" name="sort[]" value="<? echo "$row[sort]"; ?>" size="3"></td>
    <td width="476"><? echo "$row[title]"; ?></td>
  </tr>
</table>
 
<br>
<?
}
  }
?>

            <input name="sort_invest" type="submit" value="Sort">
      </form>

Hey All,

I tried seraching, but I'm not sure what exactly to search for. Here's what I need to do, and any push in the right direction would be great:

I have a PHP form, with the Following:

Text Box: Student ID
Checkboxes for Activities

What I need to do is somehow loop through and make a new row for each activity. Example, if I entered Student ID 105 and Activities are Basketball, Baseball, and Chess Team, I need three different rows in the database each listing the individual activity and the student ID.

Any suggestions? I know how to do this if it was one entry (radio buttons) but want to be able to enter multiple rows at a time. Thanks!

I am running a query to get a certain student's quiz results from all attempts and print one after the other in a simple table for now. The student is designated by an email address. I need results from all of the rows containing this particular email. The issue I think I am having is that when I use "WHERE" and specify an email address that exists many times in the table it isn't storing the variable correctly. Here is code below that I cannot get working right.

When I try to print these variables as a test to see if they are working I get nothing. No errors either. I have checked all names, spellings, and capitalization about 5 times. Thanks for looking at it.

Code: [Select]
$QuizQuery = mysql_query("SELECT * FROM Quiz_Results WHERE Email = '".$_SESSION['UserEmail']."' AND Quiz_Name = 'M1'")
or die(mysql_error());

$i=1;

while ($QuizResults = mysql_fetch_array($QuizQuery)){

$UserEmail = $QuizResults['Email'];
$Score = $QuizResults['Score'];
$Date = $QuizResults['Date_Taken'];


echo "<table width='650' border='1'><tr><td>";
echo "Attempt #".$i."<br></td><td>Sco ".$Score."</td><td>";
if($QuizResults['Pass'] == "PASSED"){
echo "Passed";
}
else {
echo "Failed";
}
echo "</td><td>Date Taken: ".$Date."</td></tr></table>";



$i++;
}

The code below kind of works, I don't get any errors. It has 2 problems; it only inserts the second row of data I get nothing for the first row. It also does not insert the 4id correctly I just get 1 instead of the actually user id number.

I'd appreciate some help, been trying to hack this out for a couple hours.


Code: [Select]
<?php
// Begin the script for this page
$id = $_SESSION['id'];
if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form

} else {
//Assign each array to a variable
$id = $_SESSION['id'];
$store = $_POST['store'];
$item = $_POST['item'];
$itemprice = $_POST['itemprice'];
$itemnumber = $_POST['itemnumber'];
$couponvalue = $_POST['couponvalue'];

$limit = count($id);

for($i=0;$i<$limit;$i++){
$id[$i] = $id[$i];
$store[$i] = check_input($store[$i]);
$item[$i] = check_input($item[$i]);
$itemprice[$i] = check_input($itemprice[$i]);
$itemnumber[$i] = check_input($itemnumber[$i]);
$couponvalue[$i] = check_input($couponvalue[$i]);
}

$query = "INSERT INTO `item` (user_id, store, item, itemprice, itemnumber, couponvalue) VALUES ('".$id[$i]."','".$store[$i]."', '".$item[$i]."', '".$itemprice[$i]."', '".$itemnumber[$i]."', '".$couponvalue[$i]."')";

if (!mysql_query($query,$link)){
die('Error: ' . mysql_error());
} else {
echo "$row record added";
}
}

?>
<div class="pageContent">
    <div id="main">
<div class="container">
<form action="" method="post">
<table>
<tr>
<input type="text" name="id[]" id="id[]" value="<?php echo $_SESSION['id'];?>" />
<td><DIV CLASS="p2"><center><b>Store</b></center></div>
<input type="text" name="store[]" id="store[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Item</b></center></div>
<input type="text" name="item[]" id="item[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Item Price</b></center></div>
<input type="text" name="itemprice[]" id="itemprice[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Item Number</b></center></div>
<input type="text" name="itemnumber[]" id="itemnumber[]" size="15" maxlength="255"/></td>
<td><DIV CLASS="p2"><center><b>Coupon Value</b></center></div>
<input type="text" name="couponvalue[]" id="couponvalue[]" size="15" maxlength="255"/></td>
</tr>
<tr>
<input type="text" name="id[]" id="id[]" value="<?php echo $_SESSION['id'];?>" />
<td><input type="text" name="store[]" id="store[]" size="15" maxlength="255"/></td>
<td><input type="text" name="item[]" id="item[]" size="15" maxlength="255"/></td>
<td><input type="text" name="itemprice[]" id="itemprice[]" size="15" maxlength="255"/></td>
<td><input type="text" name="itemnumber[]" id="itemnumber[]" size="15" maxlength="255"/></td>
<td><input type="text" name="couponvalue[]" id="couponvalue[]" size="15" maxlength="255"/></td>
</tr>
</table>
<input type="submit" name="submit" value="Submit Item">
</form>
</div>
</div>
</div>

hey can someone advice me on how to make my update script update multiple rows.

here's what i've got so far:
update.php

<?php
require('connect.php');

$update = mysql_query("SELECT DISTINCT rideName FROM ride ORDER BY rideName DESC" );
$numrows = mysql_num_rows($update);

echo "<form action='mysql_update.php' method='POST'>
<select name='updateRide' >";


while ($row=mysql_fetch_assoc($update))
{
                        #$rideID = $row ['rideID'];
                        $rideName = $row ['rideName'];
                        #$seatNumber = $row ['seatNumber'];
                        #$time = $row ['time'];
                        #$price = $row ['price'];


echo "<option value='$id'> $rideName </option>";



}
echo "</select>
<input type='text' name='tochange'> 
<input type='submit' name='submit' value='change'>      
</form>";
?>


and now the handler script: mysql_update.php

<?php
require ('connect.php');

$updateRide=$_POST['updateRide'];
$tochange=$_POST['tochange'];

if ($updateRide&&$tochange)
{
$change = mysql_query("UPDATE ride SET rideName='$tochange'
WHERE $id='updateRide'");

}

?>
 




When I try this I get nothing, no changes. In the table there is 3 distinct rideNames each have more than 20 rows. Is there a way using the drop down box and ext field like i Have to update all of the distinct rideNames in the table?

Thanks.

So here is what I a trying to do:

Code: [Select]

<?php

/**
 * @author 
 * @copyright 2010
 */
$res = mysql_query("SELECT * FROM `planetsTable` WHERE `section` = '1' LIMIT 9 ASC");
while($row = mysql_fetch_array($res)){ ?>
 
 
            <li>
            <span id="sun">Solar System Star</span>
            <p>The Sun is a star, a hot ball of glowing gases at the heart of our solar system. Its influence extends far beyond the orbits of distant Neptune and Pluto. Without the Sun's intense energy and heat, there would be no life on Earth. And though it is special to us, there are billions of stars like our Sun scattered across the Milky Way galaxy.</p>
            </li>
 
        <li>
            <span id="mercury"><?php echo $row[0]['name']; ?></span>
            <p>Sun-scorched Mercury is only slightly larger than Earth's Moon. Like the Moon, Mercury has very little atmosphere to stop impacts and it is covered with craters. Mercury's dayside is super heated by the Sun, but at night temperatures drop hundreds of degrees below freezing. Ice may even exist in craters. Mercury's egg-shaped orbit takes it around the Sun every 88 days.</p>

            </li>
           
            <li>
            <span id="venus"><?php echo $row[1]['name']; ?></span>
            <p>Venus is a dim world of intense heat and volcanic activity. Similar in structure and size to Earth, Venus' thick, toxic atmosphere traps heat in a runaway 'greenhouse effect.' The scorched world has temperatures hot enough to melt lead. Glimpses below the clouds reveal volcanoes and deformed mountains. Venus spins slowly in the opposite direction of most planets.</p>
            </li>
           
            <li>
            <span id="earth"><?php echo $row[3]['name']; ?></span>

            <p>Earth is an ocean planet. Our home world's abundance of water - and life - makes it unique in our solar system. Other planets, plus a few moons, have ice, atmospheres, seasons and even weather, but only on Earth does the whole complicated mix come together in a way that encourages life - and lots of it.</p>
            </li>
           
            <li>
            <span id="mars"><?php echo $row[4]['name']; ?></span>
            <p>Though details of Mars' surface are difficult to see from Earth, telescope observations show seasonally changing features and white patches at the poles. For decades, people speculated that bright and dark areas on Mars were patches of vegetation, that Mars could be a likely place for life-forms, and that water might exist in the polar caps. When the Mariner 4 spacecraft flew by Mars in 1965, many were shocked to see photographs of a bleak, cratered surface. Mars seemed to be a dead planet. Later missions, however, have shown that Mars is a complex member of the solar system and holds many mysteries yet to be solved.</p>
            </li>
           
            <li>

            <span id="jupiter"><?php echo $row[5]['name']; ?></span>
            <p>The most massive planet in our solar system, with four large moons and many smaller moons, Jupiter forms a kind of miniature solar system. Jupiter resembles a star in composition. In fact, if it had been about 80 times more massive, it would have become a star rather than a planet.</p>
            </li>
           
            <li>
            <span id="saturn">Saturn</span>
            <p>Saturn was the most distant of the five planets known to the ancients. Like Jupiter, Saturn is made mostly of hydrogen and helium. Its volume is 755 times greater than that of Earth. Winds in the upper atmosphere reach 500 meters (1,600 feet) per second in the equatorial region. These super-fast winds, combined with heat rising from within the planet's interior, cause the yellow and gold bands visible in the atmosphere.</p>
            </li>

           
            <li>
            <span id="uranus">Uranus</span>
            <p>The first planet found with the aid of a telescope, Uranus was discovered in 1781 by astronomer William Herschel. The seventh planet from the Sun is so distant that it takes 84 years to complete one orbit.</p>
            </li>
           
            <li>
            <span id="neptune">Neptune</span>
            <p>Nearly 4.5 billion kilometers (2.8 billion miles) from the Sun, Neptune orbits the Sun once every 165 years. It is invisible to the naked eye because of its extreme distance from Earth. Interestingly, the unusual elliptical orbit of the dwarf planet Pluto brings Pluto inside Neptune's orbit for a 20-year period out of every 248 Earth years</p>

            </li>
           
            <li>
            <span id="pluto">Pluto</span>
            <p>Tiny, cold and incredibly distant, Pluto was discovered in 1930 and long considered to be the ninth planet. But after the discoveries of similar intriguing worlds even farther out, Pluto was reclassified as a dwarf planet. This new class of worlds may offer some of the best evidence of the origins of our solar system.</p>
            </li>
        </ul>
   
<?}

?>

What I need to know is if this is possible and if so how would I got about doing this?
Code: [Select]
<?php 
$row['0']['name']; // Main Issue.
?>
McBryver

Only the last row will update when I submit.

I have this form (and one nerve left):


<form action="" method="post" >

echo"
<input style=\"text-align:center\" type=\"text\" name=\"linkorder\" value=\"".$row['order']."\" />
<input type=\"hidden\" name=\"id\" value=\"".$row['id']."\"/>
";
<input type="submit" name="updateorder" value="Save Order" />
</form>


On Submit:


if (isset($_POST['updateorder'])){

connect();
$changeorder = mysql_unbuffered_query("update links set `order` = '".$_POST['linkorder']."' where id = '".$_POST['id']."'") or die(mysql_error());

}



I was going put my fist through the monitor but then I remembered I could get help here.

Thank you!

It's late and I'm not thinking straight. I'm posting this question. Hopefully I get a reply in the morning.

I have two tables.

TABLE 1 - PRODUCTS

TABLE 2 - LIKES

I am a User who has posted these products. I want to find out ALL the Likes I have received for all my products. Here is my code.

$find_products = $db->prepare("SELECT product_id FROM products WHERE user_id = :user_id");
$find_products->bindParam(':user_id', $my_user_id);
$find_products->execute();
$result_products = $find_products->fetchAll(PDO::FETCH_ASSOC);
if(count($result_products) > 0) {
  foreach($result_products as $row) {
    $product_id = $row['product_id'];

    $find_likes = $db->prepare("SELECT like_id FROM product_likes WHERE product_id = :product_id");
    $find_likes->bindParam(':product_id', $product_id);
    $find_likes->execute();
    $result_likes = $find_likes->fetchAll(PDO::FETCH_ASSOC);
    if(count($result_likes) > 0) {
      $get_likes  = 0;
      foreach($result_likes as $row) {
        $get_likes++;
      }
    }
  }
}

The issue with the above code is that It only shows the Likes if I echo inside the foreach loop. And it'll show combined Likes from each of my products. But I want to actually combine ALL the Likes from ALL the products and be able show them as a single number, outside of the foreach loop.

How do I do that?

Edited August 17, 2019 by imgrooot

Hi, I'm very new to these forums and php alike.  I've been working on this bit of code for weeks now.  I've written numerous versions and made endless revisions; trying pieces from many similiar source and well, it's still not quite working out for me.

The form I've been trying to finish will have multiple rows. The user will input values specific to each row, but I'm trying to make it so that each row is synonymous with each other in regard to the database table. Like an order form, an inventory form, or a roster. I'd really like to make this code work out because I can think of numerous applications for it's use. I'm sure others could use it for even more.

So, as you see; the html code represents the table that contains the form. Currently, I only have five of these rows in the form, but would like for anybody using the code to be able to add in code for as many rows in the table as needed.
Code: [Select]
<html>

<head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<FORM action="post_multiple.php" method="POST">
<table width="80%" border="1">
  <tr>
    <td>Vendor</td>
    <td>Item Description</td>
    <td>Quantity</td>
    <td>Price</td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor" >
<option value="other1">other1</option>
<option value="other2">other1</option>
<option value="other3">other3</option>
<option value="other4">other4</option>
<option value="other5">other5</option>
</select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
</table>
<input type="submit" name="Submit" value="Submit" />
</FORM>

</body>
</html>

In the php script I've tried using the count, loop, if, several others functions to try to get it to insert all the completed rows from the form into the table but just can't seem to get it to work out.  Anyways, here's a representation of what i'd like to achieve.  Not necessarily the code I've written trying to accomplish this, I'd have to upload a book if that were the case.

<?php 
ini_set('display_errors','On'); 
error_reporting(E_ALL); 

$host="localhost"; // Host name  
$username="root"; // Mysql username  
$password="password"; // Mysql password  
$db_name="testing"; // Database name  
$tbl_name="test_multiple"; // Table name 

// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect");  
mysql_select_db("$db_name")or die("cannot select DB"); 

//declarations 
$vendor = $_POST['vendor']; 
$description = $_POST['description']; 
$quantity = $_POST['quantity']; 
$price = $_POST['price']; 

// Check if button name "Submit" is active, do this  
$sql1="INSERT INTO $tbl_name (vendor, description, quantity, price) VALUES ('".$vendor."', '".$description."', '".$quantity."', '".$price."')"; 
$result1=mysql_query($sql1); 

mysql_close(); 
?>


If anybody can suggest where I need to go with that, that would be great.  Like I said above, I've tried about everything I could find any reason to from forum threads I had found in google searches and whatnot.  Also, if there is a good article, link or tutorial that would address this that anybody knows about that would be great.  However, I'm not looking for a link to a product or plugin that will do this stuff for me.  I'm trying to get halfway decent at php and would like to have working code for myself to build upon, modify, and learn from.  Any help is greatly appreciated!!!!

Hello everyone,

Once again i need your help this time i want to know that, if I inserting multiple row by single insert query with the help of foreach (loop) then how to insert another cell value according to the name wise

so that's way i send my hole code to you.

<?php
                            //include configuration file for connection
                            include_once('config.php');
                            $sql = "select * from CLASS_STUDENT ORDER BY STUDENT_NAME ASC ";
                            $result=mysql_query($sql);
                            $count=mysql_num_rows($result);
                         ?>
                         <form name="form1" method="post" action="">
                            <table style="text-align: left; padding: 5px;" cellpadding="0px" cellspacing="0px">
                           <tbody>
                              <tr>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Name</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Class</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Section</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Current Date</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Present</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Absent</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Comment</th>
                              </tr>
                              <?php
                                 while($rows=mysql_fetch_array($result))
                                 {
                              ?>                                                   
                              <tr>                                 
                                 <td class="table1">
                                    <? $id[] = $rows['STUDENT_NAME']; ?><? echo $rows['STUDENT_NAME'];?>
                                 </td>
                                 <td class="table1">
                                    <input name="class[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['STUDENT_CLASS']; ?>">
                                 </td>     
                                 <td class="table1">
                                    <input  name="section[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['STUDENT_SECTION']; ?>">
                                 </td>
                                 <td class="table1">
                                    <input name="date[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['PRESENT_DATE']; ?>">
                                 </td>                                                                                 
                                 <td id="present">
                                    <input type="radio" name="present[<? echo $rows['STUDENT_NAME']; ?>]" checked="checked" value="PRESENT">Present           
                                 </td>
                                 <td id="absent">                                   
                                    <input type="radio" name="present[<? echo $rows['STUDENT_NAME']; ?>]" value="ABSENT">Absent
                                 </td>                             
                                 <td style="text-align: left; padding: 5px; border: 1px #000000 solid; height: 33px;">
                                    <input name="comment[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['COMMENT'];?>">
                                 </td>                                                   
                              </tr>
                              <?php }?>
                              <tr>
                                 <td colspan="7" style="vertical-align:middle; text-align: center;"><br><br>                                   
                                    <input id="Submit" type="submit" name="Submit" value="Insert" style="text-align: center; background-color: #000000; color: #ffffff; border: 1px #000000 solid;">
                                 </td>
                              </tr>                                                                                 
                           </tbody>
                        </table>
                     </form>   
                     <?php
                        if(isset($_POST['Submit']))
                        {
                           foreach($_POST['present'] as $id => $value)
                           {
                              $class=$_POST['class'];
                              $section=$_POST['section'];
                              $date=$_POST['date'];
                              $comment=$_POST['comment'];                                   
                               $sql = "INSERT INTO ATTENDANCE(STUDENT_NAME, STUDENT_CLASS, STUDENT_SECTION, PRESENT_DATE, STUDENT_PRESENT, COMMENT) VALUES ('".$id."', '$class[$value]', '$section[$value]', '$date[$value]', '".$value."', '$comment[$value]') ";
                               $result = mysql_query($sql);                           
                           }
                        }
                        if($result)
                        {
                            header("location:Tea_home.php");                                                     
                        }
                        else
                        {
                           //print_r ($_POST);
                           echo "Your entry is not completed at this time.............";
                        }
                     ?>


My result is comming just like that

STUDENT_ID ||   STUDENT_NAME || STUDENT_CLASS  ||   STUDENT_SECTION  ||   PRESENT_DATE ||   STUDENT_PRESENT    ||COMMENT
231    ||   PRASHANT KUMAR   ||                     ||                       || 1/1/0001 12:00:00 AM       ||         ABSENT                ||   
230    ||   JYOTI NANDA            ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT        ||   
229    ||   TARUN NANDA          ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT         ||   
228    ||   RAVI KUMAR             ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT         ||   
227    ||   RAJIV KUMAR            ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT           ||
226    ||   PRASHANT KUMAR    ||                     ||                       || 1/1/0001 12:00:00 AM       ||            ABSENT           ||
225    ||   JYOTI NANDA            ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT           ||



can you help me where i am writing wrong code

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

The variable is $alderaanfleetalt  and consists of:

Code: [Select]
$fleetname = "FleetName";
$shipname = "Ship Name";
Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

Code: [Select]
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

Code: [Select]
do{
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet));

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

Thank you

I am trying to update multiple rows in a mysql db through php but I am getting an error message in this line:

$size = count($_POST['uid']);

My db field names are uid (which autoincrements and does not need to be updated), fname, lname and email fields. Here is a link for the project I need to develophttp://users.cis.fiu.edu/~vagelis/classes/COP5725/project.htm

Here is the content for the first page:

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head>
<style type="text/css">

body {
margin:50px 0px; padding:0px;
text-align:center;
font:13px Tahoma,Geneva,sans-serif
}

#content {
width:1000px;
margin:0px auto;
text-align:left;
padding:15px;
border:1px dashed #333;
background-color:#eee;
}
</style>
<link rel="icon" href="http://www.mysite.com/favicon.ico" type="image/vnd.microsoft.icon" />
</head>
<body>
<div id='content'><h3><center>Update Information</center></h3>
<?php

//create a connection
$connection = mysql_connect("localhost","root","r2d2c3po");

//test the connection
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
//select database to use
mysql_select_db("music_social_network", $connection);
//setup query
$sql = "SELECT * FROM `user` ORDER BY uid";
//get results from query or die
$result = mysql_query($sql, $connection) or die(mysql_error());
//fetch rows from query
$rows = mysql_fetch_assoc($result);
?>

<?php 

// find out how many records there are to update 
$size = count($_POST['uid']); 

// start a counter in order to number the input fields for each record 
$i = 0; 
print "<table width='100%' border='0' cellspacing='1' cellpadding='0'><tr><td>"; 
// open a form 
print "<form name='namestoupdate' method='post' action='update.php'> 
<table width='100%' border='0' cellspacing='1' cellpadding='1'><tr> 

<td align='center'><strong>User ID</strong></td> 
<td align='center'><strong>First Name</strong></td> 
<td align='center'><strong>Last Name</strong></td> 
<td align='center'><strong>Email</strong></td> 
</tr>\n"; 

// start a loop to print all of the users with their information 
// the mysql_fetch_array function puts each record into an array. each time it is called, it moves the array counter up until there are no more records left 
while ($Update = mysql_fetch_array($result)) { 
print "</tr>\n"; 
// assuming you have three important columns (the index (id), the course name (course), and the book info (bookinfo)) 
// start displaying the info; the most important part is to make the name an array (notice bookinfo[$i]) 
print "<td align='center'><p>{$Update['uid']}</p></td>\n"; 
print "<td align='center'><input type='text' fname='fname[$i]' value='{$Update['fname']}' /></td>"; 
print "<td align='center'><input type='text' size='40' lname='lname[$i]' value='{$Update['lname']}' /></td>\n"; 
print "<td align='center'><input type='text' size='40' email='email[$i]' value='{$Update['email']}' /></td>\n"; 
print "</tr>\n"; 
// add 1 to the count, close the loop, close the form, and the mysql connection 
++$i; 
} 
print "<tr> 
<td colspan='4' align='center'><input type='submit' value='submit' />"; 
print "</td> 
</tr> 
</table> 
</td> 
</tr> 
</form> 
</table>"; 
mysql_close($connection); 
?><br /><br /><div></body>
</html>

here is the content for the update.php page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head>
<style type="text/css">

body {
margin:50px 0px; padding:0px;
text-align:center;
font:13px Tahoma,Geneva,sans-serif
}

#content {
width:1000px;
margin:0px auto;
text-align:left;
padding:15px;
border:1px dashed #333;
background-color:#eee;
}
</style>
<link rel="icon" href="http://www.mysite.com/favicon.ico" type="image/vnd.microsoft.icon" />
</head>
<body>
<div id='content'><h3><center>Success! </center></h3>
<table width='100%' border='0' cellspacing='1' cellpadding='0'><tr><td>


<table width='100%' border='0' cellspacing='1' cellpadding='1'>
<tr>

<td align='center'><strong>User ID</strong></td>
<td align='center'><strong>First Name</strong></td>
<td align='center'><strong>Last Name</strong></td>
<td align='center'><strong>Email</strong></td>
</tr>
<?php 

//create a connection
$connection = mysql_connect("localhost","root","r2d2c3po");

//test the connection
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
//select database to use
mysql_select_db("music_social_network", $connection);
//setup query
$sql = "SELECT * FROM `user` ORDER BY uid";
//get results from query or die
$result = mysql_query($sql, $connection) or die(mysql_error());
//fetch rows from query
$rows = mysql_fetch_assoc($result);




// find out how many records there are to update 
$size = count($_POST['uid']); 

// start a loop in order to update each record 
$i = 0; 
while ($i < $size) { 
// define each variable 
$uid = $_POST['uid'][$i]; 
$fname = $_POST['fname'][$i]; 
$lname = $_POST['lname'][$i]; 
$email = $_POST['email'][$i]; 

// do the update and print out some info just to provide some visual feedback 

$query = "UPDATE `user` SET `fname` = '$fname', `lname` = '$lname', `email` = '$email' WHERE `uid` = '$uid' "; 
mysql_query($sql) or die ("Error in query: $query"); 
print " 

</tr> 
<td align='left'><p>$uid</p></td> 
<td align='left'>$fname</td> 
<td align='left'>$fname</td> 
<td align='left'>$lname</td> 
</tr> 
"; 
++$i; 
} 
mysql_close($connection); 
?>
<tr>
<td colspan='4' align='center'>
</td>
</tr>
</table>
</td>
</tr>

</table></div></body></html>

Mod edit: [code] . . . [/code] tags added.