Codezwiz >> Forums >> General PHP Nuke Help >> global variables and MySQL

Register

How do i assign a variable global?? Case in point, im trying to connect to the database, but im tired of typing it in on all the pages that query it. So, I'm trying to assign $dbconnect the connection of the database, then the query will be whatever the user is doing.

Also, and srry, im wanting to put something into the database, can someone explain to me what exactly tables and feilds are, and just how to put something in them from the web? Thanks, Wolf.

Register

any help here would be greatly appreciated...

Make a file with the db connection stuff then simply use an include on ever file that needs connecting to the database.

The database is the large thing which is then divided into tables. Each tables has "headings" for example userID, userName, userPassword. Then the "headings" would be set into the table and you could add records under the "headings"

Register

I just use the way nuke does if i'm making a php mysql site, include it in the header, then you can just use mysql( whatever ) or i duno i forget how ya do that lol

instead of putting include whenever ya wana use it

Register

ok, so i would make an external file with the "connection", not the queries or inserts?

and im trying to figure out what exactly to put my information into...this is how i see it

you have the database that stores everything, then you have tables inside of the db...then fields inside the tables.

if my users type in their email...where do i store that information in the database? in the field? or is there something else?

Thanks, Wolf

Yeah, so you have a connection.php file, this contains how the file is connected to the database, so you can simply use an include everytime everytime you want to connect to the db rather than writing it out. Also, protect the file from access, i don't think it's possible to read PHP code from a webserver, but if they can they've got your database username and password so you're a bit pruned.

I'm glad I'm not the one trying to make sense of all that!

Here are some tutorials that might help:
[ Register or login to view links on this board. ] [ Register or login to view links on this board. ]

Register

Thanks Kelly, it helped a bit. And thanks splinter, i got the include() going, and the code looks so much cleaner.