Re: [PHP] inserting ´ in a db

2007-10-04 Thread Aleksandar Vojnovic
Pick one: http://si2.php.net/manual/en/function.htmlentities.php http://si2.php.net/manual/en/function.addslashes.php http://si.php.net/mysql_escape_string Aleksandar Yamil Ortega wrote: Hi list, good day. I have a simple script that inserts text on a mysql table, that has a field named

Re: [PHP] Sessions running out of storage space - Increase memory?

2007-10-04 Thread Per Jessen
Dan wrote: After thinking about this a while I also thought of making my own cache. The problem with that is would it be any faster or have any less strain on the server than having multiple requests/connections to the database? A lot depends on the amount of data and the overall load on the

Re: [PHP] Alternate Colors in Rows

2007-10-04 Thread Robert Cummings
On Wed, 2007-10-03 at 22:12 -0400, Nathan Nobbe wrote: On 10/3/07, Robert Cummings [EMAIL PROTECTED] wrote: Hopefully you're using a decent browser (almost anything other than IE -- I recommend Opera :) opera is the best for straight browsing. ive found i could have 40 to

Re: [PHP] Re: the opposite of a join?

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 11:56 +1000, Chris wrote: Robert Cummings wrote: On Thu, 2007-10-04 at 11:23 +1000, Chris wrote: Robert Cummings wrote: On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote: This is only from my own personal testing. Mind you that I have only been using PostgreSQL

Re: [PHP] Alternate Colors in Rows

2007-10-04 Thread tedd
At 1:44 PM -0500 10/3/07, Steve Marquez wrote: Greetings, I am attempting to alternate the colors of the container DIV. Anyone know how to do this? Hi Steve: Easy and simple. First, keep presentation separate from data. In other words, use css to define a css-class, like so: .row0

Re: [PHP] Any known security issues with IMAP?

2007-10-04 Thread Andrew Ballard
On 10/4/07, Chris [EMAIL PROTECTED] wrote: Don O'Neil wrote: I'm not sure how opening an email inbox can hijack pages but maybe someone more creative than I can show me.. I don't know about the IMAP/POP3 itself, but if you are displaying the messages in a web browser for something like

[PHP] MySQL Identifying worst-performing codes

2007-10-04 Thread Lasitha Alawatta
Hello friends, There is a tool call idera (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures,

[PHP] session_start is slow occasionally

2007-10-04 Thread al jo
Hi i have a site that is relatively high loaded (~20 reloads/sec) and i am trying to optimize it. So i have started timing sections of the php scripts to find out which is the slowest so i optimize it first. I write the times to a database( timings are done on the live server). So now when

RE: [PHP] MySQL Identifying worst-performing codes

2007-10-04 Thread Jay Blanchard
[snip] There is  a tool call idera (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature;  Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures, long-running queries, most

[PHP] Karma Rating the new way of rating anything? Your opinion on this please.

2007-10-04 Thread Mark
Hey, i just made a post on digg: http://digg.com/programming/Karma_Rating_the_new_way_of_rating_anything which links to this: http://magedb.wordpress.com/2007/10/04/karma-rating-new-type-of-rating/ (feel free to click the links) It's about a new rating method that i just made up that might

[PHP] socket_read() hangs with FTP

2007-10-04 Thread Serge
Hello. I'm tried an example from PHP manual with simple TCP/IP Client. I'm create a socket to FTP server, then read data from socket [PHP] while ($out = socket_read($socket, 2048)) { echo $out; } [/PHP] when all data are read, socket_read() don't return an empty string, it's hangs. Can you

[PHP] Problem with eAccelerator 0.9.5.2

2007-10-04 Thread Miguel J. Jiménez
Hi, I am new to eAccelerator... when I use purge or clean the apache error log says: * File does not exist: /var/www/PHPE6F78DE9-13E4-4dee-8518-5FA2DACEA803, referer: https://pitufina/eaccelerator.php * It does everytime I use eaccelerator_purge() or eaccelerator_clean() ... The error is

[PHP] Super bizarre changing variable!!

2007-10-04 Thread Brian Dunning
I'm running the following code: $query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation LIMIT $numtodelete; $result3 = mysql_query($query3); $string = $total found, $n kept, $numtodelete extras removed ($query3); $x = mysql_query(insert into table2 (friend_id,data) values

[PHP] http://go-pear.org?

2007-10-04 Thread Steve Brown
I'm trying to install Pear on OSX, but http://go-pear.org/ doesn't seem to be resolving. Pear manual states I should: curl http://go-pear.org/ | php but this fails and dig go-pear.org reveals that the name does not resolve. Is there a package somewehre I can download and install? -- PHP

[PHP] ssl in socket functions

2007-10-04 Thread Sergey Ignatenko
Hello guys, I have one small question and would greatly appreciate if you resolve it. Can I create ssl connection through the socket functions (not fsockopen)? Thanking in advance, Sergey Ignatenko. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] Re: Super bizarre changing variable!!

2007-10-04 Thread Colin Guthrie
Brian Dunning wrote: I'm running the following code: $query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation LIMIT $numtodelete; $result3 = mysql_query($query3); $string = $total found, $n kept, $numtodelete extras removed ($query3); $x = mysql_query(insert into table2

RE: [PHP] inserting ´ in a db

2007-10-04 Thread Warren Vail
You need to escape the single quote, an easy way to do this is to run the text thru the addslashes() filter. Obviously you can't run your entire query thru the filter thru the filter because most of your quotes need to be identified by the db. Here is what I do. $query = insert table1(col1,

Re: [PHP] Problem with eAccelerator 0.9.5.2

2007-10-04 Thread Robert Cummings
I would check for an eaccelerator mailing list. Personally I never use the web interface. Cheers, Rob. On Thu, 2007-10-04 at 17:29 +0200, Miguel J. Jiménez wrote: Hi, I am new to eAccelerator... when I use purge or clean the apache error log says: * File does not exist:

RE: [PHP] inserting ´ in a db

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 10:18 -0700, Warren Vail wrote: You need to escape the single quote, an easy way to do this is to run the text thru the addslashes() filter. Obviously you can't run your entire query thru the filter thru the filter because most of your quotes need to be identified by the

Re: [PHP] Re: Super bizarre changing variable!!

2007-10-04 Thread Brian Dunning
$referer is always an integer, 6 to 10 digits long. To clarify: the value of $referer is changing between line 1, where $query3 is being set, and line 4, where it's being written into my debugging log table2. I can't see any way that $referer could be different in those two places. On

[PHP] Re: MySQL Identifying worst-performing codes

2007-10-04 Thread Colin Guthrie
Lasitha Alawatta wrote: There is a tool call “idera” (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes – Identifies performance bottlenecks such as the worst-performing stored

RE: [PHP] inserting ´ in a db

2007-10-04 Thread Warren Vail
Rob, Your opinion would have meant more had you offered a solution. The only hole that I am aware of is the likelihood that the imbedded query could get executed accidentally later. If the database is mysql, there is finally a mysql function for filtering and mysql_real_escape_string(), if I am

RE: [PHP] inserting ´ in a db

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 10:55 -0700, Warren Vail wrote: Rob, Your opinion would have meant more had you offered a solution. The only hole that I am aware of is the likelihood that the imbedded query could get executed accidentally later. If the database is mysql, there is finally a mysql

Re: [PHP] Super bizarre changing variable!!

2007-10-04 Thread Richard Davey
Hi Brian, Thursday, October 4, 2007, 4:50:09 PM, you wrote: I'm running the following code: $query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation LIMIT $numtodelete; $result3 = mysql_query($query3); $string = $total found, $n kept, $numtodelete extras removed

[PHP] Re: Super bizarre changing variable!!

2007-10-04 Thread Colin Guthrie
Brian Dunning wrote: I'm running the following code: $query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation LIMIT $numtodelete; $result3 = mysql_query($query3); $string = $total found, $n kept, $numtodelete extras removed ($query3); $x = mysql_query(insert into table2

RE: [PHP] Alternate Colors in Rows

2007-10-04 Thread Daevid Vincent
This was a joke right? You don't seriously do this in r.l. just to alternate row colors I hope? -Original Message- From: Robert Cummings [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 6:36 PM To: Jim Lucas Cc: Steve Marquez; PHP eMail List Subject: Re: [PHP] Alternate

RE: [PHP] Re: Super bizarre changing variable!!

2007-10-04 Thread Instruct ICC
Brian Dunning wrote: I'm running the following code: $query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation LIMIT $numtodelete; $result3 = mysql_query($query3); $string = $total found, $n kept, $numtodelete extras removed ($query3); $x = mysql_query(insert into

[PHP] Generating PDF files (XSLT, ps, XSL-FO, FOP, etc)

2007-10-04 Thread Yannick Warnier
Hello, I'm currently researching a bit on a possible PDF export format for some of my application's output. So far, what I get is this: - some packages allow PDF generation (FPDF, EZPDF, etc) from nothing - some packages allow generation of PDF from HTML, using the ps format - some packages

RE: [PHP] Alternate Colors in Rows

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 12:28 -0700, Daevid Vincent wrote: This was a joke right? You don't seriously do this in r.l. just to alternate row colors I hope? This certainly was NOT a joke. I do use CSS classes. As for using a PHP class to implement the cycle-- No, I don't do that IRL. As I said in

RE: [PHP] Alternate Colors in Rows

2007-10-04 Thread WeberSites LTD
You can choose to view source with IE in other editors too. I use Editplus with IE7. berber -Original Message- From: Robert Cummings [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 2:50 PM To: Nathan Nobbe Cc: Jim Lucas; Steve Marquez; PHP eMail List Subject: Re: [PHP]

RE: [PHP] Alternate Colors in Rows

2007-10-04 Thread Daevid Vincent
My comment was not about the CSS -- if you saw my earlier post, I actually told the OP to never hardcode color/style if possible: -Original Message- Sent: Wednesday, October 03, 2007 12:58 PM Add this to your default.css file... Or to the page... style TR.dataRow1 {

[PHP] Reading files from Win 2003 Server

2007-10-04 Thread Alexis
Hi, I have a script located on an Ubuntu box and I am trying to read files located on a Win 2003 Server. I have 'mounted', if that's the right term to use, a connection from Ubuntu to Server 2003 and can read the files fine via the desktop, etc. If the Win Server name is say 'WinServer' and

RE: [PHP] Alternate Colors in Rows

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 22:14 +0200, WeberSites LTD wrote: You can choose to view source with IE in other editors too. I use Editplus with IE7. That wasn't the reason I pimped Opera though. I would NEVER use IEX as my development browser. I do all my HTML for Opera, then I check it in Firefox,

[PHP] Re: [PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-04 Thread John A DAVIS
left join where item in right table is null "Chris" [EMAIL PROTECTED] 10/3/2007 10:32:01 PM Aleksandar Vojnovic wrote: I would also suggest to limit yourself to things you actually need not to select the whole table.In this case you can't because you're looking for records that exist in

[PHP] Re: Super bizarre changing variable!!

2007-10-04 Thread Colin Guthrie
Richard Davey wrote: What data type do the referer / friend_id columns have in MySQL? int? tinyint? etc Ahh of course. That'll be it. The different tables will have different definitions of the friend_id field and one will be overflowing! Well spotted Richard wood for the trees for me

[PHP] Re: http://go-pear.org?

2007-10-04 Thread Gregory Beaver
Steve Brown wrote: I'm trying to install Pear on OSX, but http://go-pear.org/ doesn't seem to be resolving. Pear manual states I should: curl http://go-pear.org/ | php but this fails and dig go-pear.org reveals that the name does not resolve. Is there a package somewehre I can

[PHP] Core dumps with --with-openssl

2007-10-04 Thread Don O'Neil
I just tried rebuilding my apache php to the latest version and now whenever I try to start it it core dumps. If I remove the --with-openssl and build with 4.4.6 of php at least it starts. I can't even get my old version to build now... Is there a work-around for this? The setup is as follows:

Re: [PHP] Any known security issues with IMAP?

2007-10-04 Thread Chris
Andrew Ballard wrote: On 10/4/07, Chris [EMAIL PROTECTED] wrote: Don O'Neil wrote: I'm not sure how opening an email inbox can hijack pages but maybe someone more creative than I can show me.. I don't know about the IMAP/POP3 itself, but if you are displaying the messages in a web browser for

Re: [PHP] Re: [PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-04 Thread Chris
John A DAVIS wrote: left join where item in right table is null That's still going to look at all records in both tables: 1) so it can work out if there is a match from table 1 to table 2 2) so it can then remember to display any records that don't have a match I was thinking more that if

[PHP] A two flavored post

2007-10-04 Thread tedd
Hi gang: I asked this question on the javascript list, but for some reason it's taking forever to post there. So, I figured that I would ask here as well. I'm currently sending data (the value of s) to another script via the html statement: a href=img.php?s=?php echo($value);?Click here/a

Re: [PHP] session_start is slow occasionally

2007-10-04 Thread Chris
al jo wrote: Hi i have a site that is relatively high loaded (~20 reloads/sec) and i am trying to optimize it. So i have started timing sections of the php scripts to find out which is the slowest so i optimize it first. I write the times to a database( timings are done on the live

Re: [PHP] A two flavored post

2007-10-04 Thread Robert Cummings
On Thu, 2007-10-04 at 22:33 -0400, tedd wrote: Hi gang: I asked this question on the javascript list, but for some reason it's taking forever to post there. So, I figured that I would ask here as well. I'm currently sending data (the value of s) to another script via the html

Re: [PHP] A two flavored post

2007-10-04 Thread Nathan Nobbe
On 10/4/07, tedd [EMAIL PROTECTED] wrote: Hi gang: I asked this question on the javascript list, but for some reason it's taking forever to post there. So, I figured that I would ask here as well. I'm currently sending data (the value of s) to another script via the html statement: a

Re: [PHP] A two flavored post

2007-10-04 Thread heavyccasey
A simple example would be a href=img.php?s=?php echo($value);? onclick=this.href += 'othervalue=x';Click here/a On 10/4/07, Robert Cummings [EMAIL PROTECTED] wrote: On Thu, 2007-10-04 at 22:33 -0400, tedd wrote: Hi gang: I asked this question on the javascript list, but for some reason

[PHP] error messages

2007-10-04 Thread tbt
Hi I'm a newbie to php and i would like to know a way of viewing runtime errors on the browser. Currently when an error occurs nothing is displayed on the browser. Is there any way of viewing all error messages on the browser itself. Thanks -- View this message in context:

Re: [PHP] error messages

2007-10-04 Thread Paul Scott
On Thu, 2007-10-04 at 22:38 -0700, tbt wrote: I'm a newbie to php and i would like to know a way of viewing runtime errors on the browser. Currently when an error occurs nothing is displayed on the browser. Is there any way of viewing all error messages on the browser itself. You can up