Sql
I have recently started to want to learn more about more advanced programming. I have realized that sql is a general standard that is used with accessing database's.
With the tutorials at w3schools.com i have gotten a good concept of SQL but still don't understand a few things.
Do i have to use SQL with another scripting language such as PHP, ASP or PERL?? or is there a way of just using SQL? My next task is to learn PHP so am I going on the right path?
Any help is Appreciated!
Web Design ~ What a job!
zollet posted this at 17:18 — 2nd January 2003.
He has: 1,016 posts
Joined: May 2002
It depends on your needs. If you have a website and you want to get/save info from/to a database then you'll need to use a server-side language (PHP, Perl/CGI, ASP, etc). However, you could for example log into your Linux server via Telnet/SSH and there connect to the MySQL server and type SQL commands.
And yes, IMHO PHP is a very good choice.
Here are some related PHP MySQL functions...
- http://www.php.net/mysql_connect
- http://www.php.net/mysql_select_db
- http://www.php.net/mysql_quert
- http://www.php.net/mysql_close
nike_guy_man posted this at 21:08 — 2nd January 2003.
They have: 840 posts
Joined: Sep 2000
You could use PHP with MySQL
It all depends on what type of SQL you are using
MySQL and PHP are free and easy to use
One correction from Zollet:
http://www.php.net/mysql_quert should be http://www.php.net/mysql_query
PHP is very well documented at php.net and if you can't find it there, find it here!
dk01 posted this at 00:22 — 3rd January 2003.
He has: 516 posts
Joined: Mar 2002
An excellent tutorial if you haven't got a clue:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
-dk
ROB posted this at 10:52 — 3rd January 2003.
They have: 447 posts
Joined: Oct 1999
to answer your question, you *can* use SQL alone but only to issue commands directly to your database, or some enterprise databases support a advanced SQL scripting language, but when it comes to the web, no you cant just use SQL. SQL is just a means to get data from a database, you need something to request, recieve, process and display that data. PHP should be your next stop.
DaWebMan18 posted this at 18:11 — 3rd January 2003.
They have: 9 posts
Joined: Dec 2002
ok, thanks everyone, so my next question is gonna be, where can i start with php tutorials. besides php.net, i got that from the previous posts!
zollet posted this at 20:42 — 3rd January 2003.
He has: 1,016 posts
Joined: May 2002
http://www.phpbuilder.com/ has some good tutorials (a.k.a. articles).
FinalMjolnir666 posted this at 22:44 — 3rd January 2003.
They have: 45 posts
Joined: Feb 2002
http://www.mysql.com has a great MySQL/PHP 'Build Your Own Database Driven Database' thing in their documentation section. That's how I mainly learned how to used MySQL.
[ FinalCreations ]
saupz posted this at 14:52 — 13th January 2003.
They have: 3 posts
Joined: Jan 2003
mysql is a really great application. eventhough it small application compare with orecle but it still compatable to most end-user to use it. and it simple to apply
http://www.mercumaya.com
webhosting + domain = $30
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.