Re: [PHP] PHP Form submitting to MySQL not working...
On Thu, 2010-06-03 at 08:56 -0500, Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Do you have any examples of code at all? It sounds like a file it's requiring is missing, but you haven't given the full error there either. Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] PHP Form submitting to MySQL not working...
On Thu, Jun 3, 2010 at 7:26 PM, Steve Marquez smarq...@marquez-design.com wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php 1. Did you do any upgrades recently ? 2. What is your code ? -- Nilesh Govindarajan Facebook: nilesh.gr Twitter: nileshgr Website: www.itech7.com Cheap and Reliable VPS Hosting: http://j.mp/arHk5e -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Form submitting to MySQL not working...
Sorry I wasn't specific enough. I'll include the files.!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
http://www.w3.org/TR/html4/loose.dtd;
html
head
titlePrayer Form/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link href=css/prayer.css rel=stylesheet type=text/css
script type=text/javascript
// specify the name of your form
var thisForm = form1;
// load field names and default values into list
var defaultVals = new Array();
defaultVals[0] = new Array(date, (Date here));
// populate fields with default values on page load
function MPLoadDefaults() {
with (document.forms[thisForm]) {
for (var n=0; ndefaultVals.length; n++) {
var thisField = defaultVals[n][0];
var thisDefault = defaultVals[n][1];
if (elements[thisField].value == '')
elements[thisField].value = thisDefault;
}}}
// clear default value from field when selected
function MPClearField(field) {
var fieldName = field.name;
for (var n=0; ndefaultVals.length; n++) {
var thisField = defaultVals[n][0];
var thisDefault = defaultVals[n][1];
if (thisField == fieldName) {
if (field.value == thisDefault) field.value = '';
break;
}}}
// clear all defaults when form is submitted
function MPClearAll() {
with (document.forms[thisForm]) {
for (var n=0; ndefaultVals.length; n++) {
var thisField = defaultVals[n][0];
var thisDefault = defaultVals[n][1];
if (elements[thisField].value == thisDefault)
elements[thisField].value = '';
}}}
/script
style type=text/css
!--
body {
font-family:Verdana, Arial, Helvetica, sans-serif, Lucida Grande;
font-size: 14px;
line-height:18px;
color: #33;
margin: 0 0 0 0;
background-color: #CDCEDA;
background-image: url(images/prayer_body_bg.jpg);
background-position: center;
background-repeat: repeat-y;
}
--
/style/head
!-- body OnLoad=document.form1.date.focus(); --
!-- body onload=MPLoadDefaults() --
body
form name=form1 method=post action=db-code.php
table width=100% height=0 border=0 cellpadding=0 cellspacing=0 bgcolor=#99
tr
tdimg src=spacer.gif width=5 height=5/td
/tr
/table
table width=748 border=0 align=center cellpadding=0 cellspacing=0
tr
td rowspan=2 valign=top bgcolor=#CCtable border=0 align=center cellpadding=10 cellspacing=0
tr
td!-- input name=date type=date class=date_field id=textfield value= size=30 onfocus=MPClearField(this) --
input name=date type=date class=date_field id=textfield value=?php echo date('F j, Y'); ? size=30
/td
/tr
tr
td class=prayer-field valign=toptextarea name=prayer cols=60 rows=19 class=form_fields id=prayer/textarea/td
/tr
tr
tdinput name=Reset type=reset class=NormalText value=Reset
input name=Submit2 type=submit class=NormalText value=Submit/td
/tr
tr
td valign=top bordercolor=#99?php include random_images.php; ?
/td
/tr
/table
/form
/body
/html?PHP
// log into our local server using the MySQL root user.
$dbh = mysql_connect( localhost, ***, );
// select the db.
mysql_select_db( prayer ) or die ( mysql_error() . \n );
$date = $_POST[date];
$prayer = $_POST[prayer];
//$prayer = nl2br ($prayer);
$prayer = addslashes ($prayer);
$insert_data = INSERT into prayer (view,date,prayer)
Values ('view', '$date', '$prayer');;
$response = mysql_query( $insert_data, $dbh );
if(mysql_error()) die ('database errorbr'. mysql_error());
?
?PHP
// and read it back for printing purposes.
//$get_table_data = SELECT * FROM prayer WHERE date=\$date\;
//$response = mysql_query( $get_table_data, $dbh );
// now print it out for the user.
// if ( $one_line_of_data = mysql_fetch_array( $response ) ) {
// extract ( $one_line_of_data );
// }
$id_num = mysql_insert_id();
?
?PHP
//this is the update
$update_data = UPDATE prayer SET view = 'a href=\view_prayer.php?id_num=$id_num\view/a' WHERE id_num = \$id_num\;
$response = mysql_query( $update_data, $dbh );
if(mysql_error()) die ('database errorbr'. mysql_error());
// and read it back for printing purposes.
$get_table_data = SELECT * FROM prayer where id_num=\$id_num\;;
$response = mysql_query( $get_table_data, $dbh );
// now print it out for the user.
if ( $one_line_of_data = mysql_fetch_array( $response ) ) {
extract ( $one_line_of_data );
}
?
html
head
titlePrayer for ?php echo $date\n; ?/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
link href=css/prayer.css rel=stylesheet type=text/css
style type=text/css
!--
body {
background-color: #EE;
margin: 10px 0 0 0;
}
--
/style/head
body
div id=mContent
?PHP
$prayer = nl2br ($prayer);
$prayer = stripslashes ($prayer);
echo div id = 'date'$datep //div;
echo div id ='prayer_space'$prayer/div;
$query = SELECT view,date,prayer FROM prayer ORDER BY id_num DESC LIMIT 30;
$result = mysql_query($query) or die(Query failed);
echo
Re: [PHP] PHP Form submitting to MySQL not working...
Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Where exactly did you see this error? 1) In your browser when you tried loading the form? 2) In your browser when you submitted the form? 3) In the error logs of your web server? Other questions: What type of web server are you running? Did your cat stomp on your keyboard? Are the files stored locally or are they on a network/remote drive? Children doing things they should not be doing? (Happened to me once...) Are you accessing the files via http://localhost/... ?? or as a local file? -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Form submitting to MySQL not working...
Steve Marquez wrote: I am running Apache (not sure which version, where do I find that?) it is running on a Macbook Pro. The error happened when I submitted the form. Sorry, should have been more specific. Where did you see the error? In your browser, error logs of your web server, etc... ? If this error was displayed in your browser, you should look in your apache error log file at that corresponding time to see if it has any more information. The MySQL DB is hosted locally on my machine. No cat here at the office, no children either, they are all at home. :) -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP Form submitting to MySQL not working...
-Original Message- From: Jim Lucas [mailto:li...@cmsws.com] Sent: Thursday, June 03, 2010 11:38 AM To: php General List Cc: Steve Marquez Subject: Re: [PHP] PHP Form submitting to MySQL not working... Steve Marquez wrote: I am running Apache (not sure which version, where do I find that?) it is running on a Macbook Pro. The error happened when I submitted the form. Sorry, should have been more specific. Where did you see the error? In your browser, error logs of your web server, etc... ? If this error was displayed in your browser, you should look in your apache error log file at that corresponding time to see if it has any more information. The MySQL DB is hosted locally on my machine. No cat here at the office, no children either, they are all at home. :) -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php What did your error log file say? it should tell you the path and the name of the file that was being called; then go and look to see if the file exists. __ Information from ESET Smart Security, version of virus signature database 5169 (20100603) __ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Form submitting to MySQL not working...
Steve, SERVER_SOFTWARE is a variable that will give you which apache version you are actually using. Just drop a one - liner in a test.php as this : * * * ?php phpinfo(); ? * You can look for the above variable. Any other ideas others may have, please share. On Thu, Jun 3, 2010 at 9:31 PM, HallMarc Websites sa...@hallmarcwebsites.com wrote: -Original Message- From: Jim Lucas [mailto:li...@cmsws.com] Sent: Thursday, June 03, 2010 11:38 AM To: php General List Cc: Steve Marquez Subject: Re: [PHP] PHP Form submitting to MySQL not working... Steve Marquez wrote: I am running Apache (not sure which version, where do I find that?) it is running on a Macbook Pro. The error happened when I submitted the form. Sorry, should have been more specific. Where did you see the error? In your browser, error logs of your web server, etc... ? If this error was displayed in your browser, you should look in your apache error log file at that corresponding time to see if it has any more information. The MySQL DB is hosted locally on my machine. No cat here at the office, no children either, they are all at home. :) -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php On a side note; yes, as you can see I am still alive and well. Business has slowed down enough that I had time to actually read a few posts! Marc Hall HallMarc Websites www.hallmarcwebsites.com __ Information from ESET Smart Security, version of virus signature database 5169 (20100603) __ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Regards, Shreyas
RE: [PHP] PHP Form submitting to MySQL not working...
-Original Message- From: Jim Lucas [mailto:li...@cmsws.com] Sent: Thursday, June 03, 2010 11:38 AM To: php General List Cc: Steve Marquez Subject: Re: [PHP] PHP Form submitting to MySQL not working... Steve Marquez wrote: I am running Apache (not sure which version, where do I find that?) it is running on a Macbook Pro. The error happened when I submitted the form. Sorry, should have been more specific. Where did you see the error? In your browser, error logs of your web server, etc... ? If this error was displayed in your browser, you should look in your apache error log file at that corresponding time to see if it has any more information. The MySQL DB is hosted locally on my machine. No cat here at the office, no children either, they are all at home. :) -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php On a side note; yes, as you can see I am still alive and well. Business has slowed down enough that I had time to actually read a few posts! Marc Hall HallMarc Websites www.hallmarcwebsites.com __ Information from ESET Smart Security, version of virus signature database 5169 (20100603) __ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP Form submitting to MySQL not working...
Strangest thing... it just started working again. Odd. Is there an easy way to view the error logs? As you can tell, I am still a novice at this. I am on Apache2 Thanks for your help. -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325 On Jun 3, 2010, at 9:53 AM, Jim Lucas wrote: Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Where exactly did you see this error? 1) In your browser when you tried loading the form? 2) In your browser when you submitted the form? 3) In the error logs of your web server? Other questions: What type of web server are you running? Did your cat stomp on your keyboard? Are the files stored locally or are they on a network/remote drive? Children doing things they should not be doing? (Happened to me once...) Are you accessing the files via http://localhost/... ?? or as a local file? -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
Re: [PHP] PHP Form submitting to MySQL not working...
On Thu, 2010-06-03 at 12:58 -0500, Steve Marquez wrote: Strangest thing... it just started working again. Odd. Is there an easy way to view the error logs? As you can tell, I am still a novice at this. I am on Apache2 Thanks for your help. It depends. On most Linux distros there are log viewers that let you look at all the different logs from one drop-down menu. Otherwise, the logs are all just text files, so you can view them in any text editor from kate to notepad to vim. Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] PHP Form submitting to MySQL not working...
Steve, Do you know where Apache is installed? If yes, you have something like error.log and access.log. Find them and nail them them down. I am a novice, too and the best way to learn is to answer here and getting corrected by other PHP gurus! So, all in the name of learning! :) --Shreyas On Thu, Jun 3, 2010 at 11:28 PM, Steve Marquez smarq...@marquez-design.comwrote: Strangest thing... it just started working again. Odd. Is there an easy way to view the error logs? As you can tell, I am still a novice at this. I am on Apache2 Thanks for your help. -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325 On Jun 3, 2010, at 9:53 AM, Jim Lucas wrote: Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Where exactly did you see this error? 1) In your browser when you tried loading the form? 2) In your browser when you submitted the form? 3) In the error logs of your web server? Other questions: What type of web server are you running? Did your cat stomp on your keyboard? Are the files stored locally or are they on a network/remote drive? Children doing things they should not be doing? (Happened to me once...) Are you accessing the files via http://localhost/... ?? or as a local file? -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- Regards, Shreyas
Re: [PHP] PHP Form submitting to MySQL not working...
On Fri, 2010-06-04 at 00:25 +0530, Shreyas wrote: Steve, Do you know where Apache is installed? If yes, you have something like error.log and access.log. Find them and nail them them down. I am a novice, too and the best way to learn is to answer here and getting corrected by other PHP gurus! So, all in the name of learning! :) --Shreyas On Thu, Jun 3, 2010 at 11:28 PM, Steve Marquez smarq...@marquez-design.comwrote: Strangest thing... it just started working again. Odd. Is there an easy way to view the error logs? As you can tell, I am still a novice at this. I am on Apache2 Thanks for your help. -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325 On Jun 3, 2010, at 9:53 AM, Jim Lucas wrote: Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Where exactly did you see this error? 1) In your browser when you tried loading the form? 2) In your browser when you submitted the form? 3) In the error logs of your web server? Other questions: What type of web server are you running? Did your cat stomp on your keyboard? Are the files stored locally or are they on a network/remote drive? Children doing things they should not be doing? (Happened to me once...) Are you accessing the files via http://localhost/... ?? or as a local file? -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? You haven't said what sort of operating system you're using. In Linux, most of the logs are kept in sub-directories of /var/log I believe. Windows, well they could be scattered anywhere. MacOS, not too sure about that. Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] PHP Form submitting to MySQL not working...
True. Since I am a Windows user, I find it here : *C:\Program Files\EasyPHP 3.0\apache\logs* --Shreyas On Fri, Jun 4, 2010 at 12:27 AM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: On Fri, 2010-06-04 at 00:25 +0530, Shreyas wrote: Steve, Do you know where Apache is installed? If yes, you have something like error.log and access.log. Find them and nail them them down. I am a novice, too and the best way to learn is to answer here and getting corrected by other PHP gurus! So, all in the name of learning! :) --Shreyas On Thu, Jun 3, 2010 at 11:28 PM, Steve Marquez smarq...@marquez-design.comwrote: Strangest thing... it just started working again. Odd. Is there an easy way to view the error logs? As you can tell, I am still a novice at this. I am on Apache2 Thanks for your help. -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325 On Jun 3, 2010, at 9:53 AM, Jim Lucas wrote: Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Where exactly did you see this error? 1) In your browser when you tried loading the form? 2) In your browser when you submitted the form? 3) In the error logs of your web server? Other questions: What type of web server are you running? Did your cat stomp on your keyboard? Are the files stored locally or are they on a network/remote drive? Children doing things they should not be doing? (Happened to me once...) Are you accessing the files via http://localhost/... ?? or as a local file? -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? You haven't said what sort of operating system you're using. In Linux, most of the logs are kept in sub-directories of /var/log I believe. Windows, well they could be scattered anywhere. MacOS, not too sure about that. Thanks, Ash http://www.ashleysheridan.co.uk -- Regards, Shreyas
Re: [PHP] PHP Form submitting to MySQL not working...
I am on Mac OS 10.6 I found the logs using the console. It was pretty easy and displays nicely. I am reviewing the entries now. Thanks for your help. -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325 On Jun 3, 2010, at 1:55 PM, Shreyas wrote: Steve, Do you know where Apache is installed? If yes, you have something like error.log and access.log. Find them and nail them them down. I am a novice, too and the best way to learn is to answer here and getting corrected by other PHP gurus! So, all in the name of learning! :) --Shreyas On Thu, Jun 3, 2010 at 11:28 PM, Steve Marquez smarq...@marquez-design.com wrote: Strangest thing... it just started working again. Odd. Is there an easy way to view the error logs? As you can tell, I am still a novice at this. I am on Apache2 Thanks for your help. -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325 On Jun 3, 2010, at 9:53 AM, Jim Lucas wrote: Steve Marquez wrote: Good morning, I have a PHP form that I have been using for some time now on a Macbook Pro running PHP 5.3.1 and MySQL 5.0.5 and everything was working fine. But this morning, when I submitted (it is a journaling application) it came up with the following error: No such file or directory Can anyone point me in the right direction to fix this? Have you ever seen this before? Thanks, Steve Marquez Where exactly did you see this error? 1) In your browser when you tried loading the form? 2) In your browser when you submitted the form? 3) In the error logs of your web server? Other questions: What type of web server are you running? Did your cat stomp on your keyboard? Are the files stored locally or are they on a network/remote drive? Children doing things they should not be doing? (Happened to me once...) Are you accessing the files via http://localhost/... ?? or as a local file? -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- Regards, Shreyas
