PHP - Creating A Xml File From Table With Multiple Records

Hi, I am trying to create an admin page for a local Gym Club to allow an Administrator to be able to update club prices which then show on different screens on the site.   I have been able to display the "Prices Admin" page which basically reads a MySQL database table (pricelist), display the description, member price and non-member price and allows the user to update any of these fields.   My problem is that when I try writing the data back to the database with the "UPDATE" statement it fails, what I mean is that nothing updates.  I have at the moment commented out the actual update statement and put in a "file_put_contents" command" to try and work out what is in the various fields before the UPDATE is run.  I find that the display/INPUT works perfectly well but when I do a foreach on the $record array variable I am getting strange results.   I may not have explained this very well but here are the relevant sections of my code;   // Display and Input section   <div id="admin-area">

I have a problem with an amend to an admin system I am trying to change. The shop stocks different colours of each product and the client wants to be able to update the stock levels of all colours of one product (which all share the same title) on one form. I have tried following some instructions on some sites and tried making my own and I can get it to display the form and the values correctly, but on submission it does nothing but direct me to a page without a title value in the address (e.g. www.example.com/example/stock_level_2.php?title=). I think it may be to do with the arrays I am using, has anyone got any ideas? Here is the code.

Form:
Code: [Select]
<?php
$pd_title = str_replace("_"," ",$_REQUEST["title"]);
$pd_title = str_replace("%","&#38;#37;",$pd_title);
$pd_title = str_replace("/","&#38;#47;",$pd_title);

$lookupqueryc = mysql_query("SELECT * FROM product WHERE pd_title = '".$pd_title."' ORDER BY pd_id DESC");

echo '<table><tr><th align="center" class="bodytext">Product<br />ID</th><th align="center" class="bodytext">Product Name</th><th align="center" class="bodytext">Stock Level</th></tr>';

$form = '<form name="frmAmendStock" method="post" action="stock_level_2.php?title="';
$form .=  $_GET["title"];
$form .= '" enctype="multipart/form-data">';
echo $form;
echo '<input name="submitted" type="hidden" value="true">';
$count=mysql_num_rows($lookupqueryc);
echo '<input name="count" type="hidden" value="';
echo $count;
echo '">';

                          
  while($lookupresultc = mysql_fetch_array($lookupqueryc)){  
  
        

echo '<tr><td align="center" class="bodytext">';
                                $id[]=$lookupresultc["pd_id"];
echo $lookupresultc["pd_id"];
echo '</td><td class="bodytext">';
echo $lookupresultc["pd_title"];
if (isset($lookupresultc["pd_colour"]) && $lookupresultc["pd_colour"] !="") {
echo " (";
echo $lookupresultc["pd_colour"];
echo ')';
}
if ($lookupresultc["pd_stock"] <= 5) {
echo '</td><td align="center" class="bodytext" style="border: 2px solid red;">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";
}else{
echo '</td><td align="center" class="bodytext">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";

}



} ?>
<tr>
                <td>&nbsp;</td>
                <td height="35"><a href="javascript: " onClick="javascript:document.forms.frmAmendStock.submit()" class="bodytext"><strong>click here to amend your stock </strong></a></td>
              </tr>
</form> </table>


And here is the code it should run on submission:
Code: [Select]
<?php
if (isset($_POST["submitted"])) {

for($i=0;$i<$_POST["count"];$i++){
mysql_query("UPDATE product SET pd_stock='$stock[$i]' WHERE pd_id='$id[$i]'");
}

}
?>

I know how to pull data from sql table and limit down the results,

what i wanted to do is pull data from a sql table 'finished' and list data that has paid='0'

this is then limited to show the amount of rows set by variable 'maxPay'

here is my list what im pulling atm;
    <h2>Payment </h2>
    <?php 
if($userType[user_type]==28){
$queryPay = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$queryAdmin = mysql_query("SELECT maxPay FROM `admin`;") or die(mysql_error());

$row = mysql_num_rows($queryPay);
//echo $row."row<br />";
$rowsArray = mysql_fetch_assoc($queryAdmin);
$rows = $rowsArray[maxPay];
//echo $rows."rows<br />";

if($rows>$row){
$r=$row;
}
else{
$r=$rows;
}
$s=0;
while($s<$r){
if($_POST[complete]==TRUE){
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$_POST[aid]';");
$_POST[complete] = FALSE;

}
$s++;
}

$t=0;
while($t<$r){
$queryuser = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$user = mysql_result($queryuser, $t, "username");
//echo $user;
$item = mysql_result($queryuser, $t, "itemName");
//echo $item;
$value = mysql_result($queryuser, $t, "marketPrice");
//echo $value;
$method = mysql_result($queryuser, $t, "method");
//echo $method;
$id = mysql_result($queryuser, $t, "auctionID");
//echo $id;



//echo $method;
if($method=='isk'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive ".$value."ISK.";

echo "<br />";
?></FORM><?
}
elseif($method=='ship'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive the ship.";

echo "<br />";
?></FORM><?
}
else{

}
$t++;
}

}
else{
echo "You are not an Admin.";
}
?>

and pay.php:
<?php 

header('Location: /admin.php');

include "connect.php";
echo $_POST[aid];
if($_POST[complete]==TRUE){
$tempID = (($_POST[aid])+1);
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$tempID';") or die(mysql_error());
$_POST[complete] = FALSE;
}
?>

at the moment i am listing all my data, and processing it using pay.php, each dataset has a "paid" button, i want to change this to using a checkbox at end of each data row, and a submit button at the bottom. this way i can select which rows to update and tick the checkbox, then click submit and those rows will then be updated the value '0' in db to a value of 'YES'.

hope i explained myself clearly enough for some help.

im a relative php noob still in training. 

This is the form that I'm using and it populates just fine but when you make the changes I can't figure out how to get it to update each record in my database.
Code: [Select]
<table width="100%" cellspacing="1" cellpadding="2" border="0">
<form action="<?php echo $_SERVER["PHP_SELF"] . "?update=1"; ?>" method="post">
<tr>
<td><b>Category Name</b></td>
<td><b>Category Description</b></td>
<td><b>Order</b></td>
<td align="right"><input type="submit" value="Update"></td>
</tr>
<?php
read_cat_list($cat);
for ($i = 0; $i < $cat["count"]; $i++) {
echo "<tr>\n";
echo "<td width=\"30%\" valign=\"top\"><input type=\"text\" name=\"cat_name_" . safe_string($cat[$i]["cat_id"]) . "\" size=\"30\" maxlength=\"250\" value=\"" . safe_string($cat[$i]["cat_name"]) . "\"></td>\n";
echo "<td width=\"36%\" valign=\"top\"><textarea name=\"cat_desc_" . safe_string($cat[$i]["cat_id"]) . "\" rows=\"2\" cols=\"30\">" . safe_string($cat[$i]["cat_desc"]) . "</textarea></td>\n";
echo "<td width=\"10%\" valign=\"top\"><input type=\"text\" name=\"cat_order_" . safe_string($cat[$i]["cat_id"]) . "\" size=\"3\" maxlength=\"3\" value=\"" . safe_string($cat[$i]["cat_order"]) . "\"></td>\n";
echo "<td width=\"24%\" valign=\"top\">[&nbsp;<a href=\"#\" onmouseover=\"window.status = 'Delete " . safe_string($cat[$i]["cat_name"]) . "'; return true;\" onmouseout=\"window.status = ''; return true;\" onclick=\"javascript:del_cat(" . $cat[$i]["cat_id"] . ", '" . safe_string($cat[$i]["cat_name"]) . "'); return false;\">Delete</a>&nbsp;]</td>\n";
echo "</tr>\n";
}
?>
<tr>
<td colspan="4" align="right"><input type="submit" value="Update"></td>
</tr>
</form>
</table>
the safe_string function just cleans up the output/input from the database, This next block is my form processor for this form.
Code: [Select]
<?php
function update_cats($vars) {
$err = "";

#if ($SESSION["level"] != ADMIN) {
# $err = ERR_NOT_ENOUGH_ACCESS;
#} else {
$temp = array_keys($vars);

for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 9) == "cat_name_") {
if ($vars[$temp[$i]] == "") {
$err = "Category names cannot be blank.";
break;
} else {
$name_query["cat_name"] .= substr($temp[$i], 9) . ", ";
}
}
}
for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 9) == "cat_desc_") {
$desc_query["cat_desc"] .= substr($temp[$i], 9) . ", ";
}
}
for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 10) == "cat_order_") {
if ($vars[$temp[$i]] == "") {
$err = "Category orders cannot be blank.";
break;
} else {
$order_query["cat_order"] .= substr($temp[$i], 10) . ", ";
}
}
}
#}

if (!$err) {
if ($name_query["cat_name"]) {
$update_name_query  = "update category";
$update_name_query .= "   set cat_name = '" . $name_query["cat_name"] . "'";
$update_name_query .= " where cat_id in (" . substr($name_query["cat_name"], 0, -2) . ")";

update_db($update_name_query);
}

if ($desc_query["cat_desc"]) {
$update_desc_query  = "update category";
$update_desc_query .= "   set cat_desc = '" . $name_query["cat_desc"] . "'";
$update_desc_query .= " where cat_id in (" . substr($desc_query["cat_desc"], 0, -2) . ")";

update_db($update_desc_query);
}

if ($order_query["cat_order"]) {
$update_order_query  = "update category";
$update_order_query .= "   set cat_order = '" . $name_query["cat_order"] . "'";
$update_order_query .= " where cat_id in (" . substr($order_query["cat_order"], 0, -2) . ")";

update_db($update_order_query);
}
}

return $err;
}
?>
update_db is my database caller, if you need any of the functions that I use that are not here please post back and tell me.

now when I process the form all my fields change to this:

cat_name: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
cat_desc:
cat_id: 0

for all the records in the database table, I'm just trying to update each record with the values it needs

Here is my database table with the data.
Code: [Select]
CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) NOT NULL,
  `cat_desc` text NOT NULL,
  `cat_order` int(11) NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(1, 'Hand Tossed Pizza', '', 1);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(2, 'Hand Tossed Specialty Pizzas', '', 2);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(3, 'Chicago Style Deep Dish', '', 3);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(4, 'Specialty Chicago Style Deep Dish', '', 4);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(5, 'Chicken Wings & Tenderloins', '', 5);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(6, 'Hot Sides', '', 6);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(7, 'Hot Sandwiches', '', 7);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(8, 'Cold Sandwiches', '', 8);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(9, 'Pastas', '', 9);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(10, 'Fresh Salads', '', 10);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(11, 'Fresh Breads', '', 11);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(12, 'Soups', '', 12);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(13, 'Kids Menu', '', 13);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(14, 'Drinks', '', 14);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(15, 'Desserts', '', 15);

Hope I have provided plenty of info on what I got and what I need for it todo

Thanks

hello guys moving on from inserting multiple records im now stuck with updating multiple records. i can get most of the details nailed but i need it to match the id's for the table the code i have in the sql part are
Code: [Select]
if (isset($_POST['submit'])) {
//Assign each array to a variable
$StaffMember = $_POST['StaffMember'];
$referrer = $_POST['referrer'];
$referred = $_POST['referred'];
$SentOut = $_POST['SentOut'];
$today = date("y.m.d H:i:s");
$user_id = $_SESSION['user_id'];
$IssueNum = $_POST['Referrerid'];
$limit = count($StaffMember);



$values = array(); // initialize an empty array to hold the values
for($k=0;$k<$limit;$k++){
$msg[] = "$limit New KPI's Added";



$values[$k] = "( '{$StaffMember[$k]}', '{$referrer[$k]}', '{$referred[$k]}', '{$SentOut[$k]}', '{$today}', '{$user_id}' )"; // build the array of values for the query string
}
$query = "UPDATE `Referrer` (StaffMember, referer, referred, SentOut,
  SentOutDate, SentOutBy)
  VALUES " . implode( ', ', $values ) . "
  WHERE IssueNum= '{$IssueNum[$k]}'";
 

echo $query;




}
i obviously want the records updating where the issuenumber is the same and if the check box in the form is ticked
help with this one?

Hi there,

Im fairly new at php and mysql but nevertheless im trying to build a web based campaign game for starwars minatures boardgame. Its fairly straightforward and going well.. However ive been thinking about how it will work and have stumbled across a possible problem (because of my limited craft at programming).

I want to have a single form that updates all records in the tables, this would simulate an "end of turn" button. Im sure i can do this if doing stuff in the game (e.g. move, create , modify, delete, fleets/ships and auto increment ships hulls simulating repair) if it was done on the same page. However i wanted to to initiate some of these adjustments in their respective pages (fleet.php, planets.php, ships.php etc) and then once the user is happy to click the end turn button somewhere which would update all of these things at the same time..

Is this possible at all???

If anybody could help that would be brilliant.

Thank you

p.s. if anybody wants a copy of the finished product when its complete, your most welcome.

Hi is it possible to update multiple records of the same table using a single hidden field with a while loop??? For example:

Code: [Select]
<?php if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE ships SET HealthA=%s WHERE ShipID=%s",
                       GetSQLValueString($_POST['healtha'], "int"),
                       GetSQLValueString($_POST['shipid'], "text")); ?>

 <input name="healtha" type="hidden" id="healtha" value="<?php echo $row_Ships['HealthA'] + 1; ?>" />
<input name="shipid" type="hidden" id="shipid" value="<?php  while($row = mysql_fetch_assoc($Ships)){ echo $row_Ships['ShipID']; }?>" />
If its not possible what else could i do to achieve this please?

Thank you

Hi ive been stuck for a while now and i just cant get my head around it so if you could help i'd be well chuffed.

I'm trying to update multple rows in a table depending upon the results of another.

I have a form that enables me to update a table called fleet. Another table called ships is realted to the fleet table as each ship is in a fleet:

fleet
-----
Fleetname*
Location
Detected

ships
------
ShipID*
Fleetname *
Shipname

The particular fleet i am editing is parsed as a url parameter.

I made a query to search for all the ships that are in the fleet i am editing: Code: [Select]
$colname_ShipsInfleet = "-1";
if (isset($_GET['recordID'])) {
  $colname_ShipsInfleet = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_ShipsInfleet = sprintf("SELECT * FROM ships WHERE FleetName = %s", GetSQLValueString($colname_ShipsInfleet, "text"));
$ShipsInfleet = mysql_query($query_ShipsInfleet, $swb) or die(mysql_error());
$row_ShipsInfleet = mysql_fetch_assoc($ShipsInfleet);
$totalRows_ShipsInfleet = mysql_num_rows($ShipsInfleet);
It searched the ships WHERE the FleetName (which is the primary key of the fleet table) is parsed as a url parameter. The appropriate ship records that are generated i want to use so a field can be updated.
For example im updating a fleet record and and setting the location (Planet Name) to a different value. I want the Ship records that are of that particular fleet to update a field (PlanetName) in ship table when the fleet table is updated.   

Code: [Select]
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE ships WHERE ShipID = $row_ShipsInfleet['ShipID'] SET PlanetName=%s",             
                       GetSQLValueString($_POST['select'], "text"));
  mysql_select_db($database_swb, $swb);

  $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());

  $updateSQL = sprintf("UPDATE fleet SET PlanetName=%s, Detected=%s, Faction=%s WHERE FleetName=%s",
                       GetSQLValueString($_POST['select'], "text"),
                       GetSQLValueString(isset($_POST['checkbox']) ? "true" : "", "defined","1","0"),
                       GetSQLValueString($_POST['hiddenField2'], "int"),
                       GetSQLValueString($_POST['hiddenField'], "text"));

  mysql_select_db($database_swb, $swb);
  $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());

I'm really not sure how to proceed here so please if you can help me out that would be ace.

Thank You

As part of my User Profile, I have a series of open-ended questions that Members can answer, e.g...
Quote

1.) Why did you start your own business?
2.) If you could offer one piece of advice to other entrepreneurs, what would it be?
:
10.) How do you compete against large corporations?



I was leaning towards creating a many-to-many relationship like this...

member -||---------0<- answer ->0---------||- question


From a database standpoint this works great, HOWEVER, I just realized a big problem...

If run this query...

Code: [Select]
SELECT response
FROM answer
WHERE member_id = 1;
...then I would get TEN RECORDS back and I don't know of any way to maps those to the 10 Text Boxes on the "My Thoughts" page?!

(It would be a real PITA to have to create 10 separate Prepared Queries in PHP - one for each Field - to fill out my page?!)

So, is there a way to keep my table structure, but push the 10 records from above into 10 separate variables so I would have something like $response1, $response2,... $response10 ??

Thanks,


Debbie

Hi all!

I have a page that is used to manage multiple user requests. The problem that I am having, is that it is supposed to send an email to the reporter any time their request is updated from this page. This works fine as long as I am doing one at a time, but when I try to update multiple records it doesn't send the emails. (All other functionality is working fine though.)
Here is a summary of what I have so far:
The form field to pass the users' emails
Code: [Select]
<input type="hidden" name="user_email<?= $arrValues["mantis_bug_id"] ?>" id="user_email<?= $arrValues["mantis_bug_id"] ?>" value="<?=$arrValues["email"]?>" />

This gets passed, along with the rest, to an update case on the same page, where I use a foreach() to process the multiple records:
Code: [Select]
foreach($_POST['chkResult'] as $intBugID){
.
.
.
.
.
if (isset($_POST["user_email$intBugID"])){
$emailTo = $_POST["user_email$intBugID"];
$emailSubject = "Mantis issue $intBugID has been modified.";
$emailContent = "Mantis issue $intBugID has recently been modified. Please review the changes that have been made
here [link]</a><br
/>If you have any questions or concerns regarding this issue, please contact Mike or Matt.<br />Thank you,<br />The
IT Team.";
include_once("{$_SERVER['DOCUMENT_ROOT']}/includes/Email.class.php");
$email = new Email();
$email->ContentType = "text/html";
$email->From = "me@myemail.org";
$email->FromName = "MOPS Mantis Bugtracker";
$email->to($emailTo);
$email->bcc('me@myemail.org');
$email->subject($emailSubject);
$email->setBody($emailContent);
$email->send;
echo 'User: ' . $emailTo. '<br />';
echo "User Email: " . $emailTo. "<br /><br />";

}
}//end foreach

As I said, this all works fine when I'm processing one issue at a time, but not when doing multiples. All other actions in the foreach() are also working. You'll notice that I'm echoing the username and email at the end for debugging purposes. The interesting thing is, that will output all of the correct usernames and emails for each user, it's just that the $email->send; just isn't working. Needless to say, this has become quite a frustrating bug to fix.
Any help at all is much appreciated!
Thanks,
Mike

Hello, i am having an issue when i try to go through multiple pages from a database. The database contains apartment information. I currently have it set to limit my results to 30 per page and this is working correctly, however when i try to scroll to page two like 1..2..3 i am displayed with every apartment listed in the database, and not the certain category that i would like selected.

//assigning variables
   $SESuser_lng = $_COOKIE['SESuser_lng'];
   $SESuser_admlevel = $_COOKIE['SESuser_admlevel'];
   $id = $_GET['id'];
   $pgrow = $_GET['pgrow'];
   $msg = $_GET['msg'];
   $ht_filter = $_GET['ht_filter'];

//sql query to retrieve result set $htfilter selects the distinct apartment categories

$sqlFilter = ($ht_filter > 0 ? " WHERE p.idhotel = $ht_filter" : "");
$sql = "SELECT p.id, p.idhotel, p.nombre, p.thmb, p.archivo, h.nombre
FROM prensa p
LEFT JOIN hoteles h ON p.idhotel = h.id
$sqlFilter
ORDER BY p.nombre, h.nombre";

//DB_pager
$nav = new DB_Pager('30');
$result = $nav->execute($sql, $dbcnx);

//Javascript link creation
<span id="display-links"><?php echo $nav->display_links(); ?></span>

any help will be greatly appreciated 

First of all excuse me if this topic is inappropriate in this forum. But I think it's rather a PHP problem.

I can't figure out multiple duplicate database records on submitting a form.

The database table have two columns:  the first one 'Id' with AUTO_INCREMENT and the second one 'Name'.

Here's the php code for database insertion and the form:
------------------------------------------------------------------

<?php

if($_GET['add_name']){
    $host = *******;
    $user = *******';
    $pass = *******;
    $db = *******;
    $con = mysql_connect($host,$user,$pass) or die;
    mysql_select_db($db,$con);
   
    $name = $_GET['add_name'];
    $sql = "INSERT INTO names (Name) VALUES ('$name')";
    mysql_query($sql);
}

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="GET">
Your Name:
<input name="add_name" type="text"  />
<input type="submit" value="Submit" />
</form>

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

After submitting the form to itself once I have multiple Name entries with different Ids. The curious thing is that with Chrome browser
I get two duplicate records, with Mozilla - three of them.
Seems like mysql_query runs multiple times.

It works fine when submitting the form to a separate script and not to itself.

Do I miss something? It must be very basic.

Hi. Im searching for a way to enter multiple records at once to mysql databased on a date range. Lets say i want to insert from date 2010-11-23 to date 2010-11-25 a textbox with some info and the outcome could look in database like below.

----------------------------------------------------------
| ID   |   date                |   name   |    amount   |
-----------------------------------------------------------
| 1     |   2010-11-23    |   Jhon     |        1         |
| 2     |   2010-11-24    |   Jhon     |        1         |
| 2     |   2010-11-25    |   Jhon     |        1         |
-----------------------------------------------------------

The reason i need the insertion to be like this is because if quering by month and by user to see vacation days then vacations that start in one month and end in another month can be summed by one month. If its in one record then it will pop up in both months.

Help is really welcome.

Hello,
Please excuse me if this sounds like a bit of a newb question.
If I have a link to a users profile and use GET to pull information about that user from various tables using something like this:

Code: [Select]
<?php
{
$id = $_GET['id'];
$user = mysql_query("SELECT * FROM users,tbl1,tbl2,tbl3,tbl4,tbl5 WHERE $id=tbl1.user_id AND tbl1.user_id=tbl2.user_id AND tbl2.user_id=tbl3.user_id ANDtbl3.user_id=tbl4.user_id AND tbl4.user_id=tbl5.user_id");
$user=mysql_fetch_assoc($user);
}
?>
<h3>Table 1</H3>
<?php echo "<b>".$user['tbl1_title']."<br>"; ?><br />

<h3>Table 2</H3>
<?php echo "<b>".$user['tbl2_title']."<br>"; ?><br />

<h3>Table 3</H3>
<?php echo "<b>".$user['tbl3_title']."<br>"; ?><br />

<h3>Table 4</H3>
<?php echo "<b>".$user['tbl4_title']."<br>"; ?><br />

<h3>Table 5</H3>
<?php echo "<b>".$user['tbl5_title']."<br>"; ?><br />

Why does it only show the 1st record for that user from each table?
And mostly, how do I change it to show all or a certain number of records from each table?

Any help would be greatly appreciated.
Thanks in advance 

I have a hopefully small issue on a form submitting data to the mysql database table and email. The email side works fine as does the adding the data to the database table but if I upload two files, it stores the support ticket twice in the database table where as I want to store just once and the files be stored as a array in the database table. I got the code from the link https://www.codexworld.com/upload-multiple-images-store-in-database-php-mysql/

The code I have is below

 

<?php

require_once "registerconfig.php";

if (isset($_POST['submit'])) {
		
		// File upload configuration 
    $targetDir = "support-ticket-images/"; 
    $allowTypes = array('pdf','doc','docx','jpg','png','jpeg','gif');
	
	$statusMsg = $errorMsg = $insertValuesSQL = $errorUpload = $errorUploadType = '';
	
	// Escape user inputs for security
$ticket_subject = htmlentities($_POST['ticket_subject'], ENT_QUOTES);
$ticket_message = strip_tags($_POST['ticket_message'], ENT_QUOTES);
$ticket_status ='PENDING SUPPORT'; 
$username = htmlentities($_SESSION["user_name"], ENT_QUOTES);
$user_id = htmlentities($_SESSION["user_id"], ENT_QUOTES);
	
	$fileNames = array_filter($_FILES['files']['name']);
	if(!empty($fileNames)){ 
        foreach($_FILES['files']['name'] as $key=>$val){ 
            // File upload path 
            $fileName = basename($_FILES['files']['name'][$key]); 
            $targetFilePath = $targetDir . $fileName; 
             
            // Check whether file type is valid 
            $fileType = pathinfo($targetFilePath, PATHINFO_EXTENSION); 
            if(in_array($fileType, $allowTypes)){ 
                // Upload file to server 
                if(move_uploaded_file($_FILES["files"]["tmp_name"][$key], $targetFilePath)){ 
                    // Image db insert sql 
                    $insertValuesSQL .= "('".$ticket_subject."','".$ticket_message."','".$fileName."','".$ticket_status."','".$username."', '".$user_id."'),";
                }else{ 
                    $errorUpload .= $_FILES['files']['name'][$key].' | '; 
                } 
            }else{ 
                $errorUploadType .= $_FILES['files']['name'][$key].' | '; 
            } 
        }

if(!empty($insertValuesSQL)){ 
            $insertValuesSQL = trim($insertValuesSQL, ','); 
            // Insert image file name into database 
            $insert = $link->query("INSERT INTO DB TABLE NAME (ticket_subject, ticket_message, file_name, ticket_status, user_name, user_id) VALUES $insertValuesSQL");
			
            if($insert){
				
				$to = "emailaddress";

    $subject = "A new support ticket has been submitted";
    $message = " <strong>$username</strong> has just created a support ticket, below is the support ticket
    <br /><br />
    <u>Support Ticket Details</u>
    <br /><br>
    <strong>Support Ticket Subject</strong>: $ticket_subject
    <br/><br><strong>Support Ticket Message</strong>: $ticket_message
    <p><strong><u>Support Ticket Files</u></strong>
    <br>
    <img src='$fileName'>
    ";
    // Always set content-type when sending HTML email
    $headers = "MIME-Version: 1.0" . "\r\n";
    $headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
    // More headers
    $headers .= 'From: <noreply@emailaddress>' . "\r\n";
    $mail=mail($to,$subject,$message,$headers);
				
                $errorUpload = !empty($errorUpload)?'Upload Error: '.trim($errorUpload, ' | '):''; 
                $errorUploadType = !empty($errorUploadType)?'File Type Error: '.trim($errorUploadType, ' | '):''; 
                $errorMsg = !empty($errorUpload)?'<br/>'.$errorUpload.'<br/>'.$errorUploadType:'<br/>'.$errorUploadType;
header("location: support-ticket-confirmation?user=$username");
            }else{ 
                $statusMsg = "Sorry, there was an error uploading your file."; 
            } 
        } 
    }else{ 
        $statusMsg = 'Please select files to upload.';
    } 
     
    // Display status message 
    echo $statusMsg; 
}
?>

The structure of the db table column is file_name, VARCHAR(255), latin1_swedish_ci, NOT NULL