blogs

"The Woyano? About Tech. Show" -- Listen Now!

powered by ODEO
In this weeks show: Do ugly websites make more money? Does net porn innovate new technology? Zune humour, and other general tech. discussion... WARNING! 18+ with explicit Language -- Subscribe to podcast

After having spent the past four years working for Elsevier as Senior Web Developer for FIRSTConsult, I've decided to make the rather scary jump from corporate blue-chip to the world of start-ups.

As of Mon. 30th Oct 2007 I will be Tech dir. for a new Web 2.0 start-up Woyano?

The new company website is scheduled to launch in Feb 2007, if you would like to register to become a beta-tester for this great new concept then click-here!

have query in my database

Can help me how to user EzSQL query in Examples..

I'm here to learn ezSQL.

My sites:

Knowing Art: abstract artist interviews
Ferodynamics: blog about SEO, CSS, PHP, etc.

hi

Hi all,

In case it may be useful for someone, I made this ad-hoc solution to allow auto-escaping of variables. The advantage of this approach is that one can embed the variables directly within the query (not needing to pass the variables separately). The only thing you have to do is add a backslash before the variable. I've written it for MySQL, but I think you should be able to use the approach to add this for other databases that allow such escaping.

This is pretty much my first time doing anything with object oriented code, so my approach may be off base (let me know). But, it does seem to work. This approach has one disadvantage though; any variables to be escaped in this way have to be declared global if they are within a function, as must your object itself. This may limit its use for some people, but to get this ease of use, I really couldn't find any other way to implement it.

I used following code to fatch results and display


include_once "../shared/ez_sql_core.php";
include_once "ez_sql_mysql.php";
include_once "ez_results.php";

?>


it displays only first 3 columns even though as many columns it is requested.
if i use $ezr->debug(); then it shows all columns data was fetched. only display() function shows only 3 columns. When I examine the class, I checked display function which echos results prepared by get() which also do not show where it determines to show only 3 columns.

I've modified the MySQL version to work with ODBC. It's a quick rewrite that has not been extensively tested, but I guess it's a good base to continue from..

ez_sql_odbc_v01

Hi all.
I've found this spectacular packet, but on my server the last version (2.0) is not working. Version 1.26, instead is working.
I installed ezsql 2.0 and ez Results...
I've update with $db_user, $db_password... etc etc, but I've already this error:

Warning: Invalid argument supplied for foreach() in c:\www\classes\ez_sql_v2\mysql\demo.php on line 31

This little AJAX tool converts your HTML-ish code (and sometimes PHP code) for you. I just used it for this site and it is handy. Converts to HTML entities so you don't have to go through and add < and > to your tags, as well as & gets changed to &, etc.

http://www.elliotswan.com/postable/

Sean