PHP - Php Table Loop Issue

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.

The first run of my for loop does not execute, but all after that works. I know I need to define my $strings before the for loop because they do not take effect until it has ran once and that is why it does not show the first run. But I don't completely understand how to solve the issue, and have tried everything to my knowledge.

The code below imports a steam group page xml and gets the unique ids for each of the groups members, then retrieves information about members.

<?php

$groupxml = simplexml_load_file('http://steamcommunity.com/groups/MDK-Society/memberslistxml/?xml=1');
$members = $groupxml->memberCount;
$array = $groupxml->members->steamID64;

for($arraycount="0"; $arraycount<$members; $arraycount=$arraycount+1){
$xml = simplexml_load_file("http://steamcommunity.com/profiles/$array[$arraycount]/?xml=1");
echo "<a href=\"#\" title=\"<img src=$xml->avatarMedium align=right /> $xml->steamID<br />$xml->stateMessage<br /><br />Location: $xml->location<br />$xml->summary\"><img src=\"$xml->avatarMedium\" /></a>";
echo "<br>";

if ("$xml->onlineState" == "online") {
echo "<img src=\"images/stateonlinemaster.png\" />";
}
elseif ("$xml->onlineState" == "offline") {
echo "<img src=\"images/stateofflinemaster.png\" />";
}
else
{
echo "<img src=\"images/stateingamemaster.png\" />";
}
echo "<br>"; 
echo "<br>"; 
}

?>

Could you explain to me fully where I went wrong in the for loop. Thanks

I'm starting to get peeved with PHP today, after many hours of trying to sort an issue - I'm sure you all know what I mean.

Once again, the issue lies with foreach loops which I have never been able to fully understand, especially when dealing with multiple arrays.

The code is for a CMS, where a restaurant owner can update his menu's and choose whether to show them on the website using a tick box.

Here's a screenshot..



Essentially, the issue I am having is should I click say, the bottom tickbox and click Update it will for some reason, tick the second in the database.... In reverse, if all are ticked, and I untick the bottom, it will untick the box before it.... it is sooo frustrating..

From what I can see, it is likely to be where the array, where ticked boxes have a value, and non-ticked ones don't... but I tried to sort this in my foreach loop setting an empty value to off....

Here is the HTML code:

Code: [Select]
<form action="./includes/scripts/menus/update.php" enctype="multipart/form-data" method="post">

<button type="submit" onclick="return confirm('Updating Menu Changes...\n\nUpdating PDF files may time some time.. \n\nDo not navigate away from this page until you recieve a success or failure confirmation.\n\nClick Cancel to make changes.'); { return alert('noob'); }">Update Menu Changes</button>
<button type="button" onClick="document.location.href='./includes/scripts/menus/new_row.php'">Add New Menu Item...</button>

<br /><br />

<table border="0" width="962" cellpadding="0" cellspacing="0">

    <tr style="padding-bottom: 3px;">   
        <th style="text-align: center;" width="195.4">Active</th>
        <th style="text-align: center;" width="195.4">Menu</th>
        <th style="text-align: center;" width="195.4">Current Menu</th>
        <th style="text-align: center;" width="195.4">Change Menu (PDF format only)</th>
        <th style="text-align: text-align: center;" width="195.4">Tasks</th>
    </tr>
   
    <?
   
    $query = "SELECT * FROM menus ORDER by id ASC";
    $query = mysql_query($query) or die(mysql_error());
   
    //Count rows
    $num_rows = mysql_num_rows($query);
   
    //If no rows exist
    if($num_rows=="0") { ?>
       
        <tr style="padding-bottom: 3px;">           
            <td colspan="4" style="text-align: center;">There are currently no menus listed in the Pen Mill Hotel database.</td>       
        </tr>
       
    <? }
   
    //If new rows exist
    elseif($num_rows!=="0") {
       
                $i = "0";
   
    while($row=mysql_fetch_array($query)) {
   
        //Database Variables
        $name = $row["menu"];
        $id = $row["id"];   
        $location = $row["location"];
       
        //Establish if a menu is present in database for current entry
        if(empty($location)) {
            $current = "<a style=\"cursor: pointer;\" onclick=\"alert('No menu found!');\" title=\"View Listed Menu\">View Current Menu</a>";
        }
       
        elseif(!empty($location)) {
            $current = "../includes/menus/" . $row["location"];
            $current = "<a href=\"$current\" title=\"View Listed Menu\" />View Current Menu</a>";
        }
       
        //Establish whether to check tickbox or not.
        $active = $row["active"];
            if($active=="on") { $active = " checked=\"checked\" "; }
            elseif($active!=="on") { $active = " "; }
       
    ?>
   
    <tr style="padding-bottom: 3px;" id="<? echo "$id"; ?>">
   
        <td style="text-align: center;">
                <input type="checkbox"<? echo "$active"; ?>name="active[<? echo "$i"; ?>]" /> 
        </td>
       
        <td style="text-align: center;">
            <input type="text" style="padding: 0px;" name="name[]" value="<? echo "$name"; ?>" />
        </td>
       
        <td style="text-align: center;">
            <? echo $current; ?>
        </td>
       
        <!-- Tell PHP, max file size is equal to 5MB (in bytes) -->
        <input type="hidden" name="MAX_FILE_SIZE" value="5242880" />
       
        <td style="text-align: center;"><input type="file" name="menu_file[]" /></td>
       
        <td style="text-align: center;">
            <a href="./includes/scripts/menus/delete.php?id=<? echo "$id"; ?>"
            onclick="return confirm('Are you sure you wish to delete this menu?\n ');">
                Delete
            </a>
         </td>
 
    </tr>
   
    <input type="hidden" name="id[]" value="<? echo $id; ?>" />
   
    <? $i++; ?>

<? } } ?>
   
</table>

<br />

<button type="submit" onclick="return confirm('Updating Menu Changes...\n\nUpdating PDF files may time some time.. \n\nDo not navigate away from this page until you recieve a success or failure confirmation.\n\nClick Cancel to make changes.');">Update Menu Changes</button>
<button type="button" onClick="document.location.href='./includes/scripts/menus/new_row.php'">Add New Menu Item...</button>

</form>
And here is the PHP, baring in mind it will also deal with a file upload, but that isn't the issue at the moment...
Code: [Select]
<?

/*

This script is for use on the Manage Menu's pages and updates all menu items.

*/

/*==================================*/
/* DATE BASE CONFIGURATION            */
/*==================================*/

include_once "../../config/config.php";

/*==================================*/
/* SET VARIABLES                    */
/*==================================*/

$id = $_POST["id"];
$active = $_POST["active"];
$name = $_POST["name"];
$menu_file = $_FILES['menu_file'];
$i = "0";

/*==================================*/
/* Loop Each Menu & Update             */
/*==================================*/

foreach($id as $key) {
   
    //Set Sub Variables
    if(empty($active["$i"])) { $active["$i"] = "off"; }
    $active_post = $active["$i"];
    $name_loop = $name["$i"];
   
    //Set File Variables
    $file_name = $menu_file["name"]["$i"]; //name of file on users machine
    $file_type = $menu_file["type"]["$i"]; //type of file being uploaded
    $file_size = $menu_file["size"]["$i"]; //size of the uploaded file in bytes
    $file_error = $menu_file["error"]["$i"]; //returned PHP error codes for upload
    $file_temp = $menu_file["tmp_name"]["$i"]; //temporary name on server
   
    //Handle Uploaded File (if uploaded)
    if(!empty($file_name)) {
       
        //FILE ERROR CHECKS
        //If file type is not PDF.
        if($file_type!=="application/pdf") {
   
            $pass = "0";
            header("Location: ../../../index.php?page=Menus&error=Incorrect_File_Type");
           
        }
       
        //If file type is greater than 5MB.
        if($file_size>"5242880") {
   
            $pass = "0";
            header("Location: ../../../index.php?page=Menus&error=Incorrect_File_Size");
           
        }
       
        //If above error checks pass
        if($pass!="0") {
           
            //Get todays date for file rename
            $today = date("d-m-Y");
            $uploaddir = "/home/penmillh/en/includes/menus/";
            $upload_name = str_replace(" ", "", $name_loop) . $today . ".pdf";
            $uploadfile = $uploaddir . $upload_name;
           
            //Move file only if PHP upload status is correct
            if($file_error!="UPLOAD_ERR_OK") {
           
                header("Location: ../../../index.php?page=Menus&error=File_Upload_Error");
               
            }
           
            //If PHP status is okay, upload file and update table.
            if($file_error=="UPLOAD_ERR_OK") {
           
                //Upload
                move_uploaded_file($file_tmp, $uploadfile);
               
                //Update Database
                $query = "UPDATE menus SET active='$active', menu='$name_loop', location='$upload_name' WHERE id='$value'";
                $query = mysql_query($query) or die(mysql_error());
               
                header("Location: ../../../index.php?page=Menus&error=File_Upload_Success");
               
            }   
           
        }
       
    }
   
    //If no uploaded file, update database records
    if(empty($file_name)) {
             
        //Update Database       
        $query = "UPDATE menus SET active='$active_post' WHERE id='$key'";
        $query = mysql_query($query) or die(mysql_error());
       
//        header("Location: ../../../index.php?page=Menus&error=Menu_Change_Success");
             
    }
   
    $i++;

}


?>
Now, I have probably made this INCREDIBLY complicated, but that's all I could remember from my previous experience with foreach loops....

Any ideas?

Im trying to search through the read column and see if any of the rows are read
I echo $mail and it shows all the rows for the user. So im grabing the ones I want but now i dont know how to search through what I selected. Or is there a simplier way of having SQL do what im trying to do?

Code: [Select]
<?php   
    $query = "SELECT `read` FROM pm WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; 
$results = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_assoc($results)) {   
    
$mail = $row['read'];
}
// checks if user has unread mail or not
if ($mail == "unread") {    
    
    
    echo '<td><b><a href="inbox.php?inbox=1">Messages</a></b></td><td id="diamond">&diams;</td>';
    
} else {     
    
    echo '<td><a href="inbox.php?inbox=1">Messages</a></td>';
    
}    

?>

Hello,
I have a page where the user uploads a CSV file and I want to read that CSV and update database fields accordingly.  It seems I have all the code correct but only the first row of the CSV is being imported.

If I echo my variables within the loop, the only output is the first row of the CSV - no subsequent rows.  I feel like I'm close but not sure what the issue is?  Thanks a million for any help!!

Jason


//START FILE OPERATION
$handle = fopen('uploads/testfile.csv', "r");

//LOOP CONTENTS OF CSV FILE
while (($data = fgetcsv($handle, 1000, ",")) !== false)
{
$importID = $data[0];
$companyName = $data[1];
$primaryPhone = $data[2];
$primaryEmail = $data[3];
$billingFirstName = $data[4];
$billingLastName = $data[5];

$query = 'SELECT importID FROM import';
if (!$result = mysql_query($query))
{
continue;
}

if ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
//UPDATE IF ENTRY EXISTS
$query = "UPDATE import SET companyName='$companyName', primaryPhone='$primaryPhone', primaryEmail='$primaryEmail', billingFirstName='$billingFirstName' WHERE importID=$importID";
mysql_query($query);

if (mysql_affected_rows() <= 0)
{
//NO RECORDS UPDATED
}
}
else
{
//ENTRY DOESN'T EXIST
}

mysql_free_result($result);
}

//CLOSE FILE OPERATION
fclose($handle);