Re: [PHP-DB] HTML Tables in PHP...
all html tags should be in single quote when used in php like echo 'table align=center width=80%'; echo 'trtd align=center'; echo HELLO; echo '/td/tr/table'; With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 3048140 / 304 FAX: +91 - 120 - 2568 473 WEB : www.indoasian.com Original Message From: Daryl Booth [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] HTML Tables in PHP... Date: 9/25/2005 19:05 How can I give a table /table with all of it's parameters in PHP in each of the cells there is a variable that gives me the data back but I can't get the table to show as it always gives me either this error Parse error: parse error, unexpected T_LNUMBER, expecting ',' or ';' in C:\FoxServ\www\Dad\proofing\index.php on line 41 or this one when I don't put in the quotes Parse error: parse error, unexpected '', expecting ',' or ';' in C:\FoxServ\www\Dad\proofing\index.php on line 41. Here is the PHP code I'm using: ?php $datei=c:\licence.txt; if(file_exists($datei)){ $nachricht=The licence has been validated thank-you!; $fp = fopen($datei,r); fpassthru($fp); fclose($fp); } else{ $nachricht=The licence doesn't exist please contact us! echo table width=694 height=501 border=0 align=center cellpadding=0 cellspacing=0 tr td height=109 colspan=7img src=images/1.jpg width=857 height=109 border=0 usemap=#Map/td /tr tr td width=39 rowspan=2img src=images/lefty.jpg width=39 height=394/td td width=8 height=369nbsp;/td td width=240 class=style5/td td width=12 height=369 class=style5nbsp;/td td width=407 height=369 class=style5span class=style3b$nachricht/b/spanbr/td td width=346 rowspan=2img src=images/righty.jpg width=346 height=394 border=0 usemap=#Map2/td /tr tr td height=23 colspan=5img src=images/bottom.jpg width=472 height=23/td /tr /table; } ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] A question with php.ini
You have to do following settings in php.ini A) if your using windows system [mail function] ; For Win32 only. SMTP = (name or ip address of smtp sever) smtp_port = 25 ; For Win32 only. sendmail_from = (your email id) B) if your using linux system ; For Unix only. You may supply arguments as well (default: sendmail -t -i). sendmail_path = path-to-sendmail -t -i -f (your email id) hope it will work for you With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 3048140 / 304 FAX: +91 - 120 - 2568 473 WEB : www.indoasian.com Original Message From: Daryl Booth [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] A question with php.ini Date: 9/22/2005 00:01 Hi, How does the php.ini need to be setup for SMTP or how do I find it out? Thank-You very much Daryl Booth -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Duplicate record
in my opinion you can do the following: 1) once the user submitted the form, redirect to a new page OR 2) may have a unique column in database to avoid duplication like userid etc. With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 3048140 / 304 FAX: +91 - 120 - 2568 473 WEB : www.indoasian.com Hallvard wrote: I have a page that posts data from a form to a mysql database. The problem is that if the user hits the reload button on the browser, the data will be posted again, resulting in a duplicate record. How can I avoid that? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] floats
i run this query at my end, its running... pls check whether you gave the field names properly. With Best Wishes Balwant Singh blackwater dev wrote: I am running a query on MySQL: select * from cars where id =52 It returns the row and I can see that gas mileage is saved as a float with a value of 23.45. So I then do a query, select * from cars where id=52 and gas_mil=23.45 and the query doesn't retun anything. Why? Do I have to cast this as a float? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] General UPDATE question
it will update all rows which fulfills the criteria. With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 2568 472 / 093 -098 FAX: +91 - 120 - 2568 473 WEB : www.indoasian.com Ron Piggott wrote: Does the UPDATE command only change one row or each occurance if the the criteria repeat itself through the table? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re newbie question
i am doing the following for inserting values in MYSQL DB through PHP. $a = hello; $b = 1; $query = INSERT INTO tablename (a, b) VALUES ('$a', '$b'); try this with best wishes balwant - Original Message - From: Kenn Murrah [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday, May 31, 2000 2:36 PM Subject: [PHP-DB] newbie question: I'm trying to accomplish a simple task, that of inputting text and numbers from an HTML form, then writing to mySQL via PHP. Oddly enough, when I attempt this with numerals, all is well. When I attempt it with a text string, it fails. Pardon the beginner question, but can anyone tell me what I'm likely doing wrong? Thanks in advance, Kenn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Sessions
i also want to buy this book. but could not find it in India. If anybody help me out. with best wishes balwant On Thu, 2005-04-14 at 15:10, Maerlyn wrote: Hi, you might consider buying Peter Moulding's PHP Black Book. Among other things it tells much about DBs, sessions and storing sessions in databases. I already used it's codes, and I found it very useful. Maerlyn Ian McGhee wrote: Hi All, I have been looking into PHP sessions and I have noticed you can actually use a database for storing the sessions instead of flat files I will be using MS SQL for the database can any one give be a clue as to how I would go about this or point me in the direction of a good tutorial? Any Help would be greatly appreciated, Ian McGhee Email: [EMAIL PROTECTED] -- Maerlyn maerlyn[KUKAC]citromail[PONT]hu http://putraware.ini.hu GnuPG Public Key ID: 0x0CE0A57 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] email question
sorry for again bothering you, thanks, yes you are right i am using SMTP. i have given my smtp server's ip and port number in my php.ini file but still i could not able to send the emails through my linux m/c. also i am not receiving any error. the mail goes but not reach to destination. after doing the above setting in php.ini i run the php file on windows machine and the emails are going to destination. is there any more setting needs to be done in linux (i am using REDHAT 9, PHP 4.2) with best wishes balwant On Thu, 2005-03-03 at 19:48, Brent Baisley wrote: First, you don't use POP3 for sending emails, you use SMTP. POP3 is a retrieval mechanism, like IMAP. You actually don't need POP3 or IMAP to send and receive emails, you need it to read them with a typical mail client (i.e. Outlook). Postfix, Sendmail, etc., don't support POP3 and IMAP directly, you need to use another product like Cyrus, Courier or Qpopper to add POP3 and IMAP. So, that said, PHP has built-in commands for sending email. http://us2.php.net/manual/en/ref.mail.php http://us2.php.net/manual/en/function.mail.php If you read the documentation, you'll notice that there is no option for authenticating. Which means you would need to setup your mail server to allow relaying from your PHP machine. Don't take open relaying lightly, if you do it wrong, you'll be in the spam business. So if you don't know how to setup your mail server for restricted open relaying, you should look at another PHP package (i.e. PEAR) that will authenticate when sending emails. On Mar 2, 2005, at 3:54 AM, Balwant Singh wrote: can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my webserver has linux OS but we are using POP3 for sending emails (on Windows OS). May pls. inform all the setting needs to be done for sending an email. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] email question
can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my webserver has linux OS but we are using POP3 for sending emails (on Windows OS). May pls. inform all the setting needs to be done for sending an email. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] GD2 library
Sorry I am asking a question which is not directly linked to this forum but i am confident that many of you have the answer for it. i am using PHP 4.2.2 with GD 1.63. now i want to upgrade the GD1.63 to GD2. i have installed the GD2 in my system but still my system is showing GD 1.63. May pls. advise me what needs to be in php.ini file or anywhere so that my php read the GD2. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] email question
can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my webserver has linux OS but we are using POP3 for sending emails (on Windows OS). May pls. inform all the setting needs to be done for sending an email. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] timestamp
on echoing $timestamp i m getting Fri Jan 28 19:53:09 2005 but on echoing $date i m getting 1970-01-01. also i m getting full info. by phpinfo() i m using php 4.2.2 , apache 2.0 and rad hat 9. with best wishes balwant On Tue, 2005-02-01 at 12:40, graeme wrote: what output do you get from the following? ?php $timestamp = Fri Jan 28 19:53:09 2005; echo $timestamp .br; $date = date(Y-m-d,strtotime($timestamp)); echo $date .br; phpinfo(); ? graeme wrote: The code works fine on my system, so what version of php are you using and what is your operating system? graeme. Balwant Singh wrote: i just copy your code and paste into a test file. ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? with best wishes balwant On Tue, 2005-02-01 at 10:33, Bastien Koert wrote: pls post relevant code bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] timestamp Date: 01 Feb 2005 10:13:40 +0530 dear bastien thanks for the reply... but i checked it again but it is giving only 1970-01-01. is something else needs to be done. with best wishes balwant On Mon, 2005-01-31 at 19:46, Bastien Koert wrote: This code : ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? gave me this result 2005-01-28 Exactly as it should. Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] timestamp Date: 31 Jan 2005 10:02:04 +0530 thanks I tried strtotime also but getting 1970-01-01 not 2005-01-28. my problem is that the date is given to me in string format i.e.Fri Jan 28 19:53:09 2005. Any other help will be appreciated. with best wishes balwant On Sat, 2005-01-29 at 22:45, Bastien Koert wrote: try $date = date(Y-m-d,strtotime($timestamp)); Best thing to use if you want to do calcs on date/time data is to use the unix time stamp...translates the timestamp into seconds since 01-01-1970...Much simpler to use in sql queries Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] timestamp Date: 29 Jan 2005 19:47:35 +0530 i am facing a problem i have timestamp in string format -- Fri Jan 28 19:53:09 2005 now i want to get the date from it. is it possible? pls. help. on using strftime(%D,$timestamp) it is giving 01/01/70. May pls. help me. Also pls. let me know whether calculation can be done in mysql on this string timestamp. pls. inform. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Experience is a good teacher, but she sends in terrific bills. Minna Antrim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] timestamp
dear bastien thanks for the reply... but i checked it again but it is giving only 1970-01-01. is something else needs to be done. with best wishes balwant On Mon, 2005-01-31 at 19:46, Bastien Koert wrote: This code : ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? gave me this result 2005-01-28 Exactly as it should. Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] timestamp Date: 31 Jan 2005 10:02:04 +0530 thanks I tried strtotime also but getting 1970-01-01 not 2005-01-28. my problem is that the date is given to me in string format i.e.Fri Jan 28 19:53:09 2005. Any other help will be appreciated. with best wishes balwant On Sat, 2005-01-29 at 22:45, Bastien Koert wrote: try $date = date(Y-m-d,strtotime($timestamp)); Best thing to use if you want to do calcs on date/time data is to use the unix time stamp...translates the timestamp into seconds since 01-01-1970...Much simpler to use in sql queries Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] timestamp Date: 29 Jan 2005 19:47:35 +0530 i am facing a problem i have timestamp in string format -- Fri Jan 28 19:53:09 2005 now i want to get the date from it. is it possible? pls. help. on using strftime(%D,$timestamp) it is giving 01/01/70. May pls. help me. Also pls. let me know whether calculation can be done in mysql on this string timestamp. pls. inform. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] timestamp
i just copy your code and paste into a test file. ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? with best wishes balwant On Tue, 2005-02-01 at 10:33, Bastien Koert wrote: pls post relevant code bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] timestamp Date: 01 Feb 2005 10:13:40 +0530 dear bastien thanks for the reply... but i checked it again but it is giving only 1970-01-01. is something else needs to be done. with best wishes balwant On Mon, 2005-01-31 at 19:46, Bastien Koert wrote: This code : ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? gave me this result 2005-01-28 Exactly as it should. Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] timestamp Date: 31 Jan 2005 10:02:04 +0530 thanks I tried strtotime also but getting 1970-01-01 not 2005-01-28. my problem is that the date is given to me in string format i.e.Fri Jan 28 19:53:09 2005. Any other help will be appreciated. with best wishes balwant On Sat, 2005-01-29 at 22:45, Bastien Koert wrote: try $date = date(Y-m-d,strtotime($timestamp)); Best thing to use if you want to do calcs on date/time data is to use the unix time stamp...translates the timestamp into seconds since 01-01-1970...Much simpler to use in sql queries Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] timestamp Date: 29 Jan 2005 19:47:35 +0530 i am facing a problem i have timestamp in string format -- Fri Jan 28 19:53:09 2005 now i want to get the date from it. is it possible? pls. help. on using strftime(%D,$timestamp) it is giving 01/01/70. May pls. help me. Also pls. let me know whether calculation can be done in mysql on this string timestamp. pls. inform. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] timestamp
thanks I tried strtotime also but getting 1970-01-01 not 2005-01-28. my problem is that the date is given to me in string format i.e.Fri Jan 28 19:53:09 2005. Any other help will be appreciated. with best wishes balwant On Sat, 2005-01-29 at 22:45, Bastien Koert wrote: try $date = date(Y-m-d,strtotime($timestamp)); Best thing to use if you want to do calcs on date/time data is to use the unix time stamp...translates the timestamp into seconds since 01-01-1970...Much simpler to use in sql queries Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] timestamp Date: 29 Jan 2005 19:47:35 +0530 i am facing a problem i have timestamp in string format -- Fri Jan 28 19:53:09 2005 now i want to get the date from it. is it possible? pls. help. on using strftime(%D,$timestamp) it is giving 01/01/70. May pls. help me. Also pls. let me know whether calculation can be done in mysql on this string timestamp. pls. inform. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] timestamp
i am facing a problem i have timestamp in string format -- Fri Jan 28 19:53:09 2005 now i want to get the date from it. is it possible? pls. help. on using strftime(%D,$timestamp) it is giving 01/01/70. May pls. help me. Also pls. let me know whether calculation can be done in mysql on this string timestamp. pls. inform. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] if statement
i may be wrong but as i understand that you want to check whether a array holds any value or not -- for this u can use COUNT function of array which will count the values of the array. with best wishes balwant On Sat, 2005-01-29 at 06:29, Craig Hoffman wrote: Hi There, I am trying to write an if statement to see if an array has any values in it and if it does do something. for example: $ticklist2 = array('$values) if (array_values(empty($ticklist2))) { do something } else { do something else } I just can't get this to work. Any help would be great. Thanks, Craig H. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Excel to MySQL
As suggested by David, save the excel file as CSV file then you can insert the data into database through command like LOAD INFILE for MYSQL with best wishes balwant On Tue, 2005-01-25 at 12:34, David Robley wrote: On Tuesday 25 January 2005 08:07, Novice Learner wrote: Hello, I have an Excel worksheet with a database in it. I would like to move this data to the database on the server that would work with my .php files. Is there a way? I apologize if I posted this question on the wrong list. Thank you, One option might be to export the Excel data as csv, then use whatever option your database provides to import the csv data. -- David Robley Nostalgia isn't what it used to be. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MYSQL
hi to all, may somebody guide me on the following: I want to retrieve data from MYSQL and then want that PHP do calculation - substract a particular field from its previous row. i.e. suppose i have two field named DATE, STOCK and have 10 rows. Now i want that STOCK on the 10th row should be substracted from 9th and so on. May pls. help me. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php