Re: [PHP-DB] PHP IDE

Aron Pilhofer wrote: >After spending two frustrating hours tracking down a bug yesterday - only to >discover it was a misplaced quote mark. I've had it. > >I am looking for suggestions out there for a good IDE for PHP development, >preferably one that doesn't cost an arm and a leg. I tried

Re: [PHP-DB] Performance Improvements

Also, do you really need all those trim()'s? Maybe at least you could replace them with ltrim()'s or rtrim()'s - I don't know what your data is, but maybe you can pre-parse it? (i.e. keep the data trimmed in the db). All of the if ($something > 0) can generally be changed to if ($something) -

Re: [PHP-DB] Performance Improvements

My first suggestion: replace all split() calls with explode() calls. Bogdan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Performance Improvements

Hello, Currently the following section of code is taking over 30 seconds to complete. It basically returns from a database 30,000 records. What changes do any of you recommend that would speed of the following code? Thank you , lee leahu [EMAIL PROTECTED] while ($row = mysql_

[PHP-DB] PHP or Perl?

I'm doing a bioinformatics project, which of course involves large databases. I will be using MS SQL Server and Visual Basic. A scripting language is also needed. Perl is very popular for bioinformatics. Should I use VBScript, PHP, or Perl? Thanks, Logan. -- PHP Database Mailing List (http://

Re: [PHP-DB] Re: PHP IDE

i use PHP CODER PR2 the newer version of it i think suks. so if u want it ask. I like it tons. Neil - Original Message - From: ACEAlex <[EMAIL PROTECTED]> To: php-db <[EMAIL PROTECTED]> Sent: Sunday, February 24, 2002 8:38 AM Subject: Re: [PHP-DB] Re: PHP IDE > I use homesite just to ta

[PHP-DB] Re:Instest of add, subtract

I (too often) find that odd behavior like this is because one of the variables is set incorrectly (not what I expected) even if it sometimes works. A very useful debugging technique is to print out $query just before you send it to the DB. You might be surprised at what you're sending. Personal

[PHP-DB] PHP advice

I dont understand why this is causing me so much trouble, hopefully someone can help. I have a simple PHP script that takes the user id and password from a form on a page...here is the php used after submitting the form: It connects fine, and when the query returns NO (0) rows, it appears co

[PHP-DB] RC4 encryption with PHP

I am trying to encrypt a credit card number using rc4 and php and then dump it into a mySql database. Does anyone have any sample code that allows me to do this?? I found the Class.RC4Crypt algorithm and would like to use that. When I include the class.rc4crypt.php the page dies... Here is my

Re: [PHP-DB] Instest of add, subtract.

Well, there are quite some differences difference between the results these two pieces of code yield. Let's see what your sql query would be for the first version, replacing $deposit in $query: UPDATE wt_users set bank_points + $user_depositset points - $user_deposit WHERE uid={$session["uid"]

Re: [PHP-DB] DB question

No, at 1000+ you shouldn't have problems, almost no matter what database/data you're using. You may start getting slowdowns at 100,000+ users if you have a lot of data and probably 500,000+ if you have the reasonable data usually required. Anyway, using a different database for each user would

Re: [PHP-DB] Re: PHP IDE

I use homesite just to tag the functions in different colors - Original Message - From: "robert janeczek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 23, 2002 8:59 PM Subject: [PHP-DB] Re: PHP IDE > > After spending two frustrating hours tracking down a bug yest

[PHP-DB] DB question

Hi, I am about to make a homepage where people can sign up. It is then possible for the user to enter a lot of different data about them self. Is it normal to make a database for each user or should I make one big one? If I make a big one am I going to get problems if I has 1000+ users and everybo

[PHP-DB] Re: PHP IDE

> After spending two frustrating hours tracking down a bug yesterday - only to > discover it was a misplaced quote mark. I've had it. > > I am looking for suggestions out there for a good IDE for PHP development, > preferably one that doesn't cost an arm and a leg. I tried PHP4EE studio, > but

[PHP-DB] Instest of add, subtract.

Hi, Instead of helping with my other question maybe you can tell me why this wont work? Is it not valid ? Can you not use strings in a query like this? $deposit="set bank_points + $user_deposit"; $deposit .="set points - $user_deposit"; $query = ("UPDATE wt_users $deposit WHERE uid={$session["u

[PHP-DB] Re: MySQL problem

It means there is a problem with your query. I'm not familiar with the die(1) and die (2) syntax. I'm not sure what that does, but you might try echoing your error message from the query to see what message you get. Hope that helps. "Caleb Walker" <[EMAIL PROTECTED]> wrote in message [EMAIL PROT

[PHP-DB] PHP IDE

After spending two frustrating hours tracking down a bug yesterday - only to discover it was a misplaced quote mark. I've had it. I am looking for suggestions out there for a good IDE for PHP development, preferably one that doesn't cost an arm and a leg. I tried PHP4EE studio, but it is bugg

[PHP-DB] Re: Getting the ID of the last inserted record possible?

What database are you talking about? Andy <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > I would like to name pictures I uploaded after the belonging ID in the db. > > Is there a way to find out the ID of the last record. I thought it might be >

Re: [PHP-DB] Using checkbox in php problem

Oh!! That is my careless mistake! I would uncheck the box when the box is checked for example. That solution cannot work on the javascript. "Bogdan Stancescu" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > This is only part of the solution, but you should be aware t

Re: [PHP-DB] Getting the ID of the last inserted record possible?

mysql_insert_id() Regards Andrey - Original Message - From: "Andy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 23, 2002 3:32 PM Subject: [PHP-DB] Getting the ID of the last inserted record possible? > Hi there, > > I would like to name pictures I uploaded aft

[PHP-DB] Getting the ID of the last inserted record possible?

Hi there, I would like to name pictures I uploaded after the belonging ID in the db. Is there a way to find out the ID of the last record. I thought it might be a good idea to create the record, get the ID and copy the image with the ID as name to the server. Can anybody give me a hint on that?

Re: [PHP-DB] Using checkbox in php problem

This is only part of the solution, but you should be aware that "==" is a comparison operator whereas "=" is the assignment operator. Bogdan Killer Angel Clark wrote: >I add a checkbox in my page and will use the check result on another page. >If it is checked, it has no problem. However, if i

[PHP-DB] Using checkbox in php problem

I add a checkbox in my page and will use the check result on another page. If it is checked, it has no problem. However, if it is not checked, it will have the checkbox unknown error. I read from an article that I can add a hidden field with the same name of the checkbox and put a value on this hi