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
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
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
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
Hi friends,
I am Rittwick Banerjee
and i have made a mysql based user name and password program but I found
that
what ever I entered in the user name and password feild the php file dose
not working.
I set this code for user name and password
$sql = SELECT `User_name` AND `User_pass` FROM
$sql = select User_name, User_pass from user where User_name =
'$_POST[user_id]' and User_pass = '$_POST[user_pass]';
assuming user_id isnt an int
Rittwick Banerjee wrote:
Hi friends,
I am Rittwick Banerjee
and i have made a mysql based user name and password program but I
found that
what ever
-Original Message-
From: Rittwick Banerjee [mailto:[EMAIL PROTECTED]
Sent: Friday, May 20, 2005 3:59 AM
To: php-general@lists.php.net
Subject: [PHP] mysql with php
Hi friends,
I am Rittwick Banerjee
and i have made a mysql based user name and password program
but I found
May 2005 11:21 am
To: Rittwick Banerjee
Cc: php-general@lists.php.net
Subject: Re: [PHP] mysql with php
$sql = select User_name, User_pass from user where User_name =
'$_POST[user_id]' and User_pass = '$_POST[user_pass]';
assuming user_id isnt an int
Rittwick Banerjee wrote:
Hi
try this:
$sql =
SELECT User_name, User_pass
FROM `user`
WHERE User_name= '$_POST[user_id]'
AND User_pass = '$_POST[user_pass]'
;
-afan
Rittwick Banerjee wrote:
Hi friends,
I am Rittwick Banerjee
and i have made a mysql based user name and password program but I
Is this a possible combination ? Work is trying to compile PHP4 against
4.1, I havent even tried it apart from against PHP5. It says in the
manual that the mysqli driver is the only one compatible with 4.1,
although I have managed to compile both mysql and mysqli in php5, and
run my apps ok as
Hey everyone,
I am writing an application to keep track of employee vacation leave. I have
two timestamp(14) database fields, lets call them start and end, signifying
when start and end of a vacation leave, respectively. What I am trying to do
is get the number of hours between start and end, for
Hi List
OK, I've posted this on the MySQL list as well, but it seems a bit quiet
there, and arguably it could definately be a PHP rather than mysql question
depending on whether it can be done with one query (then it was/is a mysql
query), or whether it should be done with some structures
select * from main
left join fof on main.id = fof.id
left join pub on main.id = pub.id
left join gov on main.id = gov.id
left join med on main.id = med.id
left join ngo on main.id = ngo.id
left join own on
simplify
your query and no doubt improve performance.
On Tuesday 29 Jul 2003 10:13 pm, Petre Agenbag wrote:
Hi List
OK, I've posted this on the MySQL list as well, but it seems a bit quiet
there, and arguably it could definately be a PHP rather than mysql question
depending on whether it can
-
From: Petre Agenbag [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 2:13 PM
Subject: [PHP] MySQL query/PHP logic?
Hi List
OK, I've posted this on the MySQL list as well, but it seems a bit quiet
there, and arguably it could definately be a PHP rather than mysql
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/)
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
Should not it be:
$SQL = SELECT * FROM table ORDER BY id asc LIMIT .($autoindex -5). ,5;;
John Taylor-Johnston wrote:
I don't know whether this is a MySQL or PHP quesiton.
$SQL = SELECT * FROM table ORDER BY id asc LIMIT $autoindex -5 ,5;;
I would like to get the autoindex value of my table
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
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 reconstructing
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
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 you get
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 reconstructing it row by row, if that is
possible?
Any text field will do, just make sure it's
:[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, 10 Mar 2003 22:34:44
I don't know whether this is a MySQL or PHP quesiton.
$SQL = SELECT * FROM table ORDER BY id asc LIMIT $autoindex -5 ,5;;
I would like to get the autoindex value of my table and use it in my SQL. Can I get
the autoindex? :) How?
--
PHP General Mailing List (http://www.php.net
Anyone out there have anything to share as to using PHP4+MySQL4. I've been
hearing good things on the MySQL list about v4.0 and I'm thinking of
upgrading, since I run a rather small server.
Thanks!
--Joe
ps. PHP list responders please respond directly. I'm not currently
subscribed.
--
Joe
Anyone out there have anything to share as to using PHP4+MySQL4. I've been
hearing good things on the MySQL list about v4.0 and I'm thinking of
upgrading, since I run a rather small server.
There's really no change from the PHP side. PHP just sends the data and
receives something back The only
a constant. SSL support will be available in
PHP 5 (new mysql extension).
Regards
Georg
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
a constant. SSL support will be
available in
PHP 5 (new mysql extension).
Regards
Georg
Ah, man... Now you made my article in the last issue of PHP|Architect
incorrect! :)
Oh well, I guess we'll have to wait.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals
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
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,
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
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 retrieving images getting corrupted
I have written 2 programs (which are very
(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 PROTECTED]
Sent: 18 January 2002 01:14
Subject: Re: [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 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
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 try to run
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,
I
[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
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="Florinpolis", u.emailpessoal="[EMAIL PROTECTED]",
u.idade="19", u.sexo="M",
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="Florinpolis",
u.emailpessoal="[EMAIL PROTECTED]", u.idade="19", u.sexo="M",
u.operadora="T", u.email="", u.ddd="048" WHERE g.cdgrupo=1
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, Ra
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
|
42 matches
Mail list logo
