Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-19 Thread Nigel Wood
Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT data (from #2) into local MySQL } - this may take only mili secs.

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-19 Thread Johan De Meersman
On Fri, Apr 16, 2010 at 1:31 PM, Nigel Wood nw...@plus.net wrote: P.S. Sorry to the other list users for a PHP oriented discussion. Get a room, you two :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-19 Thread Michael Dykman
On this level, it's more of an apache/web-server-in-general issue. There are 2 connections to be considered here: the connection between the browser and the web server and the connection between the webserver (running PHP for example) and the database and they have very different behaviours. If

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-17 Thread Antonio PHP
Well... just summarizing my thread here. I tested this today. As Carsten mentioned... Without the function 'ignore_user_abort(true);', when the browser is closed the script will stop at some point (if there's output ('echo etc') of certain number (1,000s) of characters remaining.). Many Thanks

What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Antonio PHP
This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT data (from #2) into local MySQL } - this may take only

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Jørn Dahl-Stamnes
On Friday 16 April 2010 11:39, Antonio PHP wrote: This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Geert-Jan Brits
As a side-note: letting a random user (such as your website visitor) wait for a couple of seconds is usually not good practice, unless you have a very good incentive for them to do so. 2010/4/16 Jørn Dahl-Stamnes sq...@dahl-stamnes.net On Friday 16 April 2010 11:39, Antonio PHP wrote: This

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Carsten Pedersen
http://php.net/manual/en/function.ignore-user-abort.php / Carsten On Fri, 16 Apr 2010 18:39:07 +0900, Antonio PHP php.anto...@gmail.com wrote: This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl;

Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Carsten Pedersen
On Fri, 16 Apr 2010 11:44:42 +0200, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote: The server does not know if the browser is closed or not (or if the network connection is losted). It will continue to execute the code until finnished. Not quite true. If it decides to flush its

Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the database to access the info about the picture based on the id. This

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Scott Haneda
Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the database to access the info about the picture based on the id.

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
On Thursday 21 December 2006 11:03, Scott Haneda wrote: Hello, I have been using mysql_connect in a script that display a lot of thumbnails for an album. Each thumbnail is displayed using the code: IMG SRC=thm.php?id=some_id ALT=some title thm.php use a mysql_connect to the

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Scott Haneda
What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. Second, your suggestion is not an option in my case, since the image and the thumbnails are not stored in the database. The database contain image id, image attributes

Re: Mysql, PHP and Persistent mode

2006-12-21 Thread Jørn Dahl-Stamnes
On Thursday 21 December 2006 11:28, Scott Haneda wrote: What you should do, is grab the 50 images ahead of time, in one select, and use some php to iterate them and display them. Second, your suggestion is not an option in my case, since the image and the thumbnails are not stored in the

MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Steve
I'm fairly new to all this and duing everything step by step... I made my first (test) php site - and it works... then, i have this script where i'm supposed to find out if MySQL and PHP talk with each other. and there i get the answer Error 2002: Can't connect to local MySQL server through

Re: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Edward Vermillion
What does your script look like? Code? Ed On May 13, 2006, at 5:46 PM, Steve wrote: I'm fairly new to all this and duing everything step by step... I made my first (test) php site - and it works... then, i have this script where i'm supposed to find out if MySQL and PHP talk with each

Re: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Keith Roberts
@lists.mysql.com From: Steve [EMAIL PROTECTED] Subject: MySQL, PHP and Yahoo webhosting I'm fairly new to all this and duing everything step by step... I made my first (test) php site - and it works... then, i have this script where i'm supposed to find out if MySQL and PHP talk with each other

MySQL PHP Connector

2006-04-28 Thread Krisno Hasan
Could you give me MySQL PHP Connector, both mysql and mysqli connectors version 5.0.18? Thanks.

Re: Nested Set Model or modified preorder tree traversal mySQL/PHP code wanted

2006-02-22 Thread Peter Brawley
Daevid, I've been searching the web for the past few hours trying to find a simple drop-in class or functions to implement Nested Set Model or modified preorder tree traversal. The reason there's not a drop-in module may be that adding the layers implementing such generality would slow

Nested Set Model or modified preorder tree traversal mySQL/PHP code wanted

2006-02-21 Thread Daevid Vincent
I've been searching the web for the past few hours trying to find a simple drop-in class or functions to implement Nested Set Model or modified preorder tree traversal. I've found several tutorials and related links: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

mysql/php date functions..

2005-09-26 Thread bruce
hi... i've got a question/problem that i can't seem to figure out. it should be simple/straightforward. i'm creating a test tbl id int t1 timestamp when i do a 'select * from tbl' i get what looks like a default date/time format in the timestamp column. i do a, (from mysql) 'insert into tbl

Re: mysql/php date functions..

2005-09-26 Thread gerald_clark
bruce wrote: hi... i've got a question/problem that i can't seem to figure out. it should be simple/straightforward. i'm creating a test tbl id int t1 timestamp when i do a 'select * from tbl' i get what looks like a default date/time format in the timestamp column. i do a, (from mysql)

Newbie MySQL/PHP question re output formatting

2005-09-13 Thread Bill Whitacre
I can get this to work just fine: ?php $number = 23999.39; print $; print number_format($number, 2); ? Comes out $23,999.39 I'd like use the number_format() thingie on an array returned from a mysql_query. My current program snippet looks like: $res =

Re: Newbie MySQL/PHP question re output formatting

2005-09-13 Thread Jigal van Hemert
Bill Whitacre wrote: printf(trtd {$thearray[org]} /td td align=right {$thearray[COUNT(*)]} /td td align=right $ {$thearray[cost]} /td/tr); If I replace {$thearray[cost]} with number_format({$thearray[cost]}, 2) Although this is a MySQL mailing list and your problem is

Re: Newbie MySQL/PHP question re output formatting

2005-09-13 Thread Nuno Pereira
Bill Whitacre wrote: I can get this to work just fine: ?php $number = 23999.39; print $; print number_format($number, 2); ? Comes out $23,999.39 I'd like use the number_format() thingie on an array returned from a mysql_query. My current program snippet looks like:

Re: Newbie MySQL/PHP question re output formatting

2005-09-13 Thread Jasper Bryant-Greene
Nuno Pereira wrote: To do date change the first line from printf(trtd number_format({$thearray[cost]}, 2) /td to printf(trtd .number_format({$thearray[cost]}, 2). /td I think you mean: print( trtd . number_format( $thearray['cost'], 2 ) . /td ); As stated by a previous poster to this

effective handling of fuzzy dates (MySQL/PHP)

2005-06-29 Thread me you
Hello, Please excuse me if this has been posted in the wrong spot. I'm storing historical information in a MySQL database and am using the date field formatted in -MM-DD. For the most part, the data entered is correct and uses the full -MM-DD format, however, I've got numerous dates

Re: effective handling of fuzzy dates (MySQL/PHP)

2005-06-29 Thread Jochem van Dieten
On 6/29/05, me you wrote: For the most part, the data entered is correct and uses the full -MM-DD format, however, I've got numerous dates that are incomplete. For example: an event happened in 1967, but the exact month and day are not known. I've been storing that data, in other forms,

MySQL + PHP - Search Engine question!

2005-01-31 Thread Matt Babineau
Hi All - I'm building a search engine and what I would like to do is run a search and get the number of results, but still use the LIMIT command so I am not returning a ton of rows all at once. Is this the best way to go about searching? Thanks, Matt Babineau Criticalcode w:

Re: Mysql + PHP - Search

2005-01-31 Thread Matt Babineau
I just answered my own question actually! - snip from php.net - MySQL 4.0 supports a fabulous new feature that allows you to get the number of rows that would have been returned if the query did not have a LIMIT clause. To use it, you need to add SQL_CALC_FOUND_ROWS to the query, e.g.

TO - Mysql + PHP

2004-09-24 Thread nestor(earth)
Hi people, Well, I managed to set apache (1.3.31) + php (5.0.1) + mysql (5.0.1) on my laptop and it works find :-) I am tried the same set up on my desktop and I could not get it to work. I can get Apache(1.3.31) + PHP (4.3.8) to work together and mysql (5.0.1) and php can see mysql but

Mysql, php and unsubscribe or delete

2004-08-09 Thread Remember14a
Dear Friends, I have a table in mysql database, which retains emails, I have PHP application where I enter emails and emails get stored in mysql database,table, I have an option to unsubscribe as well, which works, However, Problem application is giving me is in case I unsubscribe one email

Re: Mysql, php and unsubscribe or delete

2004-08-09 Thread Ludwig Pummer
My guess is that since your id field is not auto_increment and you're not specifying a value, all email addresses are getting an id of 0. Since your primary key is composed of both id and email, MySQL isn't complaining. [EMAIL PROTECTED] wrote: However, Problem application is giving me is in

MySQL/PHP Tunneling

2004-07-10 Thread Karam Chand
Hello, Recently lot of MySQL clients try to overcome host based privilege system of MySQL by using PHP tunneling method. In this method they call up a PHP file in the server and the PHP file executes a query and sends the data in XML format. I am using C API() and I was just wondering if

Re: MySQL/PHP Tunneling

2004-07-10 Thread Eldon Ziegler
Karam, A much more secure way is to use OpenSSH (www.openssh.org) to create an encrypted connection between the local machine and the MySQL server and to use the -L option to forward MySQL commands from the localhost to the MySQL server. For example, ssh -l Login account URL or IP Address of

Pocket PC, Flash, Linux server, Apache, MySQL, PHP

2004-06-21 Thread Steve Howard
Hi, I am researching possible solutions for a simple database application delivered to a Pocket Windows PDA (PocketPC). The database will be a subset of a larger company-wide database held on a Linux server using MySQL and PHP. The PDA database will be used by a small number of people - probably

Re: [mysql-php] mysqlimport error

2004-06-09 Thread Egor Egorov
: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error

Re: [mysql-php] mysqlimport error

2004-06-07 Thread nikos
is that a problem? I want to avoid ftp db.txt files and then mysqlimport them - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying

[mysql-php] mysqlimport error

2004-06-02 Thread nikos
Hello list I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE

Re: [mysql-php] mysqlimport error

2004-06-02 Thread Egor Egorov
nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-04 Thread Ludwig Pummer
Chip Wiegand wrote: John, Yep, looking at phpinfo.php shows no support for mysql. This is very strange. I know these things don't just happen by themselves. I also know there are only two people with the password to the server, myself and my boss (and he knows nothing about the server to begin

Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Chip Wiegand
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on freebsd-5.1. It has been working fine for the past few years, now all of a sudden today I get an undefined function error. This is from httpd-error.log - PHP Fatal error: Call to undefined function: mysql_connect() in

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Chip Wiegand
John W. Holmes [EMAIL PROTECTED] wrote on 05/03/2004 10:59:15 AM: From: Chip Wiegand [EMAIL PROTECTED] I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on freebsd-5.1. It has been working fine for the past few years, now all of a sudden today I get an undefined

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Joshua J. Kugler
It sounds like someone upgraded your PHP libraries, and forget to include MySQL support. Do you admin this server, or does someone else? j- k- On Monday 03 May 2004 09:20 am, Chip Wiegand said something like: I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Chip Wiegand
Joshua J. Kugler [EMAIL PROTECTED] wrote on 05/03/2004 12:23:16 PM: It sounds like someone upgraded your PHP libraries, and forget to include MySQL support. Do you admin this server, or does someone else? j- k- Yep, I ran phpinfo.php and verified that it no longer shows support

Slightly OT: MySQL + PHP and escaping data to output to a web page

2004-04-15 Thread Daniel Kasak
Hi all. Yes I know this is a little off-topic, but also a little on-topic... I have a user who likes to use the 'less than' sign ( ) in notes he enters into the DB. When I print them out to a web page, they are interpreted as an HTML code and everything after them '' is not printed. I'm

Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

2004-04-15 Thread Mark Susol | Ultimate Creative Media
On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? You can try the php command:

Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

2004-04-15 Thread Daniel Kasak
Mark Susol | Ultimate Creative Media wrote: On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this?

Thinking About Upgrading MySQL, PHP, and phpmyAdmin

2004-01-03 Thread [EMAIL PROTECTED]
I'm on a Macintosh G3 PowerBook with OS 10.2.1. PHP is version 4.3.0; MySQL, 3.23.53; and phpmyAdmin, 2.4.0. What are the latest available post-beta, stable, fully-baked versions? Is upgrading as big a project as deleting old versions and then reinstalling newer? Or are there instructs for

Re: Thinking About Upgrading MySQL, PHP, and phpmyAdmin

2004-01-03 Thread Yves Goergen
Hi, I'd recommend you PHP 4.3.2 or newer, if you're already using 4.3.0. Latest stable should be 4.3.4, see www.php.net . Upgrading is described there, depends on you type of installation (Apache module/CLI/CGI). Latest MySQL of 3.23 series is 3.23.57 or so, don't know exactly, see www.mysql.com

Re: Date computation in MySQL PHP

2003-09-14 Thread delz
Hi Pete, Thanks for this info Regards, Delz - Original Message - From: Peter Vertes [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 12:05 AM Subject: Re: Date computation in MySQL PHP On Sat, 2003-09-13 at 02:50, delz wrote: I want to know how do I

Date computation in MySQL PHP

2003-09-13 Thread delz
Hi All, I want to know how do I use computations on dates in php or mysql like for example, today is September 13, 2003 (2003-09-13) and I want to get the date output if I add 5 days from the given date so that my output would be September 18, 2003 (2003-09-18). And if any given day falls on a

Re: Date computation in MySQL PHP

2003-09-13 Thread Peter Vertes
On Sat, 2003-09-13 at 02:50, delz wrote: I want to know how do I use computations on dates in php or mysql like for example, today is September 13, 2003 (2003-09-13) and I want to get the date output if I add 5 days from the given date so that my output would be September 18, 2003

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Martin Gainty
I have heard Apache croaks after 130 connections.. -M - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Andrew Rothwell [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 6:34 PM Subject: Re: A final Windows MySQL PHP plea Hi Andrew, I guess your reply

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Nils Valentin
query. Linux itself can support 1000's of users at one time - You might be surprised. Andrew -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:04 PM To: Gary Broughton; [EMAIL PROTECTED] Subject: Re: A final Windows MySQL PHP plea

RE: A final Windows MySQL PHP plea

2003-08-14 Thread Andrew Rothwell
] (BSent: Wednesday, August 13, 2003 11:00 PM (BTo: Nils Valentin; Andrew Rothwell (BCc: [EMAIL PROTECTED] (BSubject: Re: A final Windows MySQL PHP plea (B (B (BI have heard Apache croaks after 130 connections.. (B-M (B- Original Message - (BFrom: "Nils Valentin" [EMAIL

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Fred van Engen
Hi, On Tue, Aug 12, 2003 at 05:21:23PM +0100, Gary Broughton wrote: Is there anybody out there who has managed to successfully configure Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a couple of hundred users at any one time? I have chucked absolutely everything I can think

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Nils Valentin
Hi Gary, I understood that the packages provided by MySQL are set to 100 concurrent users by default, so what you ae asking is actually if somebody successfully compiled a version for more than 100 concurrent users and was able to use it in a production environment ? Do I understand that

FW: A final Windows MySQL PHP plea

2003-08-14 Thread Gary Broughton
the outcome is. :-) (BThanks again (BGary (B (B-Original Message- (BFrom: Nils Valentin [mailto:[EMAIL PROTECTED] (BSent: 14 August 2003 02:35 (BTo: Andrew Rothwell (BCc: [EMAIL PROTECTED] (BSubject: Re: A final Windows MySQL PHP plea (B (B (BHi Andrew, (B (BI guess your reply

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Terry Riley
Gary Does your php code use persistent connections? mysql_pconnect() rather than mysql_connect() ? If so, that would ramp up the CPU usage fairly quickly, AFAIAA. Just a thought Terry --Original Message- Hi all Is there anybody out there who has managed to successfully

A final Windows MySQL PHP plea

2003-08-14 Thread Gary Broughton
Hi all Is there anybody out there who has managed to successfully configure Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a couple of hundred users at any one time? I have chucked absolutely everything I can think of at this, but the MySQL (it seems) simply eats all the

Re: MySQL/PHP ?

2003-06-29 Thread Salam Baker Shanawa
Hi Ted, 1. Modify the query which presents all records by selecting let's say the peopleID. 2. When you build your update link you can use that ID to ask for a particular record. 3. Then you can use the same query + AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK. something like

Re: MySQL/PHP ?

2003-06-29 Thread Salam Baker Shanawa
[EMAIL PROTECTED] wrote: Thanks Salam, but a question: this would mean that I must do by hand every record ID link, no? I don't think you are building your master html page by hand, do you? No, of course no hand work. The script should take care of it e.g. in a loop while fetching the records

MySQL/PHP ?

2003-06-28 Thread tlr7425
I'm writing here in hopes of finding someone who uses this and might be able to help me. I am dealing with a recordset who's query is thus: SELECT firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines WHERE

RE: mysql-php link failure

2003-06-16 Thread Grimes, Dean
Processor Microcode Driver, provides support for the downloading of new microcode to Intel Pentium Pro, Pentium II, III, and 4 processors. Have you been able to compile Apache/MySQL/PHP successfully on SCO 5.0.6? If so, could you send me a listing of the patches you have installed

RE: mysql-php link failure

2003-06-16 Thread Boyd Lynn Gerber
On Mon, 16 Jun 2003, Grimes, Dean wrote: Have you been able to compile Apache/MySQL/PHP successfully on SCO 5.0.6? If so, could you send me a listing of the patches you have installed? Yes, This is what I have on my system OSS629A: SCO HTTP Security Supplement (ver 1.0.0) OSS635A

mysql-php link failure

2003-06-13 Thread Grimes, Dean
I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am getting following error: //usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1: size = 512 collect2: ld returned 1 exit status

Re: mysql-php link failure

2003-06-13 Thread Boyd Lynn Gerber
On Fri, 13 Jun 2003, Grimes, Dean wrote: I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am getting following error: //usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1:

Securing a Website driven with MySQL/PHP/Apache

2003-06-06 Thread Q Zantos
I am in the process of developing a MySql database driven website but I need to know that it is secure. Should the User Authentication Password stored in the database be encryted? And if so, how? Any other security tips are welcome..! Thanks. - Do you

RE: Securing a Website driven with MySQL/PHP/Apache

2003-06-06 Thread Jay Blanchard
[snip] I am in the process of developing a MySql database driven website but I need to know that it is secure. Should the User Authentication Password stored in the database be encryted? And if so, how? Any other security tips are welcome..! [/snip] RTFM passwords in MySQL are encrypted using

Mysql / PHP image link problem.

2003-06-04 Thread Daniel Crompton
I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif null image.gif image.gif To display in my web page im using: img src=?php echo $row_Recordset1['imagecolumn']; ? This displays the above images in my html page The problem i have is where the

Re: Mysql / PHP image link problem.

2003-06-04 Thread Paul DuBois
At 19:20 +0100 6/3/03, Daniel Crompton wrote: I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif null image.gif image.gif To display in my web page im using: img src=?php echo $row_Recordset1['imagecolumn']; ? This displays the above images in my

Re: Mysql / PHP image link problem.

2003-06-04 Thread Roman Neuhauser
keep the lines at or under 72 characters, please. # [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100: To display in my web page im using: img src=?php echo $row_Recordset1['imagecolumn']; ? This displays the above images in my html page The problem i have is where the field in my

RE: Mysql / PHP image link problem.

2003-06-04 Thread Jonathan Villa
from above --- Jonathan -Original Message- From: Daniel Crompton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:20 PM To: [EMAIL PROTECTED] Subject: Mysql / PHP image link problem. I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif

Re: Mysql / PHP image link problem.

2003-06-04 Thread Becoming Digital
- Original Message - From: Daniel Crompton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 03 June, 2003 14:20 Subject: Mysql / PHP image link problem. I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif null image.gif image.gif To display in my

RE: Mysql / PHP image link problem.

2003-06-04 Thread Peter Lovatt
?php if($row_Recordset1['imagecolumn']) echo 'img src='.$row_Recordset1[imagecolumn].''; ? Peter -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 20:57 To: [EMAIL PROTECTED] Subject: Re: Mysql / PHP image link problem. FWIW, there is a PHP-DB

Trying to Learn MySQL/PHP with Dreamweaver

2003-04-02 Thread Stephen Tiano
I'm trying to learn to create database-driven websites on the Macintosh using Dreamweave MX, PHP, and MySQL. I'm working thru exercises ina great book published by the recently-defunct Glasshaus, Dreamweaver MX: PHP Web Development. I'm in the next-to-the-last chapter, trying to complete an

Re: Trying to Learn MySQL/PHP with Dreamweaver

2003-04-02 Thread John Wards
On Wednesday 02 Apr 2003 12:06 pm, Stephen Tiano wrote: I'm trying to learn to create database-driven websites on the Macintosh using Dreamweave MX, PHP, and MySQL. I'm working thru exercises ina great book published by the recently-defunct Glasshaus, Dreamweaver MX: PHP Web Development. Need

Re: MySql, PHP, and Dates

2003-03-31 Thread Bruce Feist
Uttam wrote: u can use highly customizabe MySQL DATE_FORMAT() function for retrieving date in desired format. Thanks for the detailed information. For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date) function to return unix timestamp of the date and use the php date functions

Re: MySql, PHP, and Dates

2003-03-31 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500: Uttam wrote: u can use highly customizabe MySQL DATE_FORMAT() function for retrieving date in desired format. Thanks for the detailed information. For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date) function to return

Re: MySql, PHP, and Dates

2003-03-30 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500: I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create a dynamic web site. Right now, I'm having minor difficulties with date formatting. It seems that when I retrieve a date from MySQL into PHP, it shows up

Re: MySql, PHP, and Dates

2003-03-30 Thread B. van Ouwerkerk
This is not a MySQL question. http://www.php.net/manual/en/function.explode.php (probably) visit: http://www.php.net/links.php for tutorials on PHP. If you can control the layout of the database you could use another type of column. See the MySQL manual for more information. B. At 21:47

RE: MySql, PHP, and Dates

2003-03-30 Thread Mark Armendariz
/function.strtotime.php). Mark -Original Message- From: Roman Neuhauser [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 9:28 AM To: Bruce Feist Cc: MySQL List Subject: Re: MySql, PHP, and Dates # [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500: I'm experienced with SQL, but new to MySql

FW: MySql, PHP, and Dates

2003-03-30 Thread Peter Monk
and return a date in any format you please. Peter. -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Saturday, 29 March 2003 1:17 PM To: MySQL List Subject: MySql, PHP, and Dates I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create

RE: MySql, PHP, and Dates

2003-03-30 Thread Uttam
that handle hours, minutes, and seconds. Other specifiers produce a NULL value or 0. ---quote regards, -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 08:17 To: MySQL List Subject: MySql, PHP, and Dates I'm

MySql, PHP, and Dates

2003-03-28 Thread Bruce Feist
I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create a dynamic web site. Right now, I'm having minor difficulties with date formatting. It seems that when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type, with format

Best MySQL - PHP Book(s)

2003-03-27 Thread dpgirago
Howdy, Can anyone recommend a good reference book for using PHP with MySQL? I've read and enjoyed Paul's 'DoorStop' and 'CookBook' and have a fairly good grasp of MySQL. I've also written a bare bones database browser for Win32 using Apache, MySQL, and PHP, so I'm not an absolute newbie. But a

Examples needed of MYSQl/PHP update, delete scripts and relevant forms

2003-02-21 Thread Scott
I am looking for a set of examples of the relevant form pages and the php backends that connect to eitehr a YSQL or MSSQl database where the user can select certain records and then delete or update them. I ma having a nightmare designing one and examples always help me. Does anyone know of any

Re: Examples needed of MYSQl/PHP update, delete scripts and relevantforms

2003-02-21 Thread Kamara Eric R-M
Hi Scott, Can you please explicitly state what you want to be done otherwise it seems that all you need to do is get the records from the database,display them to the user and include something like a checkbox or radio button that the user can select to show the records he wants deleted. Then

Re: Examples needed of MYSQl/PHP update, delete scripts and relevant forms

2003-02-21 Thread Scott
] To: Scott [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 21, 2003 11:46 AM Subject: Re: Examples needed of MYSQl/PHP update, delete scripts and relevant forms Hi Scott, Can you please explicitly state what you want to be done otherwise it seems that all you need to do is get

[Fwd: Re: Re: Examples needed of MYSQl/PHP update, delete scriptsand relevant]

2003-02-21 Thread Michael T. Babcock
) by web.mysql.com (8.11.6/8.11.6) id h1LJVhi24085; Fri, 21 Feb 2003 20:31:43 +0100 Date: Fri, 21 Feb 2003 20:31:43 +0100 Message-Id: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED] Subject: Re: Re: Examples needed of MYSQl/PHP update, delete scripts and relevant Your message

Re: MySql, PHP and Javascript

2003-02-01 Thread Benjamin Pflugmann
Hi. On Fri 2003-01-31 at 08:27:11 +, [EMAIL PROTECTED] wrote: Is it possible to mix javascript and PHP in the same script?? Of course. One (PHP) is run on the server side in order to create a page which is sent to the client (here: the browser). The other (Javascript) may be contained in

MySql, PHP and Javascript

2003-01-31 Thread Steve Davies
Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces with rollovers etc, but haven't got time to learn JS

Re: MySql, PHP and Javascript

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Steve Davies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 9:27 AM Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP

Re: MySql, PHP and Javascript

2003-01-31 Thread Josh Trutwin
Hi All Is it possible to mix javascript and PHP in the same script?? Client-side Javascript can be sent to the user along with your html. For Example: echo (HTMLHEAD\n); echo (SCRIPT TYPE=\text/javascript\\n); echo (!--\n; echo (function hello() {\n); echo ( alert('Hi');\n); echo (}\n);

Re: MySql, PHP and Javascript

2003-01-31 Thread Kevin Smith
, 2003 8:27 AM Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like to pretty up the interfaces

Re: MySql, PHP and Javascript

2003-01-31 Thread Kamara Eric R-M
Hi Steve, You can definitely mix javascript and PHP in the same script so long as you follow the correct syntax for each language.There is no way out here really...if you want to include javascript in your scripts then you have to learn it:-) unless you want to hire someone to do it for you...

RE: MySql, PHP and Javascript

2003-01-31 Thread [EMAIL PROTECTED]
Is it possible to mix javascript and PHP in the same script?? Yes it is, but you have to remember that PHP is server side and Javascript is Client side. I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. I'll like

RE: MySql, PHP and Javascript

2003-01-31 Thread Hoffman, Geoffrey
Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 1:27 AM To: [EMAIL PROTECTED] Subject: MySql, PHP and Javascript Hi All Is it possible to mix javascript and PHP in the same script?? - Before posting

Re: MySql, PHP and Javascript

2003-01-31 Thread Doug Thompson
Steve: On Fri, 31 Jan 2003 08:27:11 +, Steve Davies wrote: Is it possible to mix javascript and PHP in the same script?? Certainly. Exactly as HTML and PHP are intermingled in a document. I have a number of web based apps written in PHP/MySql and while they are functionally pretty

  1   2   3   >