|
|
 |
|
|
Thread Tools | Display Modes |
Jun 7th, 2005, 9:11 PM
|
#11 |
|
Newbie
Join Date: May 2005
Posts: 6
Rep Power: 0
 |
Making some good headway. First, set up XAMPP to run on my machine. Bought the book you recommended and reading through - really great examples and clear language thats on my level (going through the PHP introduction).
Starting with the MySQL stuff, though, and using XAMPP I have no clue how to access my database outside of PHP - to setup/add initial data. Any simple tips (ie, "run this program," or "access it through this application doing___") to get me started would be much appreciated. Thanks in advance. =D |
|
|
|
Jun 8th, 2005, 2:46 AM
|
#12 |
|
Programming Guru
 Join Date: Aug 2004
Posts: 1,022
Rep Power: 5
  |
if you are using Mysql have a hunt on google for a gui or there must be a command line interface to it.
__________________
"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." - Albert Einstein |
|
|
|
|
Jun 8th, 2005, 6:09 AM
|
#13 |
|
I eat cake for breakfast.
Join Date: Jul 2004
Location: In my box.
Posts: 4,434
Rep Power: 9
|
If you're using MySQL, set up phpMyAdmin on your home server - it's an excellent GUI for MySQL databases.
|
|
|
|
|
Jun 9th, 2005, 9:49 AM
|
#14 |
|
Newbie
Join Date: Jun 2005
Posts: 3
Rep Power: 0
|
Connecting to a MySQL database is very easy with PHP since it has specific functions to work with in MySQL databases:
Just an example: <?php
$connect = mysql_connect ("localhost","root","password");
if (! $connect) {
echo ("Sorry, no connection possible!");
}
?>This is the code-snippet which allows you to connecto to your database. Of course, you'll have to surrogate "root" and "password" with the right values (e.g. the ones you put in when you set up your xampp). Need more help? |
|
|
|
|
Jun 9th, 2005, 9:51 AM
|
#15 | |
|
Newbie
Join Date: Jun 2005
Posts: 3
Rep Power: 0
|
Quote:
|
|
|
|
|
|
Jun 10th, 2005, 2:48 AM
|
#16 | |
|
Programming Guru
Join Date: Aug 2004
Posts: 1,022
Rep Power: 5
|
Quote:
__________________
"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." - Albert Einstein |
|
|
|
|
|
Jun 10th, 2005, 9:14 AM
|
#17 | |
|
Programming Guru
Join Date: May 2004
Location: Brandon, Manitoba, Canada
Posts: 2,023
Rep Power: 7
 |
Quote:
__________________
Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007! |
|
|
|
|
|
Jun 10th, 2005, 1:30 PM
|
#18 |
|
I eat cake for breakfast.
Join Date: Jul 2004
Location: In my box.
Posts: 4,434
Rep Power: 9
|
I use phpMyAdmin and the SQL statement insertion option, most of the time.
 |
|
|
|
|
Jun 13th, 2005, 3:48 AM
|
#19 |
|
Programming Guru
Join Date: Aug 2004
Posts: 1,022
Rep Power: 5
|
I also use the shell more often then anything else due to well code on my web pages or though my java to the AS400 at work is all sql so it helps me to test my sql is working correctly.
__________________
"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity." - Albert Einstein |
|
|
|
|
Jun 15th, 2005, 9:40 PM
|
#20 |
|
Newbie
Join Date: May 2005
Posts: 6
Rep Power: 0
|
I'm on the right track again, working beautifully.
Thanks! |
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
