Hello all:
I had a few questions.
First, I'm using php-fastcgi with nginx for my primary web server. I was
wondering what sorts of optimizations exist to make this process a lot
faster.
Second, I'm setting up a custom application, and it contains an
authentication module for login/registration.
Bear with me here. I have a problem with PHP and MySQL that's been stumping
me for a couple of days now. I'm not even sure how to describe it, so I'll
just do my best.
There's a row in our bugs database that looks like every other row in the
table, but when it's pulled from the database and displa
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
i was wondering what is the most secure way to use mysql in php. is there a
certain way it should be done or a way that is more secure than another?
iv'e seen it done many ways and was wondering if it was just preference or a if
there was a reason behind it.
if you guys could post some example
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
>
>
>
> ___
How can I have php give me all the data in a table as
I would using the prompt in mysql?
Joseph
__
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
T
:[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
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
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
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
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
Is there a generally recommended way of storing an array created by PHP
in a MySQL database field ?
What type of field should it be, and how do you get the whole array
back in one go without reconstructing it row by row, if that is
possible?
{R}
--
PHP General Mailing List (http://www.php.n
I have a database that stores a value of the type double. I do a SUM()
query on the column and return save the value to a variable called,
'$amount' which I divide into a fixed value (5000) . The math works out
fine when $amount < 1000. However, when $amount > 1000, then the decimal
places are w
inally, storing image or binary file into database is not good, put them
into directory instead.
- Original Message -
From: "Darren McPhee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 11:24 PM
Subject: [PHP] MYSQL and PHP Storing and retr
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
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 script. This is my problem:-
I can upload the images ok. I store the binary code, imag
ED]>
> To: PHP User Group <[EMAIL PROTECTED]>
> Sent: Thursday, January 17, 2002 2:25 PM
> Subject: [PHP] MySQL and PHP
>
>
> > Hello,
> >
> > I am trying to use mysql through php. When I try to run the following
> > query it does nothing. I am tryi
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
Subjec
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
Hello,
I am trying to use mysql through php. When I try to run the following
query it does nothing. I am trying to figure out if it is the query or
php I am having a problem with. Does anyone see a problem with the
below query? (Note: This is for mysql)
QUERY:
INSERT INTO page_properties
(
[Reposting cos left error message out, sorry] Had a fully working
installation of MySQL 3.23 with PHP 6.0.6. I then foolishly installed PGP
which included PGPNet and I cant access my MySQL database from PHP. When I
try to connect I get error 'Access denied for user: '@GREEN' to database
'sub
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
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.operadora="T", u.email="", u.ddd="048" WHERE g.cdgrupo=1
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
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
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
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 said that it was "light" in the PHP s
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
>|
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
||admin/|
|| |admin.php
|
29 matches
Mail list logo
