monbster

Re: A simple, fast database class for PHP 4+ and MySQL how much faster is this, has anyone performed benchmarks? also curious if the improvements would be in CPU cycles or memory usage

Re: Anti-sql injection function   That should work, the trim probably isn't necessary. Also remember that mysql_real_escape_string() does not escape % and _. These are wildcards in MySQL if combined with LIKE, GRANT, or REVOKE. If you use LIKE to compare an input string, use = instead: SELECT * FROM `BankAccounts` WHERE `baAccountName` = CONVERT( _utf8 'Somename' USING latin1 ) COLLATE latin1_swedish_ci

Re: help testing proxy detector   proxies are usually detected if they are open, meaning allowing anyone to use them. local networks usually don't have a proxy server, or if they do, do not have open use (use is restricted to the internal network)

Re: PHP Configuration?   try using emacs php.ini in the correct directory. if you have permission the file should open for writing.

Re: More fun   Nice, very informative! Can anyone explain more what this means? How does one "construct a database class"? Thanks

Re: merging multiple databases in 1 issue are you trying to combine two databases, or two tables? i wanted to migrate some db's so i used PHPAdmin to export to file (as SQL statements), then import into the other database.

Re: Java So yeah the original question made no sense, but for people working Java I recommend Eclipse http://www.eclipse.org/ ^ I've heard good things about Notepad++ too

Re: About Javascript Can anyone recommend a good site for JS guides and samples?

Re: About Javascript Nice post :-) Anyone want to guess who in the hell decided to name those two languages (Java and Javacript) so freaking similarly?? Of course once you learn the distinction it's no problem, but why... why...

Re: Count in base 27   <? $a = 85; $b = 24; echo " Original value of \$a is $a and \$b is $b</P>"; $c = $a % $b; echo " The modulus of \$a and \$b is $c</P>"; ?>   then read http://en.wikipedia.org/wiki/Modulo_operation and http://en.wikipedia.org/wiki/Base_%28mathematics%29 basically what you want to do is find the remainder (modulus) of the number you have, and the base you want it in. So for example, if you want to express "43" in base 8: first divide 43 by 8 = 5 point something then find the remainder with 43 mod 8 = 3 so 43 in base 8 would be 5*8 + 3 sort of like how 43 in base 10 is 4*10 + remainder (3)

Re: Charts, graphs or other data display Well for anyone that needs to make real nice looking charts and data displays I would definitely recommend PEAR Image_Graph. The output is at least as good as Excel '98 and can look even better with some tweaking.

Re: Count in base 27 to count in different bases learn how to use the modulus operator http://us2.php.net/operators.arithmetic

Re: A way to protect against sql injection   Why don't you scroll up a bit in the topic and see that someone already posted a code example, also as mentioned you can simply use addslashes() when you get the inputs, just do something like $inputWhateva = addslashes($_GET['fieldname']);

After some attempts with Javascript charting tools, I've found PHP to be much better suited for the task. Using the Image_Graph package (http://pear.veggerby.dk/) from PEAR (http://pear.php.net/) I've managed to make some nice charts. However, there are some things I'm unable to do, so I was wondering what anyone else has used to output chart or graph data?

Re: A way to protect against sql injection Can anyone explain what the difference is with / without magic quotes? Also the function posted by stryker looks good, I use something similar except try to escape the quotes using addslashes() on the inputs.