[Resolved] ezsql db object

[eerok]

Hello all

I've been having fun learning php/mysql, but one thing confuses me a bit.

I thought I'd try out ezsql, but when I do

include_once "ez_sql.php";

in my index.php, the db object is not globally available.

To be more specific, I'm saving a textarea to a mysql database, and the handler file for the form action can't find the db unless it's included at the top of that particular file.

Should it really matter where you "include once" as long as it's before you need the code?

edit: ack, never mind -- I think I understand now 🙂

[gufmn]

Includes are basically just a way to keep your code clean by breaking it up into sections. When you include a file it's as though that file and the file that included it are one file. All the information from the included file is available to the first file. That's it.

So ez_sql.php is seen by index.php but not by the handler file which is prolly the one that actually needs to see it. Just move your include statement to your handler file.

I've found a good practice is to have one file with all of your utilities and include that 1 file in all your others, this way you can call any functions from that file from wherever, whenever.

Just be careful not to include the same file twice. Example:

file C contains utilities
file B includes file C
file A includes file B and file C

This will throw errors about redeclaring functions since file A is trying to include file C, but file C is already included because file A includes file B which already includes file C.

That should be confusing enough 🙂

[eerok]

Thx for the reply, gufmn

I thought I was starting to understand the codebase I'm studying as a model (b2evolution), but of course I need to keep at it a while longer 🙂

I understand what you're saying, though, and I'll give it a try.