Re: [PHP] MySQL Appeal from Monty

2009-12-14 Thread Ashley Sheridan
On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote: > On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: > > > Lenin wrote: > >> You might also like this: > >> Come on Monty - Lukas Smith http://bit.ly/5lmwwD > > > > I've been watching some of this debate with interest, but I'll stay with a

Re: [PHP] MySQL Appeal from Monty

2009-12-14 Thread Philip Thompson
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: > Lenin wrote: >> You might also like this: >> Come on Monty - Lukas Smith http://bit.ly/5lmwwD > > I've been watching some of this debate with interest, but I'll stay with a > database that has none of the baggage that MySQL has always had, and

Re: [PHP] MySQL Appeal from Monty

2009-12-13 Thread Lester Caine
Lenin wrote: You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD I've been watching some of this debate with interest, but I'll stay with a database that has none of the baggage that MySQL has always had, and IS currently replacing Oracle in many large sites :) -- Les

Re: [PHP] MySQL Appeal from Monty

2009-12-13 Thread Lenin
You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD

Re: [PHP] MySQL Appeal from Monty

2009-12-13 Thread metastable
rich...@rgraph.net wrote: > Hi, > > You might have already seen this, however if you haven't this may interest > you: > > http://monty-says.blogspot.com/2009/12/help-saving-mysql.html > > Sent my appeal to comp-merger-regis...@ec.europa.eu and I would suggest everyone on this list does the same

[PHP] MySQL Appeal from Monty

2009-12-13 Thread richard
Hi, You might have already seen this, however if you haven't this may interest you: http://monty-says.blogspot.com/2009/12/help-saving-mysql.html -- Richard Heyes HTML5 canvas graphing: RGraph - www.rgraph.net (updated 12th December - now with IE support!) Lots of PHP and Javascript code - http

[PHP] Re: [php] & [mysql] select and subselect

2009-11-17 Thread Nisse Engström
On Mon, 16 Nov 2009 14:21:41 -0800, Allen McCabe wrote: > I have an order table that keeps track of the order_id, the date, the > status, etc. I also have an order_lineitem table that is the contents of the > order. This has a one-to-many structure (without foreign keys because it is > mysql).

[PHP] Re: [php] & [mysql] select and subselect

2009-11-17 Thread David Robley
Allen McCabe wrote: > I have a page on my site where I can optionaly filter by certain fields > (order by filesize or file category), but I am implementing a shopping > cart type of idea where users can submit an order. > > As administrators, my coworkers and I need to be able to filter orders by

[PHP] [php] & [mysql] select and subselect

2009-11-16 Thread Allen McCabe
I have a page on my site where I can optionaly filter by certain fields (order by filesize or file category), but I am implementing a shopping cart type of idea where users can submit an order. As administrators, my coworkers and I need to be able to filter orders by their contents. For example:

[PHP] mysql resoc iterator

2009-10-31 Thread viraj
can somebody point me to a good article or a piece of code on implementing an iterator for a mysql result resource? actually this is for an oracle statement handle, all i want is to fetch the results as it is from a multi dimensional array. so i can use it in a for each with keys IteratorAggregat

Re: [PHP] PHP/MySQL Superstars

2009-10-02 Thread tedd
At 4:29 PM -0400 10/1/09, Robert Cummings wrote: I'm a superstar... send me a check for $500,000 and I'll fly on over. Or did you completely misuse the word "superstar"? Cheers, Rob. Rob: Well, in my book you are a superstar. Cheers, tedd -- --- http://sperling.com http://ancientston

[PHP] RE: PHP/MySQL Superstars

2009-10-02 Thread Jerome Botbol
Thanks Manuel your input is greatly appreciated. Jerome -Original Message- From: Manuel Lemos [mailto:mle...@acm.org] Sent: 01 October 2009 20:46 To: Jerome Botbol Cc: php-general@lists.php.net Subject: Re: PHP/MySQL Superstars Hello, on 10/01/2009 10:09 AM Jerome Botbol said the

Re: [PHP] PHP/MySQL Superstars

2009-10-01 Thread Robert Cummings
I'm a superstar... send me a check for $500,000 and I'll fly on over. Or did you completely misuse the word "superstar"? Cheers, Rob. Jerome Botbol wrote: Hi All, We require a PHP / MySQL superstar to work in-house at our offices near Edgware, London for 3 months on a

[PHP] Re: PHP/MySQL Superstars

2009-10-01 Thread Manuel Lemos
Hello, on 10/01/2009 10:09 AM Jerome Botbol said the following: > Hi All, > > We require a PHP / MySQL superstar to work in-house at our offices near > Edgware, London for 3 months on a ground breaking new web 2.0 project > which involves a variety of exciting new technologies. Y

[PHP] PHP/MySQL Superstars

2009-10-01 Thread Jerome Botbol
Hi All, We require a PHP / MySQL superstar to work in-house at our offices near Edgware, London for 3 months on a ground breaking new web 2.0 project which involves a variety of exciting new technologies. You will need at least 2 years proven experience on commercial projects. Relevant experience

Re: [PHP] php/mysql Query Question.

2009-09-16 Thread Jim Lucas
-html > This now will return all results in an html format from all queries. > > Now I could “tee” this to a file and save the results returned if I so choose > to save the result of the display . > > Let’s say I want to be lazy and write a php MySQL query to do the same so

Re: [PHP] php/mysql Query Question.

2009-09-16 Thread Robert Cummings
ad...@buskirkgraphics.com wrote: I tend to do this robert, while looking at your example i thought to myself since i am trying to mimick a shell command why not run one. Result: $ddvery"; ?> Not are the results safe but the unlimited possibilites are amazing. Thanks so much for the kick sta

Re: [PHP] php/mysql Query Question.

2009-09-16 Thread admin
I tend to do this robert, while looking at your example i thought to myself since i am trying to mimick a shell command why not run one. Result: $ddvery"; ?> Not are the results safe but the unlimited possibilites are amazing. Thanks so much for the kick starter ad...@buskirkgraphics.com wr

[PHP] Re: php/mysql Query Question.

2009-09-16 Thread Peter Ford
-html > This now will return all results in an html format from all queries. > > Now I could “tee” this to a file and save the results returned if I so choose > to save the result of the display . > > Let’s say I want to be lazy and write a php MySQL query to do the same so

Re: [PHP] php/mysql Query Question.

2009-09-15 Thread Robert Cummings
ad...@buskirkgraphics.com wrote: Would you mind giving me an example of this that i can stick right into a blank php file and run. I get what you are saying but i cant seem to make that even echo out the data. php 5.2 mysql 5.1.3 Apache 2.2 Cheers, Rob. -- http://www.interjinn.com Applica

Re: [PHP] php/mysql Query Question.

2009-09-15 Thread Robert Cummings
all results in an html format from all queries. Now I could “tee” this to a file and save the results returned if I so choose to save the result of the display . Let’s say I want to be lazy and write a php MySQL query to do the same so that any result I queried for would return the html results

[PHP] php/mysql Query Question.

2009-09-15 Thread admin
all queries. Now I could “tee” this to a file and save the results returned if I so choose to save the result of the display . Let’s say I want to be lazy and write a php MySQL query to do the same so that any result I queried for would return the html results in a table without actually writing

Re: [PHP] mysql user session handler

2009-09-09 Thread Tom Worster
good point, gabriel. i really need to stop procrastinating with the whole memcache project. perhaps i ought to postpone consideration of the session handler until i've learned something about memcache, which i need to do anyway. On 9/8/09 10:06 PM, "Gabriel Sosa" wrote: > I'm our case we opt f

Re: [PHP] mysql user session handler

2009-09-09 Thread Tom Worster
On 9/9/09 4:16 AM, "Ford, Mike" wrote: >> -Original Message- >> From: Tom Worster [mailto:f...@thefsb.org] >> Sent: 09 September 2009 02:29 >> >> thanks, Devendra, that's pretty much the same as my handler. (though >> i can't >> figure Rich Smith's $sess_save_path global. do you know wha

RE: [PHP] mysql user session handler

2009-09-09 Thread Ford, Mike
> -Original Message- > From: Tom Worster [mailto:f...@thefsb.org] > Sent: 09 September 2009 02:29 > > thanks, Devendra, that's pretty much the same as my handler. (though > i can't > figure Rich Smith's $sess_save_path global. do you know what is > for?) I think if you look at the comment

Re: [PHP] mysql user session handler

2009-09-08 Thread Gabriel Sosa
I'm our case we opt for memcache to store the sessions Mmc its soo much faster and you will have less net overhead because the simple protocol Also the configuration its easier. If you see in the php manual you only need to touch two lines in the php.ini On 9/8/09, Tom Worster wrote: > thanks, De

Re: [PHP] mysql user session handler

2009-09-08 Thread Tom Worster
thanks, Devendra, that's pretty much the same as my handler. (though i can't figure Rich Smith's $sess_save_path global. do you know what is for?) but what i'm really interested in is people's experience in switching over to and using this kind of handler: pitfalls, gotchas, etc. or is it really a

Re: [PHP] mysql user session handler

2009-09-08 Thread Devendra Jadhav
http://www.devshed.com/c/a/PHP/Storing-PHP-Sessions-in-a-Database/ On Tue, Sep 8, 2009 at 10:53 PM, Tom Worster wrote: > questions for those of you with a user session handler using mysql: > > did you write your own handler, write one based off some other you found > (if > so, which?), or are y

[PHP] mysql user session handler

2009-09-08 Thread Tom Worster
questions for those of you with a user session handler using mysql: did you write your own handler, write one based off some other you found (if so, which?), or are you using some available library (if so, which?)? and how do you feel about your implementation? satisfied? or are there improvement

Re: [PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-10 Thread tedd
At 12:47 AM +0200 8/10/09, Ralph Deffke wrote: I would like to have a KNOWN status of my database after a NEW installation of the application, because the further installation relais on information stored in record 1 of each table. Sounds like a problem waiting to happen. Cheers, tedd -- ---

Re: [PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-09 Thread Ralph Deffke
I would like to have a KNOWN status of my database after a NEW installation of the application, because the further installation relais on information stored in record 1 of each table. "tedd" wrote in message news:p06240801c6a4fe331...@[192.168.1.100]... > At 8:17 PM +0200 8/9/09, Ralph Deffke wr

Re: [PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-09 Thread tedd
At 8:17 PM +0200 8/9/09, Ralph Deffke wrote: Hi all, I'm facing the fact that it seems that auto_increment fields in a table not start at 1 like it was in earlier versions even if I install mySQL brand new creating all tables new. it seems to me that auto_increments handling has changed to older

Re: [PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-09 Thread Ralph Deffke
no this is not the point ! if I do this, the next auto_increment is still 10720 i can do what I want however the field is defined "long unsigned unique auto_increment", what happens is in t1 the value is set to 10720 in t2 the next value ist set to 10721 while the next record in t1 gets 10722

Re: [PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-09 Thread Ralph Deffke
no this is not the point ! if I do this, the next auto_increment is still 10720 i can do what I want however the is defined long unsigned unique auto_increment, what happens is in t1 the value is set to 10720 in t2 the next value ist set to 10721 while the next record in t1 gets 10721. it seems li

Re: [PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-09 Thread Jerry Wilborn
ALTER TABLE T1 AUTO_INCREMENT=1; It's likely that you dropped every record and expected the auto_increment to reset. Jerry Wilborn jerrywilb...@gmail.com On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke wrote: > Hi all, > > I'm facing the fact that it seems that auto_increment fields in a table no

[PHP] MySQL auto_increment fields Server version: 5.1.32-community-log

2009-08-09 Thread Ralph Deffke
Hi all, I'm facing the fact that it seems that auto_increment fields in a table not start at 1 like it was in earlier versions even if I install mySQL brand new creating all tables new. it seems to me that auto_increments handling has changed to older version. is somebody out there who can give me

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-15 Thread Govinda
Better late then never! :) I played around with your code tonight and got this working on a test server: $db_billing = mysql_connect($DBHOST, $DBUSER, $DBPASS) or die("Could not connect: " .mysql_error()); $db_selected = mysql_select_db($DB, $db_billing); if(!$db_selected) {

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-15 Thread Jason Pruim
On Jul 13, 2009, at 10:03 AM, Govinda wrote: I have this code: $db_billing=mysqli_connect(localhost,metheuser,mypass,billing); if (mysqli_connect_error()) { die("Can't connect: " . mysqli_connect_error()); } mysqli //$dbname = 'billing'; $sql = "SHOW TABLES";

Re: [PHP] MySQL Queries in PHP

2009-07-14 Thread Jan G.B.
2009/7/14 Tom Chubb > 2009/7/14 Eddie Drapkin > > > On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubb wrote: > > > Hi List, > > > Just wanted to pick your brains please? > > > I'm trying to standardise on the way I query databases and move away > from > > > the Dreamweaver built-in functions (which I k

Re: [PHP] MySql Injection advice

2009-07-14 Thread Martin Scotta
you can do that with IPs because it is an implementation of an integer. look: I take a integer value: 2130706433 express it as binary: 1110001 now I have to look it as bytes: 1110 0001 express the bytes as decimals: 127 0 0 1 does this number m

Re: [PHP] MySql Injection advice

2009-07-14 Thread Michael A. Peters
Eddie Drapkin wrote: Things I have used prepared statements for: 1. SELECT 2. UPDATE 3. INSERT 4. DELETE 5. Stored procedures Things I am aware of that prepared statements are not capable of doing: What have you read that prepared statements can't do? I've not heard of anything, nor have I enc

Re: [PHP] MySQL Queries in PHP

2009-07-14 Thread Tom Chubb
2009/7/14 Eddie Drapkin > On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubb wrote: > > Hi List, > > Just wanted to pick your brains please? > > I'm trying to standardise on the way I query databases and move away from > > the Dreamweaver built-in functions (which I know you all hate!) ;) > > I've been o

Re: [PHP] MySql Injection advice

2009-07-13 Thread Ashley Sheridan
On Tue, 2009-07-14 at 01:52 -0400, Andrew Ballard wrote: > On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyan wrote: > > for the phone #'s, I'm using int as the data type & storing each part of the > > phone # in its own cell, > > > > When it gets displayed, I add a dash in between each part of the phon

Re: [PHP] MySQL Queries in PHP

2009-07-13 Thread Eddie Drapkin
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubb wrote: > Hi List, > Just wanted to pick your brains please? > I'm trying to standardise on the way I query databases and move away from > the Dreamweaver built-in functions (which I know you all hate!) ;) > I've been on this list for about 5 years now and

[PHP] MySQL Queries in PHP

2009-07-13 Thread Tom Chubb
Hi List, Just wanted to pick your brains please? I'm trying to standardise on the way I query databases and move away from the Dreamweaver built-in functions (which I know you all hate!) ;) I've been on this list for about 5 years now and I don't think I've ever heard anyone mention the Pear packag

Re: [PHP] MySql Injection advice

2009-07-13 Thread Eddie Drapkin
Things I have used prepared statements for: 1. SELECT 2. UPDATE 3. INSERT 4. DELETE 5. Stored procedures Things I am aware of that prepared statements are not capable of doing: What have you read that prepared statements can't do? I've not heard of anything, nor have I encountered anything, myse

Re: [PHP] MySql Injection advice

2009-07-13 Thread Andrew Ballard
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyan wrote: > for the phone #'s, I'm using int as the data type & storing each part of the > phone # in its own cell, > > When it gets displayed, I add a dash in between each part of the phone #'s > (country code-area code-1st set of digits-last set of digit

Re: [PHP] MySql Injection advice

2009-07-13 Thread Michael A. Peters
tedd wrote: At 3:53 PM -0400 7/12/09, Paul M Foster wrote: On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote: As for prepared statements, I'm no authority on them, but from what I've read they are not going to be something I'll be practicing anytime soon. Aside from Stuart's comment

Re: [PHP] MySql Injection advice

2009-07-13 Thread Bastien Koert
On Mon, Jul 13, 2009 at 5:52 PM, Ashley Sheridan wrote: > On Mon, 2009-07-13 at 16:30 -0400, Bastien Koert wrote: >> On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyan wrote: >> > On July 13, 2009 09:48:54 am Haig Dedeyan wrote: >> >> On Monday 13 July 2009 14:31:09 tedd wrote: >> >> > At 3:53 PM -0400

Re: [PHP] MySql Injection advice

2009-07-13 Thread Ashley Sheridan
On Mon, 2009-07-13 at 16:30 -0400, Bastien Koert wrote: > On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyan wrote: > > On July 13, 2009 09:48:54 am Haig Dedeyan wrote: > >> On Monday 13 July 2009 14:31:09 tedd wrote: > >> > At 3:53 PM -0400 7/12/09, Paul M Foster wrote: > >> > >On Sun, Jul 12, 2009 at

Re: [PHP] MySql Injection advice

2009-07-13 Thread Bastien Koert
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyan wrote: > On July 13, 2009 09:48:54 am Haig Dedeyan wrote: >> On Monday 13 July 2009 14:31:09 tedd wrote: >> > At 3:53 PM -0400 7/12/09, Paul M Foster wrote: >> > >On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote: >> > > >> > > >> > > >> > >>  As for

Re: [PHP] MySql Injection advice

2009-07-13 Thread Haig Dedeyan
On July 13, 2009 09:48:54 am Haig Dedeyan wrote: > On Monday 13 July 2009 14:31:09 tedd wrote: > > At 3:53 PM -0400 7/12/09, Paul M Foster wrote: > > >On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote: > > > > > > > > > > > >> As for prepared statements, I'm no authority on them, but from what

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-13 Thread Govinda
I have this code: $db_billing=mysqli_connect(localhost,metheuser,mypass,billing); if (mysqli_connect_error()) { die("Can't connect: " . mysqli_connect_error()); } mysqli //$dbname = 'billing'; $sql = "SHOW TABLES"; $result = mysql_query($sql); // line 53

Re: [PHP] MySql Injection advice

2009-07-13 Thread Ashley Sheridan
On Monday 13 July 2009 14:31:09 tedd wrote: > At 3:53 PM -0400 7/12/09, Paul M Foster wrote: > >On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote: > > > > > > > >> As for prepared statements, I'm no authority on them, but from what > >> I've read they are not going to be something I'll be prac

Re: [PHP] MySql Injection advice

2009-07-13 Thread tedd
At 3:53 PM -0400 7/12/09, Paul M Foster wrote: On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote: As for prepared statements, I'm no authority on them, but from what I've read they are not going to be something I'll be practicing anytime soon. Aside from Stuart's comments about slown

Re: [PHP] MySql Injection advice

2009-07-13 Thread tedd
At 8:50 PM +0530 7/12/09, Zareef Ahmed wrote: On Sun, Jul 12, 2009 at 8:42 PM, tedd <tedd.sperl...@gmail.com> wrote: As with all communication, it's better to be clear than obtuse. Agree, but I believe "obtuse" word meaning is contextual and depends :) The wo

Re: [PHP] MySql Injection advice

2009-07-13 Thread Haig Dedeyan
On July 12, 2009 08:52:56 am Haig Dedeyan wrote: > At 6:39 PM -0400 7/11/09, Haig Dedeyan wrote: > > [1] > > >mysql_query("INSERT INTO phonedir > >(fname, lname) VALUES('$new_fname','$new_lname')") > >or die(mysql_error()); > > > >or > > [2] > > >mysql_query("INSERT INTO phonedir > >(fname, lname)

Re: [PHP] MySql Injection advice

2009-07-13 Thread Haig Dedeyan
On July 12, 2009 03:34:49 pm Haig Dedeyan wrote: > On Sat, 11 Jul 2009 21:26:36 -0400, Haig Dedeyan wrote: > >> On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan wrote: > >>> mysql_query("INSERT INTO phonedir > >>> (fname, lname) VALUES('$new_fname','$new_lname')") > >>> or die(mysql_error()); > > >

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Zareef Ahmed
On Mon, Jul 13, 2009 at 3:19 AM, Govinda wrote: > On Sat, Jul 11, 2009 at 19:57, Govinda >> wrote: >> >>> I have been using PEAR's tableInfo() to remind myself about the columns >>> in >>> the table.. but now I want to see as much data as possible about the >>> table >>> and its contents *without

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Daniel Brown
Top-posting. This would be an excellent question for Prune (CC'd) to field, based on the error message. Prune? On Sun, Jul 12, 2009 at 17:49, Govinda wrote: >> On Sat, Jul 11, 2009 at 19:57, Govinda >> wrote: >>> >>> I have been using PEAR's tableInfo() to remind myself about the co

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Govinda
On Sat, Jul 11, 2009 at 19:57, Govinda wrote: I have been using PEAR's tableInfo() to remind myself about the columns in the table.. but now I want to see as much data as possible about the table and its contents *without* using PEAR. (I.e. just using built in stuff for mysqli.) Th

Re: [PHP] MySql Injection advice

2009-07-12 Thread Paul M Foster
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote: > > As for prepared statements, I'm no authority on them, but from what > I've read they are not going to be something I'll be practicing > anytime soon. Aside from Stuart's comments about slowness, what else have you read that makes you dis

Re: [PHP] MySql Injection advice

2009-07-12 Thread Nisse Engström
On Sat, 11 Jul 2009 21:26:36 -0400, Haig Dedeyan wrote: >> On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan wrote: >>> mysql_query("INSERT INTO phonedir >>> (fname, lname) VALUES('$new_fname','$new_lname')") >>> or die(mysql_error()); > > I won;t be using 2x escapes but I just need to know if I sho

Re: [PHP] MySql Injection advice

2009-07-12 Thread Zareef Ahmed
On Sun, Jul 12, 2009 at 8:42 PM, tedd wrote: > At 8:24 PM +0530 7/12/09, Zareef Ahmed wrote: > >> On Sun, Jul 12, 2009 at 6:32 PM, tedd < >> tedd.sperl...@gmail.com> wrote: >> >> Hi gang: >> >> I am top posting only to show that the following post makes no sense as

Re: [PHP] MySql Injection advice

2009-07-12 Thread tedd
At 8:24 PM +0530 7/12/09, Zareef Ahmed wrote: On Sun, Jul 12, 2009 at 6:32 PM, tedd <tedd.sperl...@gmail.com> wrote: Hi gang: I am top posting only to show that the following post makes no sense as to who said what. At what point here Zareef, did you think yo

Re: [PHP] MySql Injection advice

2009-07-12 Thread Zareef Ahmed
On Sun, Jul 12, 2009 at 6:32 PM, tedd wrote: > Hi gang: > > I am top posting only to show that the following post makes no sense as to > who said what. > > At what point here Zareef, did you think you were helping anyone? Or is > this more of your "I'm going to do whatever I want" attitude? > A

Re: [PHP] MySql Injection advice

2009-07-12 Thread tedd
At 9:26 PM -0400 7/11/09, Haig Dedeyan wrote: @Tedd - I will be looking into prepared statements eventually but I still want to understand escaping. Haig: I'm not the one pushing the prepared statements, that's someone else. However, I can see how you might think that considering how people

Re: [PHP] MySql Injection advice

2009-07-12 Thread tedd
Hi gang: I am top posting only to show that the following post makes no sense as to who said what. At what point here Zareef, did you think you were helping anyone? Or is this more of your "I'm going to do whatever I want" attitude? I would hate to review code with such lack of forethought

Re: [PHP] MySql Injection advice

2009-07-12 Thread tedd
At 6:39 PM -0400 7/11/09, Haig Dedeyan wrote: [1] mysql_query("INSERT INTO phonedir (fname, lname) VALUES('$new_fname','$new_lname')") or die(mysql_error()); or [2] mysql_query("INSERT INTO phonedir (fname, lname) VALUES('".mysql_real_escape_string($new_fname)."','".mysql_real_escape_stri

Re: [PHP] MySql Injection advice

2009-07-11 Thread Zareef Ahmed
2009/7/12 Haig Dedeyan > On July 11, 2009 08:21:34 pm Haig Dedeyan wrote: > > On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan > wrote: > > > On July 11, 2009 10:57:14 am Haig Dedeyan wrote: > > > > At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote: > > > > > > > > [1] > > > > > > > > >$fname = mysql_r

Re: [PHP] MySql Injection advice

2009-07-11 Thread Haig Dedeyan
On July 11, 2009 08:21:34 pm Haig Dedeyan wrote: > On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan wrote: > > On July 11, 2009 10:57:14 am Haig Dedeyan wrote: > > > At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote: > > > > > > [1] > > > > > > >$fname = mysql_real_escape_string($fname); > > > >$lname =

Re: [PHP] MySql Injection advice

2009-07-11 Thread Zareef Ahmed
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan wrote: > On July 11, 2009 10:57:14 am Haig Dedeyan wrote: > > At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote: > > > > [1] > > > > >$fname = mysql_real_escape_string($fname); > > >$lname = mysql_real_escape_string($lname); > > > > > >$sql = "UPDATE phon

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-11 Thread Daniel Brown
On Sat, Jul 11, 2009 at 19:57, Govinda wrote: > I have been using PEAR's tableInfo() to remind myself about the columns in > the table..  but now I want to see as much data as possible about the table > and its contents *without* using PEAR.   (I.e. just using built in stuff for > mysqli.) Thi

[PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-11 Thread Govinda
I have been using PEAR's tableInfo() to remind myself about the columns in the table.. but now I want to see as much data as possible about the table and its contents *without* using PEAR. (I.e. just using built in stuff for mysqli.) I have been looking through the manuals, even tried th

Re: [PHP] MySql Injection advice

2009-07-11 Thread Stuart
2009/7/12 Eddie Drapkin : > No offense or anything, but all of this work you've done is > immediately mode obsolete the second you switch to prepared > statements.  They're easier to use and more secure, as well as making > code more readable.  I don't understand why it's so hard for them to > catc

Re: [PHP] MySql Injection advice

2009-07-11 Thread Eddie Drapkin
On Sat, Jul 11, 2009 at 6:39 PM, Haig Dedeyan wrote: > On July 11, 2009 10:57:14 am Haig Dedeyan wrote: >> At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote: >> >> [1] >> >> >$fname = mysql_real_escape_string($fname); >> >$lname = mysql_real_escape_string($lname); >> > >> >$sql = "UPDATE phonedir SET f

Re: [PHP] MySql Injection advice

2009-07-11 Thread Haig Dedeyan
On July 11, 2009 10:57:14 am Haig Dedeyan wrote: > At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote: > > [1] > > >$fname = mysql_real_escape_string($fname); > >$lname = mysql_real_escape_string($lname); > > > >$sql = "UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE > > id=$id"; $result =

Re: [PHP] MySql Injection advice

2009-07-11 Thread tedd
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote: [1] $fname = mysql_real_escape_string($fname); $lname = mysql_real_escape_string($lname); $sql = "UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id"; $result = mysql_query($sql); echo mysql_error() . "\n"; This will result in th

Re: [PHP] MySql Injection advice

2009-07-11 Thread Phpster
On Jul 10, 2009, at 10:12 PM, Haig Dedeyan wrote: Hi everyone, I'm starting to experiment with an edit form and I am seeing the following behaviour: $fname = mysql_real_escape_string($fname); $lname = mysql_real_escape_string($lname); $sql = "UPDATE phonedir SET fname = '$fname',l

Re: [PHP] MySql Injection advice

2009-07-10 Thread Haig Dedeyan
On July 10, 2009 11:26:04 pm Haig Dedeyan wrote: > Haig Dedeyan wrote: > > Hi everyone, > > > > I'm starting to experiment with an edit form and I am seeing the > > following behaviour: > > > > $fname = mysql_real_escape_string($fname); > > $lname = mysql_real_escape_string($lname); > > > > > > $sq

Re: [PHP] MySql Injection advice

2009-07-10 Thread Michael A. Peters
Haig Dedeyan wrote: Hi everyone, I'm starting to experiment with an edit form and I am seeing the following behaviour: $fname = mysql_real_escape_string($fname); $lname = mysql_real_escape_string($lname); $sql = "UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id"; $result

[PHP] MySql Injection advice

2009-07-10 Thread Haig Dedeyan
Hi everyone, I'm starting to experiment with an edit form and I am seeing the following behaviour: $fname = mysql_real_escape_string($fname); $lname = mysql_real_escape_string($lname); $sql = "UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id"; $result = mysql_query($sql);

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Phpster
On Jul 10, 2009, at 5:25 PM, "workerho...@studysite.eu" > wrote: first thanks to all who have read ;-) your solution looks like the method how i done it actually, i have tested the last hours the solution with sql lite on application server the Solution: 3 Mysql Server ( 1 more to han

Re: [PHP] mysql cache query as xml

2009-07-10 Thread workerho...@studysite.eu
first thanks to all who have read ;-) your solution looks like the method how i done it actually, i have tested the last hours the solution with sql lite on application server the Solution: 3 Mysql Server ( 1 more to handle the big load ) (1 Master, 2 Slaves) mysql replication 10 Applikatio

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Michael A. Peters
workerho...@studysite.eu wrote: hi andrew i think you understand my problem a little, but if 100 user load this query at the same time, the two mysql server had a lot to do! so i think to cache this query as xml to the application server local make thinks faster, but, i would like to have the s

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Jon Tamayo
On Fri, 10 Jul 2009 13:29:31 -0400 Bastien Koert wrote: > On Fri, Jul 10, 2009 at 1:23 PM, > workerho...@studysite.eu wrote: > > hmm, the infrastructure ist good, this is just this query > > so to solve my problem i could run mysql on the application server > > and store just this table > > a

Re: [PHP] mysql cache query as xml

2009-07-10 Thread workerho...@studysite.eu
yes i think i should do this Daniel Brown schrieb: On Fri, Jul 10, 2009 at 13:23, workerho...@studysite.eu wrote: hmm, the infrastructure ist good, this is just this query so to solve my problem i could run mysql on the application server and store just this table and read the query

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Bastien Koert
On Fri, Jul 10, 2009 at 1:23 PM, workerho...@studysite.eu wrote: > hmm, the infrastructure ist good, this is just this query > so to solve my problem i could run mysql on the application server and store > just this table > and read the query from them, it could solve my problem litte, i hope s

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Daniel Brown
On Fri, Jul 10, 2009 at 13:23, workerho...@studysite.eu wrote: > hmm, the infrastructure ist good, this is just this query > so to solve my problem i could run mysql on the application server and store > just this table > and read the query from them, it could solve my problem litte, i hope so!

Re: [PHP] mysql cache query as xml

2009-07-10 Thread workerho...@studysite.eu
hmm, the infrastructure ist good, this is just this query so to solve my problem i could run mysql on the application server and store just this table and read the query from them, it could solve my problem litte, i hope so! Daniel Brown schrieb: On Fri, Jul 10, 2009 at 13:07, workerho..

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Daniel Brown
On Fri, Jul 10, 2009 at 13:07, workerho...@studysite.eu wrote: > hi andrew i think you understand my problem a little, > but if 100 user load this query at the same time, the two mysql server had a > lot to do! > so i think to cache this query as xml to the application server local make > thinks fa

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Daniel Brown
On Fri, Jul 10, 2009 at 12:59, Andrew Ballard wrote: > > I understood the question to be how to improve performance by caching > MySQL results into an XML document (which, given that it was posted > here) within a PHP script. Perhaps this is not the correct > interpretation, but if so it would be r

Re: [PHP] mysql cache query as xml

2009-07-10 Thread workerho...@studysite.eu
hi andrew i think you understand my problem a little, but if 100 user load this query at the same time, the two mysql server had a lot to do! so i think to cache this query as xml to the application server local make thinks faster, but, i would like to have the same performance to read this xml

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Andrew Ballard
On Fri, Jul 10, 2009 at 12:36 PM, Daniel Brown wrote: >    Chris; > >    From my understanding of your question, your message (included > below in its entirety) is better sent to the MySQL General list, which > I've CC'd on this reply.  If you haven't yet, please subscribe there > at mysql-subscr..

Re: [PHP] mysql cache query as xml

2009-07-10 Thread Daniel Brown
Chris; From my understanding of your question, your message (included below in its entirety) is better sent to the MySQL General list, which I've CC'd on this reply. If you haven't yet, please subscribe there at mysql-subscr...@lists.mysql.com to follow the thread for responses. If I

[PHP] mysql cache query as xml

2009-07-10 Thread workerho...@studysite.eu
hi guys, i need some help by optimize the performance. my problem is that i need a lot of rows the whole site (don't ask i need the rows really :-) ) this is about ~4000 rows it will be loaded from mysql database in 0.3 seconds my idea was to cache this rows in a xml file like for example:

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Shawn Simmons
Sorry about thatI wasn't sure if it went the first time when I didn't see the post sfter a refresh8-) "Daniel Brown" wrote in message news:ab5568160906190558u1a585cedpf73eb5690330d...@mail.gmail.com... On Thu, Jun 18, 2009 at 22:10, Shawn Simmons wrote: Greetings Gurus! Also,

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Daniel Brown
On Thu, Jun 18, 2009 at 22:10, Shawn Simmons wrote: > Greetings Gurus! Also, please keep new threads on the list limited to one at a time, except in extenuating circumstances. And as a developer, there certainly are and will be more of those circumstances. ;-P -- daniel.br...@parasane.net

RE: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Yuri Yarlei
Yarlei. Programmer PHP, CSS, Java, PostregreSQL; Today PHP, tomorrow Java, after the world. Kyou wa PHP, ashita wa Java, sono ato sekai desu. > To: php-general@lists.php.net > From: elcid...@gmail.com > Date: Thu, 18 Jun 2009 22:10:44 -0400 > Subject: [PHP] PHP MySQL 500 In

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Paul Scott
On Thu, 2009-06-18 at 22:10 -0400, Shawn Simmons wrote: > Wrote a small script to connect to the MySql database. Tried to run the > script (http://localhost/dbscript.php) and I get a 500 Internal Server > error. I have been up and down the web for two days looking for a solution > and I am com

<    1   2   3   4   5   6   7   8   9   10   >