PHP IDE :: NuSphere Forums :: View topic

Posted: Wed Aug 16, 2006 7:43 pm

My goal is to make a form with multiple checkboxes.

For sack of example, here is a very simple HTML I am having trouble with running the DB Form Wizard on:

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form name="form1" method="post" action="">
<table width="75%" border="1">
<tr>
<td><input type="checkbox" name="checkbox" value="checkbox"></td>
</tr>
<tr>
<td><input type="checkbox" name="checkbox" value="checkbox"></td>
</tr>
</table>

</form>
</body>
</html>

Now, here is the table I created for this very simple 2 checkbox form:

Create table checkbox (
id int unsigned not null auto_increment primary key,
checkbox int (1),
checkbox_value varchar (100)
);

After running HTML through Wizard, I run the form and check a box and when save get the following error message:

Notice: Undefined variable: checkbox in C:\Program Files\Apache Group\Apache2\htdocs\Affirmative_Action\Forms\CheckBoxForm.php5 on line 60
Record has been added successfully. Click here to return homepage.

Here is the code for 57-60:

$sql="insert into checkbox
(checkbox,checkbox_value)
Values
('$checkbox','$checkbox_value')";

Please advise me regarding why I can't get this to work.

Thank you.

Posted: Wed Aug 16, 2006 7:45 pm

I forgot to mention that their is a blank database entry. I can tell because the id keeps incrementing.

Thank you.

Posted: Wed Aug 16, 2006 8:05 pm

If I F7 debugger through I get this error:

Failed to map
c:\program files\nusphere\phped\include_lib\db_myutil.inc remote file to publishing account

And it occurs at this place in the code:

# you may want to change path to db_utils.inc
require_once $site["path"].'/include_lib/db_myutil.inc';
ensureConnectionAvailable();

Please help. I have other scripts that I created working OK with my MySQL that are doing insert, select, etc.

Posted: Thu Aug 17, 2006 9:59 am

Here is another script I tried to test. I downloaded the newest update, and ran the following html through the Wizard:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form method="post" action="path to script">
<input type="checkbox" id="colors[]" value="red" /> Red
<input type="checkbox" id="colors[]" value="blue" /> Blue
<input type="checkbox" id="colors[]" value="green" /> Green
<input type="checkbox" id="colors[]" value="yellow" /> Yellow
</form>

</body>
</html>

I created a table called colors with the following code:

Create table colors (
id int unsigned not null auto_increment primary key,
colors varchar (30)
);

After I run the Wizard, I only see one checkbox called colors. When I check the data input I see 1, and that's all. I am no longer getting the previous errors messages mentioned.

Can you please advise me why the Wizard is doing this and only creating one checkbox.

Thank you.

Posted: Thu Aug 17, 2006 10:47 am

Hi, I am not sure I understand what you are trying to do. What do you mean by running html throughthe wizzard - DB Wizzard doesn't take any html input. Do you probably mena that you are runing this code with PhpED's Web server?

Posted: Thu Aug 17, 2006 10:50 am

I cute and paste HTML into a Nusphere PHP5 page and save.

Then, I run the DB Form Wizard, and then I go through the various Wizard Windows and answer the questions.

Can you please advise me further on how to get your Wizard to interpret a form with multiple checkboxes and to do the proper input into a MySQL table.

Thank you.

Posted: Fri Aug 18, 2006 6:20 am

Quote:

If I F7 debugger through I get this error:

Failed to map
c:\program files\nusphere\phped\include_lib\db_myutil.inc remote file to publishing account

And it occurs at this place in the code:

# you may want to change path to db_utils.inc
require_once $site["path"].'/include_lib/db_myutil.inc';
ensureConnectionAvailable();

Please help. I have other scripts that I created working OK with my MySQL that are doing insert, select, etc.

Open Project Properties window, select mapping tab,
add new entry and fill only Local Path and Remote Path. Both should contain
c:\program files\nusphere\phped\include_lib\

Alternatively, you may want to copy db_myutil.inc and the other files from c:\program files\nusphere\phped\include_lib\ to a directory under Apache Document Root.

Posted: Fri Aug 18, 2006 8:09 am

Regarding DB Wizard.

Quote:

After running HTML through Wizard, I run the form and check a box and when save get the following error message:

Notice: Undefined variable: checkbox in C:\Program Files\Apache Group\Apache2\htdocs\Affirmative_Action\Forms\CheckBoxForm.php5 on line 60

It means that $checkbox variable was not posted from the form. Please make sure there a field with name "checkbox" in your form.
When submitted it first appears in the $_POST['checkbox'], then it enters $checkbox after this statement if(!empty($_POST)) extract($_POST);