writing array to database

[deregular]

Hope you guys can help.
I have the following form. It is a very standard form, however there is the added complexity that it is dynamic, depending on how many days the person chooses to have on the form. Hence the looping through some form fields and the results going to an array.
What im trying to do is insert this into my table.

The generic information needs to go into each insert as well as the looped fields.

Here is the form.

elseif(isset($_GET['daysinweekly'])){
	$days = $_POST['days'];

echo"<form name='' method='POST' action='".$_SERVER['PHP_SELF']."?reviewweekly=$days'>";
echo"<input type='hidden' name='m_name' value='".$_SESSION['session_e_name']."'>";
echo"<input type='hidden' name='m_venue_name' value='".$_SESSION['session_venue']."'>";

echo"You have indicated that you are on a $days day cruise. <br>If this is not correct please click <a href='weekly.php?days=1'>HERE</a> and choose again.<br>Otherwise, please fill out your full cruise report below.";
echo"<br>";

echo"Pax Count for cruise:</td><td class='body'><input type='text' name='paxcount'>(Numbers Only)";		
  	echo"Youth Count for cruise:</td><td class='body'><input type='text' name='youthcount'>(Numbers Only)";
  	echo"Date of first day: Month:<select name='Dmonth'>".
           "<option value='' selected>Month</option>"."<option value='01'>Jan</option>"."<option value='02'>Feb</option>"."<option value='03'>Mar</option>"."<option value='04'>Apr</option>"."<option value='05'>May</option>"."<option value='06'>Jun</option>"."<option value='07'>Jul</option>"."<option value='08'>Aug</option>"."<option value='09'>Sep</option>"."<option value='10'>Oct</option>"."<option value='11'>Nov</option>"."<option value='12'>Dec</option>"."</select>".
           " Day:  <select name='Dday'>"."<option value='' selected>Day</option>"."<option>1</option>"."<option>2</option>"."<option>3</option>"."<option>4</option>"."<option>5</option>"."<option>6</option>"."<option>7</option>"."<option>8</option>"."<option>9</option>"."<option>10</option>"."<option>11</option>"."<option>12</option>"."<option>13</option>"."<option>14</option>"."<option>15</option>"."<option>16</option>"."<option>17</option>"."<option>18</option>".
           "<option>19</option>"."<option>20</option>"."<option>21</option>"."<option>22</option>"."<option>23</option>"."<option>24</option>"."<option>25</option>"."<option>26</option>"."<option>27</option>"."<option>28</option>"."<option>29</option>"."<option>30</option>"."<option>31</option>"."</select>".
        " Year: <select name='Dyear'>"."<option value='' selected>Year</option>"."<option>2005</option>"."<option>2006</option>"."<option>2007</option>"."<option>2008</option>"."<option>2009</option>"."<option>2010</option>"."</select>".

echo"<hr>";

for($today=1;$today<=$days;$today++){
echo"<br>";
echo"Day $today of $days";

     	echo'Total for today: $ <input type="text" name="array['.$today.'][m_total]" value="">';
     	echo'Please specify port or seaday:<input type="text" name="array[' . $today . '][location]">';
  		echo'Hours & area of operation:<br><textarea name="array[' . $today . '][hours]" cols="45" rows="5"></textarea>';
  		echo'Promotion:<input type="text" name="array[' . $today . '][promotion]">';
	echo'Small Tattoo Count:<input type="text" name="array[' . $today . '][stcount]">';
  		echo'Medium/Large Tattoo Count:<input type="text" name="array[' . $today . '][mtcount]">';
  		echo'XL Tattoo Count:<input type="text" name="array[' . $today . '][xltcount]">';
 		echo'Glitter Tattoo Count:<input type="text" name="array[' . $today . '][gtcount]">';
	echo"Comments:<br><textarea name="array[' . $today . '][m_comments]" cols="45" rows="5"></textarea>';
	echo"<hr>";
}

echo"<center><input type='submit' name='' value='Submit'></td></tr></table></center></form></center>";

}

And here is what i have so far re.. inserting to database, however i cant get the results of my array to write to the table.
Any suggestions?

//Writes to database
elseif(isset($_GET['submitweekly'])){
	$totaldays=(int)$_GET['submitweekly'];


$venue=($_SESSION['session_venue']);
$name=($_SESSION['session_e_name']);
$datemonth=stripslashes($_POST['Dmonth']);
$dateday=stripslashes($_POST['Dday']);
$dateyear=stripslashes($_POST['Dyear']);
$date="$dateyear-$dateday-$datemonth";
$paxcount=stripslashes($_POST['paxcount']);
$youthcount=stripslashes($_POST['youthcount']);

//create cruise number
$result6=mysql_query("SELECT * FROM venues WHERE v_name='$venue'");
$row6=mysql_fetch_array($result6);
$cruisenumber=(($row6['abbrev']).'-'.$date);


foreach ($_POST['array'] as $key => $value){
$sql99 = mysql_query("INSERT INTO earnings (m_venue_name, m_employee, m_total, thisday,totaldays,location,hours,promotion,paxcount,youthcount,stcount,mtcount,ltcount,xltcount,gtcount,m_comments,cruisenumber,m_date)
	VALUES('$venue', '$name', '".$value['m_total']."', '1','$totaldays','".$value['location']."','".$value['hours']."','".$value['promotion']."','$paxcount','$youthcount','".$value['stcount']."','".$value['mtcount']."','0','".$value['xltcount']."','".$value['gtcount']."','".$value['m_comments']."','$cruisenumber', '$date')") or die (mysql_error());
}

The ".$value['m_total']." etc.. dont seem to carry any info? Can someone shed some light on this?
Thanks in advance as always!

cheers
shane

[lmayer4]

Silly question: have you tried echoing the array to see if it's pulling any info?

[deregular]

yes i have and they echo fine. I have a review script with hidden form fields that posts to the database or back to an edit form depending on if they need to change anything, but left it out so my post was so long.

The top bit here is the bit that posts to the edit form,
and the lower hidden fields bit posts to the table.

hope someone can help.

cheers
shane

elseif(isset($_GET['reviewweekly'])){
	$days=(int)$_GET['reviewweekly'];
	include'header.php';

echo"<center><table width=80%>";
echo"<tr><td colspan=2><font color='red'><b>Please review your report and make sure that it is accurate.<br>If it is, please use the OK button at the bottom of this page. If it is not, please use the TRY AGAIN button at the bottom of this page.</b></font><br><br></td></tr>";
echo"<tr><td colspan=2>Below is what you have filled in.<br><br></td></tr>";
//this section for try again
echo'<form name="" method="POST" action="'.$_SERVER['PHP_SELF'].'?editweekly='.$days.'">';

echo"<tr><td><input type='hidden' name='Dmonth' value='".$_POST['Dmonth']."'>Date: </td><td>{$_POST['Dmonth']}-";
echo"<input type='hidden' name='Dday' value='".$_POST['Dday']."'>{$_POST['Dday']}-";
echo"<input type='hidden' name='Dyear' value='".$_POST['Dyear']."'>{$_POST['Dyear']}</td></tr>";
echo"<tr><td><input type='hidden' name='m_name' value='".$_POST['m_name']."'>Name: </td><td>{$_POST['m_name']}</td></tr>";
echo"<tr><td><input type='hidden' name='m_venue_name' value='".$_POST['m_venue_name']."'>Venue: </td><td>{$_POST['m_venue_name']}</td></tr>";
echo"<tr><td><input type='hidden' name='paxcount' value='".$_POST['paxcount']."'>Passenger Count: </td><td>{$_POST['paxcount']}</td></tr>";
echo"<tr><td><input type='hidden' name='youthcount' value='".$_POST['youthcount']."'>Youth Count: </td><td>{$_POST['youthcount']}</td></tr>";
echo"<tr><td colspan=2><hr></td></tr>";

	foreach ($_POST['array'] as $key => $value){
			echo'<tr><td><input type="hidden" name="days" value="'.$key.'">Day '.$key.'of'.$days.'</td><td></td></tr><br>';
			echo'<tr><td>Total for Today: </td><td><input type="hidden" name="array['.$key.'][m_total]" value="'.$value['m_total'].'">'.$value['m_total'].'</td></tr>';
			echo'<tr><td>Location: </td><td><input type="hidden" name="array['.$key.'][location]" value="'.$value['location'].'"> ' . $value['location'] . '</td></tr>';
			echo'<tr><td>Hours: </td><td><input type="hidden" name="array['.$key.'][hours]" value="'.$value['hours'].'"> ' . $value['hours'] . '</td></tr>';
			echo'<tr><td>Promotion: </td><td><input type="hidden" name="array['.$key.'][promotion]" value="'.$value['promotion'].'"> ' . $value['promotion'] . '</td></tr>';
			echo'<tr><td>Small Tattoos: </td><td><input type="hidden" name="array['.$key.'][stcount]" value="'.$value['stcount'].'"> ' . $value['stcount'] . '</td></tr>';
			echo'<tr><td>Medium-Large Tattoos: </td><td><input type="hidden" name="array['.$key.'][mtcount]" value="'.$value['mtcount'].'"> ' . $value['mtcount'] . '</td></tr>';
			echo'<tr><td>XL Tattoos: </td><td><input type="hidden" name="array['.$key.'][xltcount]" value="'.$value['xltcount'].'"> ' . $value['xltcount'] . '</td></tr>';
			echo'<tr><td>Glitter Tattoos: </td><td><input type="hidden" name="array['.$key.'][gtcount]" value="'.$value['gtcount'].'"> ' . $value['gtcount'] . '</td></tr>';
			echo'<tr><td>Comments: </td><td><input type="hidden" name="array['.$key.'][m_comments]" value="'.$value['m_comments'].'"> ' . $value['m_comments'] . '</td></tr>';
			echo"<tr><td colspan=2><hr></td></tr>";  
	}  
echo"<tr><td colspan=2 align=center><input type='submit' name='' value='TRY AGAIN'></form>";

//the following form is for if their report is ok
echo'<form name="" method="POST" action="'.$_SERVER['PHP_SELF'].'?submitweekly='.$days.'">';
echo"<input type='hidden' name='Dmonth' value='".$_POST['Dmonth']."'>";
echo"<input type='hidden' name='Dday' value='".$_POST['Dday']."'>";
echo"<input type='hidden' name='Dyear' value='".$_POST['Dyear']."'>";
echo"<input type='hidden' name='m_name' value='".$_POST['m_name']."'>";
echo"<input type='hidden' name='m_venue_name' value='".$_POST['m_venue_name']."'>";
echo"<input type='hidden' name='paxcount' value='".$_POST['paxcount']."'>";
echo"<input type='hidden' name='youthcount' value='".$_POST['youthcount']."'>";



	foreach ($_POST['array'] as $key => $value){
			echo'<input type="hidden" name="days" value="'.$key.'">';
			echo'<input type="hidden" name="array['.$key.'][m_total]">';
			echo'<input type="hidden" name="array['.$key.'][location]">';
			echo'<input type="hidden" name="array['.$key.'][hours]">';
			echo'<input type="hidden" name="array['.$key.'][promotion]">';
			echo'<input type="hidden" name="array['.$key.'][stcount]">';
			echo'<input type="hidden" name="array['.$key.'][mtcount]">';
			echo'<input type="hidden" name="array['.$key.'][xltcount]">';
			echo'<input type="hidden" name="array['.$key.'][gtcount]">';
			echo'<input type="hidden" name="array['.$key.'][m_comments]">';
	}  

echo"<input type='submit' name='' value='OK Send My Report'></td></tr></table></center></form>";
}

[halojoy]

Hey.

One method to store array in a database text-string field
is by using function [man]serialize[/man]

This database field needs to be a big enough text field to have room for maxsize of array in serialized format
If you do not know what max size will be, you may specify no limit to this field size

A serialized array is the data contents within an array
along with a description of this array's structure.

This way you can convert back this 'string' to the original array format
by using function [man]unserialize[/man]

/halojoy - description: a man from sweden / data contents: some strange ideas

🙂

[deregular]

while this seems like a way of doing it, id much rather format the information before it goes to the database rather than having to 'unserialize' it when retrieving from the db.

Im still totally stumped on this, i hope someone has some other ideas, ive managed to create the form with a nice loop and by putting the info into an array like this.

Just to reiterate, i have a form that is created by looping through and using this type of thing.

for($today=1;$today<=$days;$today++){
<input type="text" name="array['.$today.'][m_total]" value="">
}

then the review form page

foreach ($_POST['array'] as $key => $value){
<input type="hidden" name="array['.$key.'][m_total]" value="'.$value['m_total'].'">'.$value['m_total'].'
}

which if they click ok would write the info to the database.

but dont know how to then retrieve the info to store to my db.

surely there must be a way?

Below is how i would do it but it doesnt work.

for($today=1;$today<=$totaldays;$today++){
	$sql99 = mysql_query("INSERT INTO earnings (m_venue_name, m_employee, m_total, thisday,totaldays,location,hours,promotion,paxcount,youthcount,stcount,mtcount,ltcount,xltcount,gtcount,m_comments,cruisenumber,m_date)
		VALUES('$venue', '$name', '".$today."m_total', '$today','$totaldays','".$today."location','".$today."hours','$".$today."promotion','$paxcount','$youthcount','".$today."stcount','".$today."mtcount','0','".$today."xltcount','".$today."gtcount','".$today."m_comments','$cruisenumber', '$date')") or die (mysql_error());
	}

[deregular]

my bad, it works now, my coding was fine in the first place, its just that id forgotten to put the 'value' in my hidden form fields.

resolved!!

cheers
shane