 |
|
 |
|
| It's the PHP and SQL thread! =D |
|
Forum Index - Hobbies - Computers & Technology - It's the PHP and SQL thread! =D |
|
Pages:  1  |
|
|
|
| Posted on 2007-12-29 05:34:55 PM |
Link | Quote |
|
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.
|
| Last edited on 2007-12-29 05:39:17 PM by Techokami. |
|
| Posted on 2007-12-29 05:50:52 PM |
Link | Quote |
|
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.
|
|
| Posted on 2007-12-29 09:34:46 PM |
Link | Quote |
|
|
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?
|
|
| Posted on 2007-12-29 10:28:50 PM |
Link | Quote |
|
Originally posted by TLMBI'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 pieguy1372I 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.
|
|
| Posted on 2007-12-29 11:04:01 PM |
Link | Quote |
|
Oops, I didn't know there was a link there, I thought it was just different colored text. D: *slaps self repeatedly*
Anyway, thanks.
|
|
| Posted on 2007-12-30 12:52:45 AM |
Link | Quote |
|
Originally posted by TechokamiIf 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?
|
|
| Posted on 2007-12-30 10:05:55 AM |
Link | Quote |
|
Originally posted by Juggling JokerOriginally posted by TechokamiIf 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.
|
|
| Posted on 2008-02-14 03:04:57 PM |
Link | Quote |
|
|
If your looking for a free host, x10hosting has php and mySQL, plus no ads (unless you want more databases/email accounts, ect)
|
|
| Posted on 2008-02-15 06:23:37 AM |
Link | Quote |
|
Originally posted by FunkymunkIf 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. :/
|
|
| Posted on 2008-02-15 07:52:22 AM |
Link | Quote |
|
|
Sweet. Ill check it out, x10 keeps crashing. Couldnt find another that even HAD mySQL.
|
|
| Posted on 2008-02-15 07:30:48 PM |
Link | Quote |
|
Originally posted by freakishblobOriginally posted by FunkymunkIf 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:
|
|
| Posted on 2008-02-19 08:15:09 PM |
Link | Quote |
|
Originally posted by pieguy1372Originally posted by freakishblobOriginally posted by FunkymunkIf 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...
|
|
| Posted on 2008-02-20 06:42:36 AM |
Link | Quote |
|
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.
|
|
| Posted on 2008-02-24 08:28:05 PM |
Link | Quote |
|
|
I need to know what function works for redirecting the page.
|
|
| Posted on 2008-02-25 02:54:46 AM |
Link | Quote |
|
|
What do you think about DNS?
|
|
| Posted on 2008-02-25 10:54:10 AM |
Link | Quote |
|
Originally posted by KaeruI need to know what function works for redirecting the page.
Clicky!
All the needed info should be there. 
|
|
| Posted on 2008-02-25 04:05:51 PM |
Link | Quote |
|
Thanks!
Also, how could I make so it lists all the files on "x" folder?
|
|
| Posted on 2008-02-26 01:34:33 PM |
Link | Quote |
|
<?php
$folder=dir(".");
while($folderEntry=$folder->read()){
echo $folderEntry."
";
}
$folder->close();
?>
Hopefully you get the idea ;)
|
| Last edited on 2008-02-26 03:31:09 PM by Mystia Lorelei. |
|
|
| Pages: 1 |
|
|
|
|
Forum Index - Hobbies - Computers & Technology - It's the PHP and SQL thread! =D |
|
|
 |
|
 |
The purpose of this site is not to distribute copyrighted material, but to honor one of our favourite games.
Copyright © 2005 - 2013 - SMW Central
Legal Information - Link To UsTotal queries: 27
|
|
|
|
