I've got this products page form and what I have is two tables to insert the data into, about_products,about_urls.
What I am trying to achieve is to insert info into about_products table and the URLs associated for that product. The thing is, is that I'm having trouble getting to insert the URLs for that product.
Database Structure:
PHP Code:
desc about_products;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| pid | int(11) | | PRI | NULL | auto_increment |
| title | varchar(255) | | | | |
| intro | text | YES | | NULL | |
| price | varchar(255) | | | | |
| prodinfo | text | YES | | NULL | |
+----------+--------------+------+-----+---------+----------------+
mysql> desc about_urls;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| uid | int(11) | | PRI | NULL | auto_increment |
| url | varchar(255) | | | | |
| pid | int(11) | | | 0 | |
+-------+--------------+------+-----+---------+----------------+
As you can see I've used pid as a foreign key to about_products.
code:
PHP Code:
<form action="products.php" method="post" ENCTYPE="multipart/form-data">
<table cellpadding="2" cellspacing="2" border="1" width="100%">
<?
for ($n=1;$n<9;$n++)
{
?>
<tr>
<td><b>Title of Product</b>:</td>
<td><input type="text" name="title[<? echo $n ?>]" size="45"></td>
</tr>
<tr>
<td><b>Price</b>:</td>
<td><input type="text" name="price[<? echo $n ?>]" size="45"></td>
</tr>
<tr>
<td valign="top"><b>Introductory text about the product</b>:</td>
<td><textarea cols="50" rows="5" wrap="virtual" name="intro[<? echo $n ?>]"></textarea><p></td>
</tr>
<tr>
<td valign="top"><b>Product Details</b>:</td>
<td><textarea cols="50" rows="5" wrap="virtual" name="prodinfo[<? echo $n ?>]"></textarea><p></td>
</tr>
<tr>
<td valign="top"><b>URLs</b>:<br>MUST BE IN FORMAT [url]http://www.manutd.com/whatever[/url]</td>
<td>
<?
for ($x=0;$x<3;$x++)
{
?>
<input type="text" name="url[<? echo $n ?>][<?echo $x?>]" size="45"><br>
<?
}
?>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<?
}
?>
<tr>
<td colspan="2" align="center"><input type="submit" name="submit" value="Enter"></td>
</tr>
</table>
</form>
if ($submit=='Enter')
{
$found=0;
while (list($key1) = each($url))
{
while ((list($key2,$val)= each($url["$key1"])) && $found==0)
{
if ($val!='' && substr($val,0,7)!='http://')
{
$found=1;
echo "You must start with [url]http://[/url]<br>\n";
}
else
$urls[]=$val;
}
}
foreach ($urls as $var=>$value)
echo "$value<br>\n";
$num=count($urls);
if ($found==0)
{
$index=0;
for ($n=1;$n<9;$n++)
{
if ($title[$n] !="")
{
$query="insert into about_products (title,intro,price,prodinfo) ";
$query.="values ('".$title[$n]."','".$intro[$n]."','".$price[$n]."','".$prodinfo[$n]."')";
echo "$query<br>\n";
mysql_query($query);
$pid=mysql_insert_id();
echo "insert into about_urls (url,pid)
values ('".$urls[$x]."',$pid)<br>\n";
#mysql_query("insert into about_urls (url,pid)
# values ('".$urls[$index++]."',$pid)");
}
}
}
So what I am trying to achieve here is to insert the product details into the database, get the last id then insert into about_urls table, the urls associated for that product. (which they can be upto 3 urls for that product).
at the moment its doing this....
http://www.manutd.com/
http://www.mancity.com/ (Product 1)
http://www.df.com/
http://www.msdf.com/ (Product 2)
insert into about_products (title,intro,price,prodinfo) values ('sd','sd','sd','d')
insert into about_urls (url,pid) values ('http://www.manutd.com/',91)
insert into about_products (title,intro,price,prodinfo) values ('ghj','h','gj','')
insert into about_urls (url,pid) values ('http://www.mancity.com/',92)
So really it should insert the first product into database with the two urls, then next product and the two urls for that...
I'm going astray here but don't know how to overcome this sticky problem.
Any help much appreciated...
Ozzie
Dev Articles Community Forums Sponsor:
June 13th, 2002, 06:39 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
