SitePoint Sponsor |
|
User Tag List
Results 1 to 8 of 8
-
May 13, 2001, 09:10 #1
- Join Date
- Dec 2000
- Location
- Mauritius
- Posts
- 599
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
could somebody please explain me what's ssl/telnet , apache handlers, cron Jobs and mime types ???,
all these are anonymous for me!, is it in relation with my web host. How can i access my webhost Mysql ?, to create databases etc.... ?
Brian
-
May 13, 2001, 10:12 #2
- Join Date
- Jul 1999
- Location
- Chicago
- Posts
- 2,629
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
SSL - A secure public key encryption method.
Telnet/SSH - A way of accessing a remote server and executing commands on it as if you were sitting right next to it
Apache handlers - Tells Apache what to do with files which match certain criteria
Cron jobs - Used to schedule a command to run, for example, daily or weekly.
You can access your webhost's mySQL through Telnet/SSH or through a scripting language like PHP or Perl. Your webhost should be able to tell you how to create databases--it varies among hosts.
Hope this helps!
-
May 13, 2001, 10:41 #3
- Join Date
- Mar 2001
- Location
- Southern California, USA
- Posts
- 1,181
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You can access your webhost's mySQL through Telnet/SSH or through a scripting language like PHP or Perl
Thanks,
John
-
May 13, 2001, 10:54 #4
- Join Date
- Jul 1999
- Location
- Chicago
- Posts
- 2,629
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Actually, probably a book would be best. For Perl, "Learning Perl" from O'Reilly publishing is excellent. Then you would just need to read the DBI (Perl's DB library) documentation.
For PHP, I recommend "Professional PHP". That's the book I used. Dunno if there are any more recent better books on PHP...maybe someone else could help with that.
-
May 13, 2001, 10:55 #5
- Join Date
- Jan 2001
- Location
- Lawrence, Kansas
- Posts
- 2,066
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
By far the best and easiest way to access your webhost's mySQL database, create tables etc is to install phpMyAdmin on their web server. To set it up all you have to do is modify the phpMyAdmin config.inc.php file to contain your mySQL database host, username and password (this information should have been given to you by your host).
That way you don't need to mess around with telnet / SSH at all - keeps things nice and simple.
www.phpwizards.net for phpMyAdmin
-
May 13, 2001, 11:01 #6
- Join Date
- Dec 2000
- Location
- Mauritius
- Posts
- 599
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
i've heard of a mysql client software?,
could somebody PLEASE explain this inunderstood statement please?
// Request the text of all the jokes
$result = mysql_query(
"SELECT JokeText FROM Jokes");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}
// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<P>" . $row["JokeText"] . "</P>");
}
especiall the last paragraph!,
s-h-i- t, that's complicated!
Brian
-
May 13, 2001, 11:11 #7
- Join Date
- Jul 1999
- Location
- Chicago
- Posts
- 2,629
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Koolbrian, you'll probably be best off if you learn PHP. But basically, that statement does this:
Get all of the jokes from the database, and if there was an error, tell the user. Then, display all of the jokes on one page.
-
May 14, 2001, 06:19 #8
- Join Date
- Dec 2000
- Location
- Mauritius
- Posts
- 599
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
hey i have learn PHP from "Building a database-driven site with Php and Mysql" . And i'm asking you all this question not because I don't have any knowledge in Php, but the code itself , what does it do?
i don't understand especiallyPHP Code:while ( $row = mysql_fetch_array($result) ) {
echo("<P>" . $row["JokeText"] . "</P>");
}
!
Brian
Bookmarks