SSL shell / Telnet, apache handlers,.. HUH ?????

[koolbrian]

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

[qslack]

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!

[johnn]

You can access your webhost's mySQL through Telnet/SSH or through a scripting language like PHP or Perl

Any tutorial or articles on this subject?
Thanks,
John

[qslack]

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.

[Skunk]

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

[koolbrian]

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

[qslack]

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.

[koolbrian]

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 especially

 while ( $row = mysql_fetch_array($result) ) { 
echo("<P>" . $row["JokeText"] . "</P>"); 
} 

!

Brian