Language…
6 users online: Danik2343, DixyNL, Firstnamebutt,  Losoall, tOaO, Zavok - Guests: 157 - Bots: 336
Users: 64,795 (2,381 active)
Latest user: mathew

It's the PHP and SQL thread! =D

PHP stands for "PHP Hypertext Preprocessor". Recursive acronym!

If you've ever coded in Java, or maybe even Visual Basic, you should feel right at home with PHP. It's a cross-platform scripting language, usually used to drive dynamic content websites, like... well, like SMW Central! Message boards and dynamic content management systems frequently use PHP. Other things have been done with it as well, like image galleries, shoutboxes, even IRC bots!

In this thread, we shall be talking about PHP coding, and out PHP projects. Share code if possible! Give help to other PHP coders, and maybe one day they will, in turn, help you as well.

SQL stands for "Structured Query Language". It's a database language designed to be simple, yet powerful.

If you make something in PHP, chances are you will also be using it with a SQL database to store and retrieve data. That's why SQL will also be covered in this thread. Be sure to let us know which DBMS you are using (usually, it's MySQL), and we can help fix your queries.

HoleNet.info

I'm taking visual Basics, but the rest of my class is slowing me down D:
I want to program stuff for my own advantage.
I wonder what a HFD opcode would do in ASM...
I have a question that will help me with my ultimate plan. When you make a table with MySQL, does it permanently stay, or is it erased when the PHP is done with its code?
Your layout has been removed.
Originally posted by TLMB
I'm taking visual Basics, but the rest of my class is slowing me down D:
I want to program stuff for my own advantage.

This isn't the Visual Basic thread!

Originally posted by pieguy1372
I have a question that will help me with my ultimate plan. When you make a table with MySQL, does it permanently stay, or is it erased when the PHP is done with its code?


The tables, and with them the contents of tables in SQL databases are persistent. That means once you create the table, that table stays in the database until you delete it, but you usually don't make tables and then destroy them afterwards. That's stupid. You make tables with an install script or from a SQL manager, and then when you're done, you remove the tables from a SQL manager.

If you had checked the link in the first post, you wouldn't be asking this.

HoleNet.info

Oops, I didn't know there was a link there, I thought it was just different colored text. D: *slaps self repeatedly*

Anyway, thanks.
Your layout has been removed.
Originally posted by Techokami
If you had checked the link in the first post, you wouldn't be asking this.

Hey, where in that link in your first post was his question specifically answered? I'm looking and all I see is a general SQL wiki article. What's the point of this topic if you expect everyone to answer their own questions?
Yes, it's really JJ.
Originally posted by Juggling Joker
Originally posted by Techokami
If you had checked the link in the first post, you wouldn't be asking this.

Hey, where in that link in your first post was his question specifically answered? I'm looking and all I see is a general SQL wiki article. What's the point of this topic if you expect everyone to answer their own questions?

Hmm, okay so it doesn't explain it that well.
Well, the point of a database is to hold and retain data. It's not a temporary data storage, and in reality, it should never be used as such (it'll be slow and impractical). When you use a database, it's because you want to keep and retain your data, like user profiles.

So to summarize, a database isn't temporary. It stays after the code is finished.

HoleNet.info

If your looking for a free host, x10hosting has php and mySQL, plus no ads (unless you want more databases/email accounts, ect)
Originally posted by Funkymunk
If your looking for a free host, x10hosting has php and mySQL, plus no ads (unless you want more databases/email accounts, ect)

Maybe so, but, you have to visit the forums every so often or else your account gets suspended. I suggest freehostia. :/
Sweet. Ill check it out, x10 keeps crashing. Couldnt find another that even HAD mySQL.
Originally posted by freakishblob
Originally posted by Funkymunk
If your looking for a free host, x10hosting has php and mySQL, plus no ads (unless you want more databases/email accounts, ect)

Maybe so, but, you have to visit the forums every so often or else your account gets suspended. I suggest freehostia. :/

You have to pay for that. D:
Your layout has been removed.
Originally posted by pieguy1372
Originally posted by freakishblob
Originally posted by Funkymunk
If your looking for a free host, x10hosting has php and mySQL, plus no ads (unless you want more databases/email accounts, ect)

Maybe so, but, you have to visit the forums every so often or else your account gets suspended. I suggest freehostia. :/

You have to pay for that. D:


I don't think so...
You can better pick choose WebReus.
It has low prices, the best service you ever will get, really trustable, PLESK, latest version of MySQL, phpMyAdmin and PHP installed, Payment per year.
I can know all of this.
I pay every 1 November €19,49, every year.
If you want support, you get a email back within a few hours.
But that's only for Dutch people. ;)
I got from them a site, to see it, check my sig.
David B.'s site: http://www.nintenlord.com
Join our forums: http://www.nintenlord.com/forum
Hacks in process:
Super Mario 64 DS: Other ways to mix Test Map with another map and enemy swapping.
Mario Kart DS: Making own textures.

And for fuck sake, I am not gay.
Moderators/Administrators make fun of me.
I need to know what function works for redirecting the page.
What do you think about DNS?
David B.'s site: http://www.nintenlord.com
Join our forums: http://www.nintenlord.com/forum
Hacks in process:
Super Mario 64 DS: Other ways to mix Test Map with another map and enemy swapping.
Mario Kart DS: Making own textures.

And for fuck sake, I am not gay.
Moderators/Administrators make fun of me.
Originally posted by Kaeru
I need to know what function works for redirecting the page.

Clicky!
All the needed info should be there. :D
Thanks!
Also, how could I make so it lists all the files on "x" folder?
<?php
$folder=dir(".");

while($folderEntry=$folder->read()){
echo $folderEntry."
";
}

$folder->close();

?>

Hopefully you get the idea ;)