phppup

March 1, 2012

WOW! found the same line of code in my UPDATE script. Took it out and I'm working fine now.

Thanks a TON!

(i think i'll quit while ahead... LOL)

So what EXACTLY is that line saying?

And is it necessary in one way or another as a double-check process of the form?

March 1, 2012

It worked prviously with it (i think!), but i took it out and it seems to have repaired the problem.

So what EXACTLY is that line saying?

And is it necessary in one way or another as a double-check process of the form?

March 1, 2012

CONNECT

if(isset($_POST['action']) && $_POST['action'] == 'submitform')

{

$roastturkey = $_POST['roastturkey'];

$broccoli = $_POST['broccoli'];

$brisket = $_POST['brisket'];

$carrots = $_POST['carrots'];

}

$sql = "INSERT INTO pass (roastturkey,broccoli,brisket,carrots) VALUES ('$roastturkey','$broccoli','$brisket','$carrots')";

$result=mysql_query($sql);

if($result){

echo "Successful";

}else {

echo "ERROR";

}

Fairly simple, I think, and it used to work.

** Disclaimer: Not responsible if this code causes hunger or urges to snack **

March 1, 2012

I will start posting code if I have to, but first, the only "adjustment" made to the actual database was that I may have added to columns (at various locations between others) and then I later deleted them.

I have since replaced them as a troubleshooting technique, but their NAMES are NOT receiving any values (which is why I removed them in the first place).

Does this sort of manuever affect the tables??

(I'm a newbie, so maybe I just messed it up... LOL)

March 1, 2012

My database was working fine (for test purposes) a week ago. Now, it will not record data input from my forms.

If I add a new record, it adds the record, but none of the data.

If I update a record, it erases the values.

The forms and attached scripts have NOT undergone any changes, and they DO provide SUCCESS messages.

Ideas?

March 1, 2012

I may be on my way to a solution.

Question: If the code below will scan ALL fields of my form, how can I add to the code to eliminate just one or two of the inputs, while leaving the remaining 30?

$myUpdateList = array();foreach($_POST as $indexName => $value) { $myUpdateList[] = "$indexName = \"$value

February 29, 2012

okay.

still got similar message.

There is no success message so I have to assume I'm connecting.

Gonna need to check the database directly, but got same messages twice (only variations were from order number and item quantitieis.)

February 29, 2012

Still runnning your code and I got:

Array

(

[record_id] => 2

[roastturkey] => 4.00

[broccoli] => 0.00

[brisket] => 0.00

[carrots] => 0.00

[submitpass] => Submit Order

)

February 29, 2012

Drum: I used your code in place of mine (with commented areas remaining commented) and got a BLANK screen response.

Pikachu: How shall i do that? (please be specific as to where to place code if you provide any)

February 29, 2012

I only get messages from "echo MySQL" when there is success, so I have to assume that there are no messages on failure because there is NO DATA being transferred. The $id_record connection is not being made. :-(

February 29, 2012

It did NOT work.

I commented OUT these lines, and hardcoded the third, and DID get a SUCCESS message:

#$pass = array();foreach($_POST as $indexName => $value) { $pass[] = "$indexName = \"$value\"";}

#$fields = implode(",", $pass);

$sql=("UPDATE pass SET carrots ='6' WHERE id = '5' ");

So now what??

February 29, 2012

Am i adding anyplace specific, because when I put it where I thought it should go, I still get the same failure ERROR.

February 29, 2012

Evidently you're assuming that I understand certain things that i do NOT know, and I'm making the same mistake with you. I am trying to save a little room in the thread, but apparently that is backfiring too.

Page 1 is a dropdown that sorts the ID's to become $record_id (code on previous page)

works fine.

Page 2 displays the form with inputs that can be changed (also displays okay)

CONNECT

 $record_id = (isset($_POST['record_id'])) ? $_POST['record_id'] : '';
if(!empty($record_id))
{

$result = mysql_query("SELECT * FROM pass WHERE id = $record_id ")
or die(mysql_error());

$row = mysql_fetch_array( $result );

echo "<FORM name='orderpage' action='myupdatepage.php' method='post'>";

echo "<tr><td>"; 
echo "<select name='roastturkey'>";
echo        "<option value='0.00'  " . ($row['roastturkey'] == 0.00 ? 'selected="selected"' : '') . ">0</option>";
echo        "<option value='1.00'  " . ($row['roastturkey'] == 1.00 ? 'selected="selected"' : '') . ">1</option>";
echo        "<option value='2.00' " . ($row['roastturkey'] == 2.00 ? 'selected="selected"' : '') . ">2</option>";
echo        "<option value='3.00' " . ($row['roastturkey'] == 3.00 ? 'selected="selected"' : '') . ">3</option>";
echo        "<option value='4.00' " . ($row['roastturkey'] == 4.00 ? 'selected="selected"' : '') . ">4</option>";
echo        "<option value='5.00' " . ($row['roastturkey'] == 5.00 ? 'selected="selected"' : '') . ">5</option>";
echo        "<option value='6.00' " . ($row['roastturkey'] == 6.00 ? 'selected="selected"' : '') . ">6</option>";
echo        "<option value='7.00' " . ($row['roastturkey'] == 7.00 ? 'selected="selected"' : '') . ">7</option>";
echo        "<option value='8.00' " . ($row['roastturkey'] == 8.00 ? 'selected="selected"' : '') . ">8</option>";
echo        "<option value='9.00' " . ($row['roastturkey'] == 9.00 ? 'selected="selected"' : '') . ">9</option>";
echo        "<option value='10.00'  " . ($row['roastturkey'] == 10.00 ? 'selected="selected"' : '') . ">10</option>";
echo        "      </select></td><td rowspan='2'>ROAST TURKEY</span></td><td rowspan='2'>7.00 LB</span></td> ";
echo        "                           <td rowspan='2'>ujiujjpooj</span></td><td rowspan='2'> <!-- FILLER --> </span></td>";
echo        "       <td> <!-- BLANK CELL --> </td><td>STEAMED VEGETABLES</td><td>16.00 LB</td><td>ujiujjpooj</td>";

echo "</tr>"; 
echo "<tr><td>  <!-- FILLER  for SPAN--> </td>";
echo "      <td>";
echo "      <select name='broccoli'>";
echo        "<option value='0.00'  " . ($row['broccoli'] == 0.00 ? 'selected="selected"' : '') . ">0</option>";
echo        "<option value='1.00'  " . ($row['broccoli'] == 1.00 ? 'selected="selected"' : '') . ">1</option>";
echo        "<option value='2.00' " . ($row['broccoli'] == 2.00 ? 'selected="selected"' : '') . ">2</option>";
echo        "<option value='3.00' " . ($row['broccoli'] == 3.00 ? 'selected="selected"' : '') . ">3</option>";
echo        "<option value='4.00' " . ($row['broccoli'] == 4.00 ? 'selected="selected"' : '') . ">4</option>";
echo        "<option value='5.00' " . ($row['broccoli'] == 5.00 ? 'selected="selected"' : '') . ">5</option>";
echo        "<option value='6.00' " . ($row['broccoli'] == 6.00 ? 'selected="selected"' : '') . ">6</option>";
echo        "<option value='7.00' " . ($row['broccoli'] == 7.00 ? 'selected="selected"' : '') . ">7</option>";
echo        "<option value='8.00' " . ($row['broccoli'] == 8.00 ? 'selected="selected"' : '') . ">8</option>";
echo        "<option value='9.00' " . ($row['broccoli'] == 9.00 ? 'selected="selected"' : '') . ">9</option>";
echo        "<option value='10.00'  " . ($row['broccoli'] == 10.00 ? 'selected="selected"' : '') . ">10</option>";
echo "      </select></td><td>  BROCCOLI</td><td> <!-- NO PRICE HERE --> </td><td>ujiujjpooj</td>";

echo "</tr>"; 
echo "<tr><td>"; 
echo "      <select name='brisket'>";
echo        "<option value='0.00'  " . ($row['brisket'] == 0.00 ? 'selected="selected"' : '') . ">0</option>";
echo        "<option value='1.00'  " . ($row['brisket'] == 1.00 ? 'selected="selected"' : '') . ">1</option>";
echo        "<option value='2.00' " . ($row['brisket'] == 2.00 ? 'selected="selected"' : '') . ">2</option>";
echo        "<option value='3.00' " . ($row['brisket'] == 3.00 ? 'selected="selected"' : '') . ">3</option>";
echo        "<option value='4.00' " . ($row['brisket'] == 4.00 ? 'selected="selected"' : '') . ">4</option>";
echo        "<option value='5.00' " . ($row['brisket'] == 5.00 ? 'selected="selected"' : '') . ">5</option>";
echo        "<option value='6.00' " . ($row['brisket'] == 6.00 ? 'selected="selected"' : '') . ">6</option>";
echo        "<option value='7.00' " . ($row['brisket'] == 7.00 ? 'selected="selected"' : '') . ">7</option>";
echo        "<option value='8.00' " . ($row['brisket'] == 8.00 ? 'selected="selected"' : '') . ">8</option>";
echo        "<option value='9.00' " . ($row['brisket'] == 9.00 ? 'selected="selected"' : '') . ">9</option>";
echo        "<option value='10.00'  " . ($row['brisket'] == 10.00 ? 'selected="selected"' : '') . ">10</option>";
echo "      </select></td><td>BRISKET OF BEEF</td><td>32.00 LB</td><td>ujiujjpooj</td><td> <!-- FILLER --> </td>";
echo "      <td>";
echo "      <select name='carrots'>";
echo        "<option value='0.00'  " . ($row['carrots'] == 0.00 ? 'selected="selected"' : '') . ">0</option>";
echo        "<option value='1.00'  " . ($row['carrots'] == 1.00 ? 'selected="selected"' : '') . ">1</option>";
echo        "<option value='2.00' " . ($row['carrots'] == 2.00 ? 'selected="selected"' : '') . ">2</option>";
echo        "<option value='3.00' " . ($row['carrots'] == 3.00 ? 'selected="selected"' : '') . ">3</option>";
echo        "<option value='4.00' " . ($row['carrots'] == 4.00 ? 'selected="selected"' : '') . ">4</option>";
echo        "<option value='5.00' " . ($row['carrots'] == 5.00 ? 'selected="selected"' : '') . ">5</option>";
echo        "<option value='6.00' " . ($row['carrots'] == 6.00 ? 'selected="selected"' : '') . ">6</option>";
echo        "<option value='7.00' " . ($row['carrots'] == 7.00 ? 'selected="selected"' : '') . ">7</option>";
echo        "<option value='8.00' " . ($row['carrots'] == 8.00 ? 'selected="selected"' : '') . ">8</option>";
echo        "<option value='9.00' " . ($row['carrots'] == 9.00 ? 'selected="selected"' : '') . ">9</option>";
echo        "<option value='10.00'  " . ($row['carrots'] == 10.00 ? 'selected="selected"' : '') . ">10</option>";
echo "      </select></td><td>CARROTS</td><td> <!-- NO PRICE HERE --> </td><td>ujiujjpooj</td>";
echo "</tr>"; 
<td><input type='submit' name='submitpass' value='Submit Order'>

Now, if anything is to be UPDATED, the changes would have been made and when submitted to myupdatepage.php I would get a SUCCESS, not ERROR

CONNECT

$roastturkey = $_POST['roastturkey'];
$broccoli = $_POST['broccoli'];
$brisket = $_POST['brisket'];
$carrots = $_POST['carrots'];    

$mytabletest = array();foreach($_POST as $indexName => $value) {     $mytabletest[] = "$indexName = \"$value\"";}
$fields = implode(",", $mytabletest);
$sql=("UPDATE mytabletest SET $fields WHERE id = $record_id ");

if($result){
echo "Successful";
}
else {
echo "ERROR";
}

I need to know what to add, and WHERE to place it.

February 29, 2012

I'm unable to get from page 2 to page 3 with a SUCCESSful UPDATING of the DB

February 29, 2012

ALL the code is posted at bottom of this page 2

February 29, 2012

the first page has this code to display the fields:

connect:

$result = mysql_query("SELECT * FROM pass WHERE id = $record_id ")

or die(mysql_error());

$row = mysql_fetch_array( $result );

echo echo echo submit button

the second file that gets called AFTER submission of UPDATES is:

if(isset($_POST['action']) && $_POST['action'] == 'submitform')

{ $roastturkey = $_POST['roastturkey'];

$broccoli = $_POST['broccoli'];

$brisket = $_POST['brisket'];

$carrots = $_POST['carrots'];

}

$pass = array();foreach($_POST as $indexName => $value) { $pass[] = "$indexName = \"$value\"";}

$fields = implode(",", $pass);

$sql=("UPDATE pass SET $fields WHERE id = $record_id

$result=mysql_query($sql); ");

if($result){

echo "Successful";

else {

echo "ERROR";

}

so where exactly shall i put new code??

February 29, 2012

Good morning everyone!

OKAY, let's sort of forget the aforementioned pages for a minute, because they seem to be working (kind of).

Here's the issue:

My form is created by this code

if(mysql_num_rows($query) > 0){ while($row = mysql_fetch_assoc($query)) { $record_id = $row['ID']; echo '<option value="' . $record_id . '">' . $record_id . '</option>'; }}

which gives me a dropdown of ALL my id's by row, and renames them $record_id

This takes me to a page that carries that record_id and displays a form with values as inputs that can be changed.

If there are UPDATES made, then hitting the submit button goes to another php script (shown previously) that should make the update and offer a Success message."

My problem here is that updates are NOT occurring, and I am recieving a scripted ERROR message.

Apparently my $record_id is NOT being forwarded beyond the first instance.

How do I bring it to this second file? Should I be using SESSION, or is a hidden file in order?

And where shall it be placed?

February 27, 2012

I originally had a

if(isset($_POST['action']) && $_POST['action'] == 'submitform')

{ itemized items }

but took it out while trying to de-bug this scripting

February 27, 2012

nO, NO , NO.

I'm saying that a book said to have that post info on top of page.

February 27, 2012

The PHP book said to put it there, so I put it there. Meanwhile, I need to get the UPDATES into the correct record ID using the form. Ideas?

February 27, 2012

OKAY, I pulled out the conditional and it printed:

Array

(

[roastturkey] => 2.00

[broccoli] => 0.00

[brisket] => 6.00

[carrots] => 0.00

[submitpass] => Submit Order

)

1

so now the question is, How will it know which row ID to post the new data to?

February 27, 2012

Notice: Undefined variable: result in... line 91

This correcsponds to my: if($result){ towards the end.

February 27, 2012

AFTER CONNECTION:

//save the data on the DB and send the email

if(isset($_POST['action']) && $_POST['action'] == 'submitform')
{
//recieve the variables

$roastturkey = $_POST['roastturkey'];
$broccoli = $_POST['broccoli'];
$brisket = $_POST['brisket'];
$carrots = $_POST['carrots'];   }


$record_id = (isset($_POST['record_id'])) ? $_POST['record_id'] : '';//check for $record_id emptiness
if(!empty($record_id)){

echo "<pre>", print_r($_POST), "</pre>";


$testtable = array();foreach($_POST as $indexName => $value) {     $testtable[] = "$indexName = \"$value\"";}
$fields = implode(",", $testtable);
$sql=("UPDATE testtable SET $fields WHERE id = $record_id ");

echo "<pre>", print_r($_POST), "</pre";

echo "$sql";

$result=mysql_query($sql);	

}
if($result){
echo "Successful";
}

else {
echo "ERROR";
}

February 27, 2012

Not sure if I was posting it correctly, so i stuck it in 3 different places, and NO MESSAGES

February 27, 2012

No messages. Just the same ERROR message from my own script. So is it not grabbing the fields, or is it not grabbing the record_id number?

Sign In

phppup

Posts

Joined

Last visited

Days Won

Content Type

Profiles

Forums

Posts posted by phppup

DB does NOT record data

DB does NOT record data

DB does NOT record data

DB does NOT record data

DB does NOT record data

a quick code edit, please

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

any easy way to list UPDATE columns

Browse

Activity

Important Information