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 t

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 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 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 m

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

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 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 output buffer and not

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 wrote: > This maybe a newbie question. > > Consider the following concept, > > ~/index.php > > #1. Fetch data from an external webpage using PHP Curl; > #2. Preg_mat

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 > On Friday 16 April 2010 11:39, Antonio PHP wrote: > > This maybe a newbie questio

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 {

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 mili

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 st

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 attr

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: > > > > > > > > thm.php use a mysql_connect to the database to access the info about

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: > > > > thm.php use a mysql_connect to the database to access the info about the > picture based on the id. > > This worked fine. However, the S

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: thm.php use a mysql_connect to the database to access the info about the picture based on the id. This worked fine. However, the SQL server is located

Re: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Keith Roberts
sql@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

RE: MySQL, PHP and Yahoo webhosting

2006-05-16 Thread Kristen G. Thorson
> > 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 l

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 oth

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 sock

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 pe

"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 http

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) 'ins

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: 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(" number_format({$thearray[cost]}, 2) to printf(" ".number_format({$thearray[cost]}, 2)." I think you mean: print( "" . number_format( $thearray['cost'], 2 ) . "" ); As stated by a previous poster to this thread, you should

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: 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 = mysql_query("SELECT org, COUNT(*), SUM(annual_cost) AS cost FROM a05

Re: Newbie MySQL/PHP question re output formatting

2005-09-13 Thread Jigal van Hemert
Bill Whitacre wrote: printf(" {$thearray[org]} {$thearray["COUNT(*)"]} $ {$thearray[cost]} "); If I replace {$thearray[cost]} with number_format({$thearray[cost]}, 2) Although this is a MySQL mailing list and your problem is not MySQL related, but a PHP question I'

Newbie MySQL/PHP question re output formatting

2005-09-13 Thread Bill Whitacre
I can get this to work just fine: 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 = mysql_query("SELECT org, COUNT(*), SUM(annual_cost) AS cost FROM a05 GROUP BY org ORDER BY

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 fo

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: 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. $sq

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: http://www.critical

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 every

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 ca

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 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 -L 3306::3306 Once the ssh connect

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 somebo

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
IL 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 >> > >> > > mysqlimport -

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 > "ni

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: p

[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 - AP

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

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 su

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 > freebs

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

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: 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, '<', '<'), '>', '>') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? Yo

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, '<', '<'), '>', '>') 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: htmlspecialc

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 curr

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 .

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 upgradi

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,

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 (2003-0

Date computation in MySQL & PHP

2003-09-12 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 Sun

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 available

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 successful

FW: A final Windows MySQL PHP plea

2003-08-14 Thread Gary Broughton
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 was

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 corre

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 thi

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" <[EM

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Nils Valentin
PM > To: Gary Broughton; [EMAIL PROTECTED] > Subject: Re: A final Windows MySQL PHP plea > > > 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 >

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 Window

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

Re: MySQL/PHP ?

2003-06-28 Thread tlr7425
Thanks Salam, but a question: this would mean that I must do by hand every record ID link, no? Ted On Sunday, June 29, 2003, at 02:29 AM, Salam Baker Shanawa wrote: Hi Ted, 1. Modify the query which presents all records by selecting let's say the peopleID. 2. When you build your update lin

Re: MySQL/PHP ?

2003-06-28 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

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 people.peopleID

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

RE: mysql-php link failure

2003-06-16 Thread Grimes, Dean
651A, the Intel 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

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:

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 ma

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

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 Yahoo!?

RE: Mysql / PHP image link problem.

2003-06-04 Thread Peter Lovatt
'; ?> 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 mailing list that might prove more helpful to you. I know certain folk on both l

Re: Mysql / PHP image link problem.

2003-06-04 Thread Becoming Digital
l.com - 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 nu

RE: Mysql / PHP image link problem.

2003-06-04 Thread Jonathan Villa
M 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 image.gif null image.gif image.gif To display in my web page im using: This displays the above images in my html page The problem i ha

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: > > > > This displays the above images in my html page > > The problem i have is where the field in my table is left blank > (null), a web browser shows

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: This displays the above images in my html page The problem i have is where the field in m

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: This displays the above images in my html page The problem i have is where the field in my table is left blank (null), a web browser

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. N

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 exe

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) > >funct

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-30 Thread Uttam
quired before format specifier characters. In earlier versions of MySQL, % was optional. TIME_FORMAT(time,format) This is used like the DATE_FORMAT() function above, but the format string may contain only those format specifiers that handle hours, minutes, and seconds. Other specifiers produce a NULL

FW: MySql, PHP, and Dates

2003-03-30 Thread Peter Monk
timestamp 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

RE: MySql, PHP, and Dates

2003-03-30 Thread Mark Armendariz
/manual/en/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 wi

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 28-

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

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 b

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

2003-02-21 Thread Michael T. Babcock
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 rele

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

2003-02-21 Thread Scott
t; <[EMAIL PROTECTED]> 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

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 all

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 or

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

Re: MySql, PHP and Javascript

2003-01-31 Thread Brian
- Original Message - From: Steve Davies <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 3:27 AM Subject: MySql, PHP and Javascript > Hi All > > Is it possible to mix javascript and PHP in the same script?? > Short answer: Yes

RE: MySql, PHP and Javascript

2003-01-31 Thread Jennifer Goodie
with backend programming. -Original Message- From: Steve Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 12:27 AM To: [EMAIL PROTECTED] 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

Re: MySql, PHP and Javascript

2003-01-31 Thread Brent Baisley
Of course. Javascript is a client side scripting language and is run in the users browser, whereas PHP is run on the server. The javascript is just text to the PHP parser, like HTML. Javascript will allow you to do dynamic stuff, but if you are looking for aesthetics you would be better off lea

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

RE: MySql, PHP and Javascript

2003-01-31 Thread Hoffman, Geoffrey
lto:[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?? > ---

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 lik

  1   2   3   4   >