SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    Senior Webdesigner koolbrian's Avatar
    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

  2. #2
    SitePoint Wizard
    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!

  3. #3
    SitePoint Wizard johnn's Avatar
    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
    Any tutorial or articles on this subject?
    Thanks,
    John

  4. #4
    SitePoint Wizard
    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.

  5. #5
    SitePoint Columnist Skunk's Avatar
    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

  6. #6
    Senior Webdesigner koolbrian's Avatar
    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

  7. #7
    SitePoint Wizard
    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.

  8. #8
    Senior Webdesigner koolbrian's Avatar
    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 especially
    PHP Code:
     while ( $row mysql_fetch_array($result) ) { 
    echo(
    "<P>" $row["JokeText"] . "</P>"); 


    !

    Brian


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •