DB Example


         echo "  edit  ";


su -

cd /var/www/html
mkdir pokus
chown  jmeno  pokus
ll

yum install httpd  mysql  mysql-server php php-mysqlnd phpMyAdmin

apachectl start 
systemctl start mariadb.service


cp ~/Downloads/db-example.txt /var/www/html/pokus/db-example.php

mysql -u root
   create database mydb;
   use mydb;
  
   create table colors (name varchar(80), red int, green int, blue int);
   insert into colors values ("blue", 0, 0, 255);
   select * from colors;
   describe colors;

   CREATE USER 'uzivatel'@'localhost' IDENTIFIED BY 'heslo';
   GRANT ALL ON mydb.* TO 'uzivatel'@'localhost';

podivat se na http://localhost/pokus soubor /var/www/html/pokus/priklad.php






         DB Example 

        





', "\n";
    echo "Error: $msg \n";
    echo '', "\n";
    exit;
}

function note ($msg)
{
    echo '', "\n";
    echo "Note: $msg \n";
    echo '', "\n";
}


/* quote string */

function sql_str ($value)
{
    return "'" . MySQL_Escape_String ($value) . "'";
}

function html_str ($value)
{
    return htmlspecialchars ($value);
}

/* parameters and session variables */

function param ($param_name)
{
    if (isset ($_POST[$param_name]))
    {
       $value = $_POST[$param_name];
    }
    else if (isset ($_GET[$param_name]))
    {
       $value = $_GET[$param_name];
    }
    else
    {
       $value = "";
    }

    // echo "$param_name: ", $value, '
', "\n";

    return trim ($value);
}

/* database parameters */

$db_host = "localhost";
$db_user = "uzivatel";
$db_password = "heslo";
$database = "mydb";

/* database connection */

$connection = MySQL_Connect ($db_host, $db_user, $db_password) or Err (MySQL_Error());
MySQL_Select_Db($database) or Err (MySQL_Error());

/* actions */

?>
 list 
 
 abc 


"; 
      while ($data = MySQL_Fetch_Array ($results))
      {
         echo " "; 
           for ($k = 0; $k < 4; $k++)
           {
              $value = $data [$k];
              echo " $value  ";
           }
         echo " "; 
         echo "  edit  ";
      }
      echo " "; 

}

if ($fce == "edit")
{
   echo "Edit";
}

?>