Re: [PHP] mysql and php

2006-04-14 Thread Rory Browne
Display the different ways in which you've seen php using mysql, and we'll see if any one of them is any more secure than another. Most Security issues can be left to MySQL and the MySQL API. A few pointers - Store parameters(username/password) outside the DocuementRoot. Put your server on local

Re: [PHP] mysql and php

2003-03-11 Thread David E.S.V.
great tutorial to do what you want: http://www.freewebmasterhelp.com/tutorials/phpmysql/4 regards, David. On Tue, 11 Mar 2003, Joseph Bannon wrote: > How can I have php give me all the data in a table as > I would using the prompt in mysql? > > Joseph > > > > ___

RE: [PHP] MySQL and PHP arrays

2003-03-10 Thread Van Andel, Robbert
:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:45 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL and PHP arrays You get at the data through $array = mysql_result($result,0,0); Mike "{R}Ichard Ashton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Mon, 1

Re: [PHP] MySQL and PHP arrays

2003-03-10 Thread Mike Mannakee
You get at the data through $array = mysql_result($result,0,0); Mike "{R}Ichard Ashton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote: > > >On Monday 10 March 2003 22:30, {R}ichard Ashton wrote: > >> Is there a generally recomm

Re: [PHP] MySQL and PHP arrays

2003-03-10 Thread {R}ichard Ashton
On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote: >On Monday 10 March 2003 22:30, {R}ichard Ashton wrote: >> Is there a generally recommended way of storing an array created by PHP >> in a MySQL database field ? > >serialize() and unserialize(). > >> What type of field should it be, and how do

RE: [PHP] MySQL and PHP arrays

2003-03-10 Thread Messay W Asfaw
Serializing it would be the best way: seralize($myArray) then you can get the array back using unseralize($serializedarray) -Original Message- From: {R}ichard Ashton [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 14:31 To: [EMAIL PROTECTED] Subject: [PHP] MySQL and PHP arrays Is there a

Re: [PHP] MySQL and PHP arrays

2003-03-10 Thread Jason Wong
On Monday 10 March 2003 22:30, {R}ichard Ashton wrote: > Is there a generally recommended way of storing an array created by PHP > in a MySQL database field ? serialize() and unserialize(). > What type of field should it be, and how do you get the whole array > back in one go without reconstructi

Re: [PHP] MYSQL and PHP Storing and retrieving images getting corrupted

2002-11-05 Thread rija
Have you tried out mysql function load_file() to upload directly your file into the database without passing through php variable ? Like this: $result=MYSQL_QUERY("INSERT INTO master_products (image_thumbnail,image_thumbnail_name,image_thumbnail_size,image_thumbnail_t ype) VALUES (load_file('$fo

Re: [PHP] MYSQL and PHP Storing and retrieving images getting corrupted

2002-11-05 Thread Marek Kilimajer
Try adding header('Content-length: ' .strlen($data)); header Darren McPhee wrote: I have written 2 programs (which are very common PHP programs) that A) Allows me to upload image files into a MYSQL database using a simple form. And B) Allows me to retrieve and display the image using a PHP scri

Re: [PHP] MySQL and PHP

2002-01-18 Thread DL Neil
legibility (particularly if you're asking us to read it to help you), and (b) for machine parsing requirements. =dn - Original Message - From: "hugh danaher" <[EMAIL PROTECTED]> To: "Brandon Orther" <[EMAIL PROTECTED]> Cc: "Php-General" <[EMAIL PROT

Re: [PHP] MySQL and PHP

2002-01-17 Thread hugh danaher
Brandon, Try using single quotes rather than doubles in the values e.g. ('something','something else') hugh - Original Message - From: Brandon Orther <[EMAIL PROTECTED]> To: PHP User Group <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 2:25 PM Subject: [PHP] MySQL and PHP > Hello,

Re: [PHP] MySQL and PHP

2002-01-17 Thread Sam Masiello
What is the error that you are getting? --Sam - Original Message - From: "Brandon Orther" <[EMAIL PROTECTED]> To: "PHP User Group" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 5:25 PM Subject: [PHP] MySQL and PHP > Hello, > > I am trying to use mysql through php. When I tr

Re: [PHP] mysql and php

2001-04-05 Thread Christian Reiniger
On Thursday 05 April 2001 02:15, you wrote: > I'm sending this command to mysql > > UPDATE fusuario u, fgrupos g SET g.cdgrupo=1, u.celular="99823640", > u.nome="Augusto X", u.sobrenome="Cesar Castoldi", > u.cidade="Florinópolis", u.emailpessoal="[EMAIL PROTECTED]", > u.idade="19", u.sexo="M", u.o

Re: [PHP] :: MySql and PHP Book

2001-01-15 Thread Kristofer Widholm
Here's what you wrote, 01-01-11: > I was looking for a good book that teaches you how to use PHP (mainly 3) >with MySql. I went to Amazon.com and found "MySql" by Paul Dubois, which was >supposed to be THE book for mySql programming. However, after reading some >of the customer reviews, it

Re: [PHP] :: MySql and PHP Book

2001-01-11 Thread Neil Zanella
On Thu, 11 Jan 2001, Ray Iftikhar wrote: > I was looking for a good book that teaches you how to use PHP (mainly 3) > with MySql. I went to Amazon.com and found "MySql" by Paul Dubois, which was > supposed to be THE book for mySql programming. However, after reading some > of the customer review

Re: [PHP] :: MySql and PHP Book

2001-01-11 Thread Philip Olson
Hey Ray, I would suggest looking for books on SQL. I have one (and want more!), it is called "the practical sql handbook" and it's nice. Seems every PHP book deals with MySQL directly too. Anyway, my thought on the matter is go generic, go SQL. Philip On Thu, 11 Jan 2001, Ray Iftikhar wrote

Re: [PHP] mysql and php possibly causing problem

2001-01-10 Thread Michael Brunson
On 9 Jan 2001 21:04:26 -0800, [EMAIL PROTECTED] (James Mclean) wrote: >list, >ok her is the problem. i have a page taht works fine in one dir, but in a sub >dir, it doesnt even show up. here is my dir structure. >public_html/| >|website/| >||index.php >|