PHP - Insert Table As Single Cell Per Row

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

I am having a problem trying to show if cell is empty echo one thing if empty and starttime if there is one:

Code: [Select]
if(isset($rown['starttime'])) {
          echo "Add Day";
             } else {
          echo $rown['starttime'];
             }

This topic has been moved to JavaScript Help.

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

This topic has been moved to HTML Help.

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

Hi guys i have another question about my shopping cart.   I have in my sql database table called products. It consist of 4 columns (product_id, description, quantity, price). Now on my index page, I want to call just one product from cell, which would have special price. But i don't know how to call one single product.   So my code looks like that:

 <?php
			
			$sql="SELECT product_id FROM Products";
			$query=mysql_query($sql);
			$row=mysql_fetch_array($query);
			
			
	 ?><table >
          
	 
	 				<tr><img src="Images/Image.jpg" width="380" height="300" /> </tr>
                    <tr>
						
						
						<td><a href="index.php?page=index&action=add&id=<?php echo $row['product_id']?>">Add to cart</a></td>
						
						</tr>
    <?php
			
		
     ?>
        </table>
       

This code display me first product but i would like to call 3 product how would i do that, so i have 6 products and i would like to call product N.3 to my index page. My code calls the first one, how would it call the third.

how to format only one specific row based on the value of  one cell in a row?

$result = mysql_query(select bal,  etc. etc ..query )

while($row = mysql_fetch_assoc($result))

echo "<tr>";

echo "<td>" . $row['Account'] . "</td>";

 echo "<td>" . $row['licence'] . "</td>";

 echo "<td>" . $row['own'] . "</td>";

 echo "<td>" . $row['bal'] . "</td>";

  echo "</tr>";

Would appreciate help on how to format only the $row['bal'] output to red colour IF bal >5000

Thanks

This topic has been moved to Third Party PHP Scripts.

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

Trying to run this function so it displays the generated image in a table cell -

Code: [Select]
<?php 
function imgsecuregen($size = 6){ 

$width = 11*$size; 
$height = 25; 

$string = ""; 
for($i = 1; $i <= $size; $i++){ 
$string .= rand (0,9).""; 
} // for 

$im = ImageCreate($width, $height); 
$bg = imagecolorallocate($im, 102, 102, 102);  // background
$black = imagecolorallocate($im, 0, 255, 0);   // text
$grey = imagecolorallocate($im, 102, 102, 102);    // border 
imagerectangle($im,0, 0, $width-1, $height-1, $grey); 
imagestring($im, 5, $size, 5, $string, $black); 
imagepng($im); 
imagedestroy($im); 
} 

imgsecuregen(8);  // string length

?>

Works if I load it directly, but not in a <td>.
 

Hi

I have a table that populated by a recordset, and wondered whether is was possible to make a row background colour = red where a particular cell = some text?

I have been searching around and not managed to find anything of use.

Any help would be appreciated.

Image name will come from database.
It can be displayed in divs or table cells.
Which is better using divs or table cells?
Can anyone post sample code?
http://img28.imageshack.us/i/44233003.png/

Hi,

I need to compare records in a table based on the 'datetime' field, like if the difference between time is less than 15min.

need to combine the records(rows) as a single resultant row until the time difference between them  is less than 15min and when a record's time difference is >15min that should return as another row and so on. Please find following sample table and the required output format

Sample Table:

Code: [Select]
ID NAME DATETIME
1   aaa    2011-10-10 06:30:00
2   bbb    2011-10-10 06:33:00
3   ccc    2011-10-10 06:38:00
4   ddd    2011-10-10 06:40:00
5   eee    2011-10-10 07:10:00
6   ffff    2011-10-10 07:14:00
7   sss    2011-10-10 08:16:00
8   jjj    2011-10-10 08:26:00
9   kkk    2011-10-10 08:28:00
10  mm    2011-10-10 09:46:00
11  ppp    2011-10-10 09:49:00
12  qqq    2011-10-10 09:52:00


Output Needed :

Code: [Select]
IDs START DATETIME END DATETIME
1,2,3,4 2011-10-10 06:30:00 2011-10-10 06:40:00
5,6 2011-10-10 07:10:00                      2011-10-10 07:14:00
7,8,9 2011-10-10 08:16:00 2011-10-10 08:28:00
10,11,12 2011-10-10 09:46:00                      2011-10-10 09:52:00

You can see 1st row in the output table having IDs 1,2,3,4 coz the time difference between them is less than 15minutes (it doesn't means time difference between start and end; it is actually the  time difference between current record and previous one ; ie; ID-1 and ID-2 have difference less than 15min and ID-2 & ID-3 have difference less than 15min and ID-3 & ID-4 have difference less than 15min, so those 4 records combine together as a single row also shows their start time and end time. Then you can see diff between ID-4 and ID-5 is greater than 15 min so it should display as new row, and so on)

How can I acheive above Output with mysql query ??

Please help..

When I echo out my variable in the php file it works fine but when I put the variable in a table cell it doesn't echo out. 
 

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

I have a stdClass Object array with nested User arrays as a value that I would like to display in a table cell.

I am struggling and have exhausted a lot of time. I am hoping to get a shove in the right direction if possible.

The image below will show what I am trying to do.

 

$someArray = json_decode($token_result);

foreach ($someArray as $key => $value) {
    $combined[] =
        "<tr><td>" .
        $value->customer .
        "</td><td>" .
        $value->city .
        '</td>
           <td>' .
        $value->state .
        "</td><td>" .
        $value->zipcode .
        '</td>
           <td>' .
        $value->totalUsers .
        "</td><td>" .
        $value->totalActiveUsers .
        "</td><td>" .
        $value->totalInActiveUsers .
        '</td><td>
           <a href="">' .
        $value->users .
        "</a></td></tr>";
}

foreach ($combined as $value) {
    print $value;
}

Here is what my Array and Objects look like

Array
(
    [0] => stdClass Object
        (
            [customer] => SWSH
            [city] => Thomasville
            [state] => GA
            [zipcode] => 31792
            [totalUsers] => 6
            [totalActiveUsers] => 6
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => xxx
                            [lastName] => xxx
                            [phoneNumber] => 
                            [userName] => cb_igwrth@xxx.com
                            [createdBy] => 
                            [isActive] => 1
                        )

                    [1] => stdClass Object
                        (
                            [firstName] => Dan
                            [lastName] => Stewart
                            [phoneNumber] => +11111111111
                            [userName] => dan.sxx@xxx.ga.gov
                            [createdBy] => kwilliams@xxx.com
                            [isActive] => 1
                        )
                )

        )

    [1] => stdClass Object
        (
            [customer] => xxxx
            [city] => Carver
            [state] => MA
            [zipcode] => 02330
            [totalUsers] => 3
            [totalActiveUsers] => 3
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => Leo
                            [lastName] => Furtado
                            [phoneNumber] => 781-000-0000
                            [userName] => LFurtado@xxx.com
                            [createdBy] => TConger@ccccc.com
                            [isActive] => 1
                        )                

                )

        )
)

Table is attached