Search:

I'd really appreciate anyone's help at this point! i'm really stuck with this 1 and 0 problem :(

When I run that code it says:

Variable isset: 1Variable not isset:

If anyone would be able to take a look at the code and help me in figuring out why it seems to only insert 1's and 0's into the mysql server, i would be forever grateful.
I'm tearing my hair out at...

DO you think that's what's causing it to insert 1's and 0's instead of data from the form?

Don't suppose you have any ideas Derokorian?

This last one is bugging the hell out of me :(
I can't figure out why it's posting 1's and 0's...

If I use the function NOW() then it returns:


I'm not concerned about that at the moment.

After adding in the question mark at the end (and removing one preceeding the INET_ATON), it now...

Part 2:


//check that the required fields are not empty
if ($EmployeeName == '' || $EmployeeRef == '' || $DeclarationCheck == '')
{
$error = 'ERROR: Please fill in all required fields!';...

Thanks very much for the input Derokorian.

I've refined (or is it bloated?) the code now to the below and fixed other errors that I spotted along the way.

The only issue i'm facing at the...

So, the only way to do it is to have 85 different isset statements?

Thanks very much NogDog, I think i'm starting to get somewhere now!
I've commented out the mysql_real_escape_string piece and now it's progressing past that error.

The only thing that I don't...

Yep, you're dead right :)

So, now it's complaining about:


$_POST = array_map('mysql_real_escape_string',$_POST);

on line 22
the error is shown as:

Well,
clearly i'm doing something wrong because when I press submit, i get the following as the result:

part 2:



//check that the required fields are not empty
if ($EmployeeName == '' || $EmployeeRef == '' || $DeclarationCheck == '')
{
$error = 'ERROR: Please fill in all required fields!';...

Thanks guys.
I've taken your advice and used mysqli instead of the (previously unbeknownst to me) depreciated mysql_connect() method.

Below is my new code.
Is this any good?
(splitting it into...

Hi all,
I'm trying to create a form that will insert into a mysql database.
The code for the php file is below:



<?

//set database connection parameters
$hostname = "127.0.0.1:3307"; //...

After I add error_reporting(E_ALL ^ E_NOTICE); to the php file, the error messages stop being logged to the log file and the front end doesn't display any errors either (apart from the if else error...

The error is the same as before:

[Thu Oct 11 22:59:09 2012] [error] [client x.x.x.x] PHP Notice: Undefined variable: SumMiles in /home/test/public_html/Beta/Scripts/formsubmit.php on line 46,...

I posted two more replies to the thread but they are waiting for moderator approval before being posted for some reason.
Apologies that they may appear out of order!

Part 3 of 3


<!--<form name="sumform">-->
<table>
<tr>
<td></td>
<td...

Part 2 of 3



<form class="sigPad" method="post" action="Scripts/tjwformsubmit.php">
<table width="500" cellpadding="3">
<td colspan="6">
...

The html for the form is below, which includes the calculation code for how to come up with those fields.
The sum values appear on the site when you type them live, but aren't posted for some...

Thanks for the replies guys.
I've added error_reporting(E_ALL ^ E_NOTICE); into the php file but it now doesn't report anything in the log file (but still errors on the front end) so i took it out...

Hi guys,
Thank you SO much for providing code like this, i'm successfully using it in a form i'm creating.
When i'm going through the form and inserting values into text boxes, the total...