RE: [PHP] Insert an array into MySQL
Your second method should work, but it's dependent on what your form
looks like and how your table was created. You obviously have a key set
for this column and you're trying to insert the same value twice, which
makes an error.
Show us what your form looks like, not the whole thing, just for the
checkboxes. Also, what does your CREATE TABLE look like for the table
your trying to insert this data into?
---John Holmes...
-Original Message-
From: Rob Packer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 7:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Insert an array into MySQL
Hi, I've seen a few post for this same thing but I can't seem to get
it
working. What I'm doing is taking a form with check boxes and putting
them
into an array. Then I'm attempting to INSERT them into the db, one
checkbox
value per row.
Okay, well I've tries 2 ways that I think should work and they only
insert
the first value. They both produce this error Duplicate entry '0' for
key
1 (which I don't understand) Anyway here is the code I'm trying...
(I'm not trying to use both blocks of code, just one or the other)
// First code
while(list($key,$value)=each($pagetype)){
//echo $value.br;//test
$links=INSERT INTO $username_links (links) VALUES ('$value');
$insert=mysql_query($links,$connection);
}
// Second code attempt
$number=count($pagetype);
for($a=0;$a$number;$a++){
$links=INSERT INTO $username_links (links) VALUES ('$pagetype[$a]');
$insert=mysql_query($links) or die(mysql_error());
//echo $pagetype[$a];//test
}
Thanks in advance...Robert
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Insert an array into MySQL
John Holmes [EMAIL PROTECTED] wrote in message
001201c21ab5$0df073a0$b402a8c0@mango">news:001201c21ab5$0df073a0$b402a8c0@mango...
Your second method should work, but it's dependent on what your form
looks like and how your table was created. You obviously have a key set
for this column and you're trying to insert the same value twice, which
makes an error.
Show us what your form looks like, not the whole thing, just for the
checkboxes. Also, what does your CREATE TABLE look like for the table
your trying to insert this data into?
---John Holmes...
-Original Message-
From: Rob Packer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 7:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Insert an array into MySQL
Hi, I've seen a few post for this same thing but I can't seem to get
it
working. What I'm doing is taking a form with check boxes and putting
them
into an array. Then I'm attempting to INSERT them into the db, one
checkbox
value per row.
Okay, well I've tries 2 ways that I think should work and they only
insert
the first value. They both produce this error Duplicate entry '0' for
key
1 (which I don't understand) Anyway here is the code I'm trying...
(I'm not trying to use both blocks of code, just one or the other)
// First code
while(list($key,$value)=each($pagetype)){
//echo $value.br;//test
$links=INSERT INTO $username_links (links) VALUES ('$value');
$insert=mysql_query($links,$connection);
}
// Second code attempt
$number=count($pagetype);
for($a=0;$a$number;$a++){
$links=INSERT INTO $username_links (links) VALUES ('$pagetype[$a]');
$insert=mysql_query($links) or die(mysql_error());
//echo $pagetype[$a];//test
}
Thanks in advance...Robert
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Insert an array into MySQL
oops, sorry about the other post (I've got a baby that likes the
keyboard)...
Hi,
This is the form, which I had doubts about, but it seemed to put things into
the array correctly when I tested it by printing it out.
I can't see how, it will print
key=0
value=index.html
key=1
value=about.html
key=2
value=whats_new.html
when I test it and then have a duplicate key. It's saying that I have 2
$pagetype[0] correct? Anyhow, here's the form...
INPUT TYPE=hidden NAME=pagetype[] VALUE='index.html'Home Page br
INPUT TYPE=checkbox NAME=pagetype[] VALUE='about.html'About Page br
INPUT TYPE=checkbox NAME=pagetype[] VALUE='whats_new.html'What's New
Pagebr
INPUT TYPE=checkbox NAME=pagetype[] VALUE='contact.html'Contact Pagebr
INPUT TYPE=checkbox NAME=pagetype[] VALUE='favorite_links.html'Favorite
Links br
The CREATE TABLE is this:
I define the table name from user input.
$query_links=CREATE TABLE $username_links (id INT(4) not null, links
VARCHAR(20) not null, UNIQUE (id));
if(mysql_query($query_links,$connection)){
echo Links table created!br;
}else{
echo no links table madeBR;
}
thanks,
Rob
John Holmes [EMAIL PROTECTED] wrote in message
001201c21ab5$0df073a0$b402a8c0@mango">news:001201c21ab5$0df073a0$b402a8c0@mango...
Your second method should work, but it's dependent on what your form
looks like and how your table was created. You obviously have a key set
for this column and you're trying to insert the same value twice, which
makes an error.
Show us what your form looks like, not the whole thing, just for the
checkboxes. Also, what does your CREATE TABLE look like for the table
your trying to insert this data into?
---John Holmes...
-Original Message-
From: Rob Packer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 7:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Insert an array into MySQL
Hi, I've seen a few post for this same thing but I can't seem to get
it
working. What I'm doing is taking a form with check boxes and putting
them
into an array. Then I'm attempting to INSERT them into the db, one
checkbox
value per row.
Okay, well I've tries 2 ways that I think should work and they only
insert
the first value. They both produce this error Duplicate entry '0' for
key
1 (which I don't understand) Anyway here is the code I'm trying...
(I'm not trying to use both blocks of code, just one or the other)
// First code
while(list($key,$value)=each($pagetype)){
//echo $value.br;//test
$links=INSERT INTO $username_links (links) VALUES ('$value');
$insert=mysql_query($links,$connection);
}
// Second code attempt
$number=count($pagetype);
for($a=0;$a$number;$a++){
$links=INSERT INTO $username_links (links) VALUES ('$pagetype[$a]');
$insert=mysql_query($links) or die(mysql_error());
//echo $pagetype[$a];//test
}
Thanks in advance...Robert
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Insert an array into MySQL
Nevermind, I got it. I had Unique for a field which made it mad.
Rob Packer [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
oops, sorry about the other post (I've got a baby that likes the
keyboard)...
Hi,
This is the form, which I had doubts about, but it seemed to put things
into
the array correctly when I tested it by printing it out.
I can't see how, it will print
key=0
value=index.html
key=1
value=about.html
key=2
value=whats_new.html
when I test it and then have a duplicate key. It's saying that I have 2
$pagetype[0] correct? Anyhow, here's the form...
INPUT TYPE=hidden NAME=pagetype[] VALUE='index.html'Home Page br
INPUT TYPE=checkbox NAME=pagetype[] VALUE='about.html'About Page br
INPUT TYPE=checkbox NAME=pagetype[] VALUE='whats_new.html'What's New
Pagebr
INPUT TYPE=checkbox NAME=pagetype[] VALUE='contact.html'Contact Pagebr
INPUT TYPE=checkbox NAME=pagetype[] VALUE='favorite_links.html'Favorite
Links br
The CREATE TABLE is this:
I define the table name from user input.
$query_links=CREATE TABLE $username_links (id INT(4) not null, links
VARCHAR(20) not null, UNIQUE (id));
if(mysql_query($query_links,$connection)){
echo Links table created!br;
}else{
echo no links table madeBR;
}
thanks,
Rob
John Holmes [EMAIL PROTECTED] wrote in message
001201c21ab5$0df073a0$b402a8c0@mango">news:001201c21ab5$0df073a0$b402a8c0@mango...
Your second method should work, but it's dependent on what your form
looks like and how your table was created. You obviously have a key set
for this column and you're trying to insert the same value twice, which
makes an error.
Show us what your form looks like, not the whole thing, just for the
checkboxes. Also, what does your CREATE TABLE look like for the table
your trying to insert this data into?
---John Holmes...
-Original Message-
From: Rob Packer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 23, 2002 7:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Insert an array into MySQL
Hi, I've seen a few post for this same thing but I can't seem to get
it
working. What I'm doing is taking a form with check boxes and putting
them
into an array. Then I'm attempting to INSERT them into the db, one
checkbox
value per row.
Okay, well I've tries 2 ways that I think should work and they only
insert
the first value. They both produce this error Duplicate entry '0' for
key
1 (which I don't understand) Anyway here is the code I'm trying...
(I'm not trying to use both blocks of code, just one or the other)
// First code
while(list($key,$value)=each($pagetype)){
//echo $value.br;//test
$links=INSERT INTO $username_links (links) VALUES ('$value');
$insert=mysql_query($links,$connection);
}
// Second code attempt
$number=count($pagetype);
for($a=0;$a$number;$a++){
$links=INSERT INTO $username_links (links) VALUES ('$pagetype[$a]');
$insert=mysql_query($links) or die(mysql_error());
//echo $pagetype[$a];//test
}
Thanks in advance...Robert
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
