extracting id from db from a form field

Hello everyone,

I need a little help. I've never tried to extract from a db in the
manner I'm trying. It's pretty simple and straightforward I believe, but
for some reason I can't figure out how.

What I have is a form with 1 simple field, and this field takes the ID
of the row I want returned.

Here's my code so far.

--index.php--

echo '

Re: extracting id from db from a form field

Hi David,
Try this..

if(!isset($_POST['ErrorCode'])) {
die('You did not enter an error code!');
} else {
$errorcode = $_POST['ErrorCode'];
$sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
$errorcode."' ");
if($sql && mysql_numrows($sql) > 0) {
$row = mysql_fetch_array($sql);
for($i=0; $i echo ("Error Code: ".$row[$i]['errorcode']."
");
echo ("Error Definition: ".$row[$i]['definition']."
");
echo ("
");
}
} else {
die('No Error Code found in database');
}
}

Have not tested this, and there may be a better "short-hand" way of
writing this, but hope it gets you on your way...

Best,
Karl

On May 27, 2011, at 2:11 PM, David McGlone wrote:

> Hello everyone,
>
> I need a little help. I've never tried to extract from a db in the
> manner I'm trying. It's pretty simple and straightforward I
> believe, but
> for some reason I can't figure out how.
>
> What I have is a form with 1 simple field, and this field takes the ID
> of the row I want returned.
>
> Here's my code so far.
>
> --index.php--
>
> echo '

Re: extracting id from db from a form field

Oh I forgot..

.... WHERE errorcode='".mysql_real_escape_string($errorcode)."');

Best,
Karl


On May 27, 2011, at 2:48 PM, Karl DeSaulniers wrote:

> Hi David,
> Try this..
>
> if(!isset($_POST['ErrorCode'])) {
> die('You did not enter an error code!');
> } else {
> $errorcode = $_POST['ErrorCode'];
> $sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
> $errorcode."' ");
> if($sql && mysql_numrows($sql) > 0) {
> $row = mysql_fetch_array($sql);
> for($i=0; $i > echo ("Error Code: ".$row[$i]['errorcode']."
");
> echo ("Error Definition: ".$row[$i]['definition']."
");
> echo ("
");
> }
> } else {
> die('No Error Code found in database');
> }
> }
>
> Have not tested this, and there may be a better "short-hand" way of
> writing this, but hope it gets you on your way...
>
> Best,
> Karl
>
> On May 27, 2011, at 2:11 PM, David McGlone wrote:
>
>> Hello everyone,
>>
>> I need a little help. I've never tried to extract from a db in the
>> manner I'm trying. It's pretty simple and straightforward I
>> believe, but
>> for some reason I can't figure out how.
>>
>> What I have is a form with 1 simple field, and this field takes
>> the ID
>> of the row I want returned.
>>
>> Here's my code so far.
>>
>> --index.php--
>>
>> echo '

Re: extracting id from db from a form field

On Fri, 2011-05-27 at 14:48 -0500, Karl DeSaulniers wrote:
> Hi David,
> Try this..
>
> if(!isset($_POST['ErrorCode'])) {
> die('You did not enter an error code!');
> } else {
> $errorcode = $_POST['ErrorCode'];
> $sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
> $errorcode."' ");
> if($sql && mysql_numrows($sql) > 0) {
> $row = mysql_fetch_array($sql);
> for($i=0; $i > echo ("Error Code: ".$row[$i]['errorcode']."
");
> echo ("Error Definition: ".$row[$i]['definition']."
");
> echo ("
");
> }
> } else {
> die('No Error Code found in database');
> }
> }
>
> Have not tested this, and there may be a better "short-hand" way of
> writing this, but hope it gets you on your way...

Thank you Karl, after a minute or two, or three ;-) I had it working,
but I had to change in the first line !isset to empty. For some reason
it wasn't working with !isset. and I had to
change: .$row[$i]['errorcode']. to .$row['errorcode']. because it wasn't
allowing for more than 1 digit in the error code number, but it was
displaying the correct error definition
and
.$row[$i]['definition']. to .$row['definition']. had to be changed
because it was displaying the error code and not the definition.

Now the only problem I've got to figure out is altering it so it doesn't
exclude row[0].

Blessings,
David M.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: extracting id from db from a form field

Hi David,
Yeah sorry, that was all of the top of the head, so I apologize if
anything was incorrect.
I am glad you got it working though..

Best,
Karl


On May 27, 2011, at 3:50 PM, David McGlone wrote:

> On Fri, 2011-05-27 at 14:48 -0500, Karl DeSaulniers wrote:
>> Hi David,
>> Try this..
>>
>> if(!isset($_POST['ErrorCode'])) {
>> die('You did not enter an error code!');
>> } else {
>> $errorcode = $_POST['ErrorCode'];
>> $sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
>> $errorcode."' ");
>> if($sql && mysql_numrows($sql) > 0) {
>> $row = mysql_fetch_array($sql);
>> for($i=0; $i >> echo ("Error Code: ".$row[$i]['errorcode']."
");
>> echo ("Error Definition: ".$row[$i]['definition']."
");
>> echo ("
");
>> }
>> } else {
>> die('No Error Code found in database');
>> }
>> }
>>
>> Have not tested this, and there may be a better "short-hand" way of
>> writing this, but hope it gets you on your way...
>
> Thank you Karl, after a minute or two, or three ;-) I had it working,
> but I had to change in the first line !isset to empty. For some reason
> it wasn't working with !isset. and I had to
> change: .$row[$i]['errorcode']. to .$row['errorcode']. because it
> wasn't
> allowing for more than 1 digit in the error code number, but it was
> displaying the correct error definition
> and
> .$row[$i]['definition']. to .$row['definition']. had to be changed
> because it was displaying the error code and not the definition.
>
> Now the only problem I've got to figure out is altering it so it
> doesn't
> exclude row[0].
>
> Blessings,
> David M.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: extracting id from db from a form field

To get row 0
make the for loop change to

for($i=-1;

Best,
Karl

On May 27, 2011, at 4:08 PM, Karl DeSaulniers wrote:

> Hi David,
> Yeah sorry, that was all of the top of the head, so I apologize if
> anything was incorrect.
> I am glad you got it working though..
>
> Best,
> Karl
>
>
> On May 27, 2011, at 3:50 PM, David McGlone wrote:
>
>> On Fri, 2011-05-27 at 14:48 -0500, Karl DeSaulniers wrote:
>>> Hi David,
>>> Try this..
>>>
>>> if(!isset($_POST['ErrorCode'])) {
>>> die('You did not enter an error code!');
>>> } else {
>>> $errorcode = $_POST['ErrorCode'];
>>> $sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
>>> $errorcode."' ");
>>> if($sql && mysql_numrows($sql) > 0) {
>>> $row = mysql_fetch_array($sql);
>>> for($i=0; $i >>> echo ("Error Code: ".$row[$i]['errorcode']."
");
>>> echo ("Error Definition: ".$row[$i]['definition']."
");
>>> echo ("
");
>>> }
>>> } else {
>>> die('No Error Code found in database');
>>> }
>>> }
>>>
>>> Have not tested this, and there may be a better "short-hand" way of
>>> writing this, but hope it gets you on your way...
>>
>> Thank you Karl, after a minute or two, or three ;-) I had it working,
>> but I had to change in the first line !isset to empty. For some
>> reason
>> it wasn't working with !isset. and I had to
>> change: .$row[$i]['errorcode']. to .$row['errorcode']. because it
>> wasn't
>> allowing for more than 1 digit in the error code number, but it was
>> displaying the correct error definition
>> and
>> .$row[$i]['definition']. to .$row['definition']. had to be changed
>> because it was displaying the error code and not the definition.
>>
>> Now the only problem I've got to figure out is altering it so it
>> doesn't
>> exclude row[0].
>>
>> Blessings,
>> David M.
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: extracting id from db from a form field

Actually you can keep $i as zero, it should still get row 0 now that
I think of it.

dont know how your table is set up so hard to tell.


On May 27, 2011, at 4:31 PM, David McGlone wrote:

> On Fri, 2011-05-27 at 16:13 -0500, Karl DeSaulniers wrote:
>> To get row 0
>> make the for loop change to
>>
>> for($i=-1;
>
> Hmm, when changing to -1 the error prints to the screen twice and when
> entering 0 I still get "You did not enter an error code!"
>
> Blessings,
> David M.
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: extracting id from db from a form field

Good 2 hear.

Pay it forward.. :)

On May 27, 2011, at 4:50 PM, David McGlone wrote:

> On Fri, 2011-05-27 at 16:13 -0500, Karl DeSaulniers wrote:
>> To get row 0
>> make the for loop change to
>>
>> for($i=-1;
>
> Karl, it's completely working now, I changed empty back to !isset and
> that did the trick. Got me curious now :-)
>
> Blessings,
> David M.
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php