quote:

---

Originally posted by Mr. Linux Guy -You will need to learn to program to effectively use MySQL

---

quote:

---

Originally posted by iggy4270
How does it respond to Python? Any Quirks?

---

code:

#!/usr/bin/python

import MySQLdb

# connect
db = MySQLdb.connect(host="najee", user="randy", passwd="beere.es.g00d", db="myppdb")


cursor = db.cursor()
cursor.execute("SELECT price FROM beer")
result = cursor.fetchall()

for record in result:
        print record[0] , "-->", record[1]

code:

#!/usr/local/bin/perl -w 
$/ = ".\n"; 
while (<> ) { 
      next if !s/\b([a-z]+)((\s|<[^>]+> )+)(\1\b)/\e[7m$1\e[m$2\e[7m$4\em/ig;      s/^([^\e]*\n)+//mg;; 
      s/^/$ARGV: /mg; 
      print; 
      } 

quote:

---

Originally posted by prezbedard
I am familiar with MySQL and heard of PHP which I am guessing is a server side scripting language.

I don't need any high detailed information
just a general idea.

My webhost account has MySQL and myPHPadmin. These are both accessed via the online control panel. I haven't done much beyond looking at it and seeing how it works. Creating the MySQL database seems straight forward I use the online tool to create tables with the number of fields I want. My question is do I use php to access and reference the data in the MySQL database. For instance I create a simple table and make a webpage with a form using PHP to Query the database? A simple example
would be nice.

I also have MySQL and Apache on my Linux box at home. How do I determine if I have PHP installed or not?

Thanks

---

code:

<?
  //Create db connection
 $conn = db_connect();
  if (!$conn)
  {
    return "The phone list is unavailable - please try later.\n";
    do_html_footer();
    exit;
  } else {

    $sql = "SELECT * FROM phone_list ORDER BY pos";
    $result = mysql_query($sql);
    while ($row = mysql_fetch_array($result)) {

        // Set color
        if($color == "cccccc")
        {
           $color = "dddddd";
        } else {
           $color = "cccccc";
        }

        $prefix = $row["prefix"];
        $lname = $row["lname"];
        $fname = $row["fname"];
        $title = $row["title"];
        $location = $row["location"];
        $room = $row["room"];
        $phone = $row["phone"];

        if((!$prefix)&&(!$lname)&&(!$fname)&&(!$location)&&(!$room)&&(!$phone))
        {
             // Print title lines
             print("<tr colspan=7>\n");
             print("<td bgcolor=#D3DCE3 colspan=7><font size=2 face=verdana><b>$title</b></font></td>\n");
             print("</tr>\n");
        } else {
             // Print phone entries
              print("<tr>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$fname $lname</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$title</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$location</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$room</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$phone</font></td>\n");
             print("</tr>\n");
        }
     }
}

?>

code:

<?

function db_connect()
{
   $result = mysql_pconnect("10.3.6.134", "webdude", "fj6.09;sl");
   if (!$result)
      return false;
   if (!mysql_select_db("webdb"))
      return false;

   return $result;
}

// Place entries into the log table
function logger($pkey,$message)
{
  // connect to db
  $conn = db_connect();
  if (!$conn)
    return 0;

  // Set ip number
  $ipnum = $REMOTE_ADDR;

  // check if username is unique
  $result = mysql_query("insert into log (pkey,ipnum,message)
            values ('$pkey','$ipnum','$message')");
  if (!$result)
     return 0;
}
?>

quote:

---

Originally posted by iggy4270
Thanks. I was steered toward python.org about a year and a half ago, and I really didn't start getting into it until about 6 months ago. I just picked up a copy of O'Reilly's Learning Python, and to be honest with you I am going to stick with it for a while. As someone who has had no programming experience I feel really comfortable with it. What impressed me the most was meeting an M.I.T. Phd who won't use anything else but Python. There's just so many languages out there that it can become very confusing for the newbie.

---

quote:

---

Originally posted by prezbedard
I am familiar with MySQL and heard of PHP which I am guessing is a server side scripting language.

I don't need any high detailed information
just a general idea.

My webhost account has MySQL and myPHPadmin. These are both accessed via the online control panel. I haven't done much beyond looking at it and seeing how it works. Creating the MySQL database seems straight forward I use the online tool to create tables with the number of fields I want. My question is do I use php to access and reference the data in the MySQL database. For instance I create a simple table and make a webpage with a form using PHP to Query the database? A simple example
would be nice.

I also have MySQL and Apache on my Linux box at home. How do I determine if I have PHP installed or not?

Thanks

---

quote:

---

Originally posted by Mr. Linux Guy
Try

$ rpm -qi php

or

$ which php

You use PHP to do any processing you need, generally to output a website based upon information in a database. For example, on my website, I have a phone list for the organisation. The page is dynamically generated using the following code:

code:

<?
  //Create db connection
 $conn = db_connect();
  if (!$conn)
  {
    return "The phone list is unavailable - please try later.\n";
    do_html_footer();
    exit;
  } else {

    $sql = "SELECT * FROM phone_list ORDER BY pos";
    $result = mysql_query($sql);
    while ($row = mysql_fetch_array($result)) {

        // Set color
        if($color == "cccccc")
        {
           $color = "dddddd";
        } else {
           $color = "cccccc";
        }

        $prefix = $row["prefix"];
        $lname = $row["lname"];
        $fname = $row["fname"];
        $title = $row["title"];
        $location = $row["location"];
        $room = $row["room"];
        $phone = $row["phone"];

        if((!$prefix)&&(!$lname)&&(!$fname)&&(!$location)&&(!$room)&&(!$phone))
        {
             // Print title lines
             print("<tr colspan=7>\n");
             print("<td bgcolor=#D3DCE3 colspan=7><font size=2 face=verdana><b>$title</b></font></td>\n");
             print("</tr>\n");
        } else {
             // Print phone entries
              print("<tr>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$fname $lname</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$title</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$location</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$room</font></td>\n");
             print("<td bgcolor=$color><font size=1 face=verdana>$phone</font></td>\n");
             print("</tr>\n");
        }
     }
}

?>

This allows the PHP to connect to the MySQL database, then fetch what information it needs, then sends it to the correct data elements in the PHP code, and then PHP formats the page up in borwser-ready HTML. If you'd view the source of the page, all you would see is the HTML output.

The PHP functions are stored in a sibling directory to the Apache root (called phpconf) and the operative one in the above code that gets called looks something like this:

code:

<?

function db_connect()
{
   $result = mysql_pconnect("10.3.6.134", "webdude", "fj6.09;sl");
   if (!$result)
      return false;
   if (!mysql_select_db("webdb"))
      return false;

   return $result;
}

// Place entries into the log table
function logger($pkey,$message)
{
  // connect to db
  $conn = db_connect();
  if (!$conn)
    return 0;

  // Set ip number
  $ipnum = $REMOTE_ADDR;

  // check if username is unique
  $result = mysql_query("insert into log (pkey,ipnum,message)
            values ('$pkey','$ipnum','$message')");
  if (!$result)
     return 0;
}
?>

All you'd have to do is change the connect particulars for when this function is called. Like the username, passwd, database being called, and IP address of the database server.

---

quote:

---

Originally posted by prezbedard
Thanks fo the info. I assume the I save both sets of code as .php files?

Seems to very interesting indeed. I'll give it a try when i get some free time.

At the moment I'm studying for Network+,
voluteering, job searching and I'm putting together a Intro to HTML course I will be teaching at SalemCyberSapce.

Thanks Again

---