PHP Twelve - PHP and MySQL

Language: PHP
$query = mysql_query("
UPDATE playerpoints SET 
tries=';$tries';,
pens=';$pen';,
convs=';$conv';,
drops=';$drops';				 
WHERE
fid=';$fid'; 
AND 
id=';$playerid';
");

Language: PHP
$insert = "INSERT INTO movie (movie_id, movie_name, movie_type, " .
		  "movie_year, movie_leadactor, movie_director)" .
		  "VALUES (1, ';Bruce Almighty';, 5, 2003, 1, 2), " .
		  "(2, ';Office Space';, 5, 1999, 5, 6), " .
		  "(3, ';Grand Canyon';, 2, 1991, 4, 3), ";

Language: SQL
$insert = "
INSERT INTO movie 
(movie_id, movie_name, movie_type, movie_year, movie_leadactor, movie_director)
VALUES 
(1, ';Bruce Almighty';, 5, 2003, 1, 2), 
(2, ';Office Space';, 5, 1999, 5, 6), 
(3, ';Grand Canyon';, 2, 1991, 4, 3)
";
 
 
//OR WHEN submitted BY a form, FOR example
 
$insert = "
INSERT INTO movie 
VALUES 
';';,
';$name';, 
$type';,
';$year';,
';$actor';,
';$director';
";
//IF you USE ALL the FIELDS, you do NOT have TO specify the COLUMN names. I USE '; '; FOR the movie_id, which IS an auto INCREMENT

Language: PHP
}
   }

Language: PHP
...{
    //code
           ...{
               //code
              }
  {

Language: PHP
$SQL = "INSERT INTO tb_address_book (id,First_Name, Surname, Address) VALUES (';$_POST[';id';]';,';$_POST';[First_name';]';,';$_POST[';Surname';]'; ,';$_POST[';Address';]';);

Language: PHP
> $SQL = "INSERT INTO tb_address_book
> (id,First_Name, Surname, Address) VALUES
> (';$_POST[';id';]';,';$_POST';[First_name';]';,';$_POST[';Su
> rname';]'; ,';$_POST[';Address';]';);
>

Language: PHP
';$_POST';[First_name';]';,

Language: PHP
<?php
//assuming your form fields are named as follows: First_name, Surname, Address
 
$first_name = $_POST[';First_name';];
$surname= $_POST[';Surname';];
$address = $_POST[';Address';];
 
// escape special charecters in a string
$first_name = mysql_real_escape_string($_POST[';First_name';]);
$surname= mysql_real_escape_string($_POST[';Surname';]);
$address = mysql_real_escape_string($_POST[';Address';]);
 
//testing to see what values will be sent to a database
echo "First Name: ".$first_name."<br>";
echo"Surname: ".$surname."<br>";
echo"Address: ".$address;
 
 
$SQL = "INSERT INTO tb_address_book (First_Name, Surname, Address)
		VALUES (';$first_name';,';$surname';,';$address';)";
 
// please note i did not insert ID - assume your id column is on auto_increament.
?>

Language: PHP
$SQL = "INSERT INTO tb_address_book (id, First_Name, Surname, Address) VALUES (';$_POST[id]';, ';$_POST[First_name]';, ';$_POST[Surname]';, ';$_POST[Address]';)";

Language: PHP
<?php
//connect to MySQL; note we';ve used our own parameters- you should use
//your own for hostname, user, and password
$connect = mysql_connect("localhost", "bp5am", "bp5ampass") 
or die ("Hey loser, check your server connection.");
 
//create the main database if it doesn';t already exist
$create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite")
     or die (mysql_error());
 
//make sure our recently created database is the active one
mysql_select_db("moviesite");
 
//create "movie" table
$movie = "CREATE TABLE movie (
  movie_id int(11) NOT NULL auto_increment,
  movie_name varchar(255) NOT NULL,
  movie_type tinyint(2) NOT NULL default 0,
  movie_year int(4) NOT NULL default 0,
  movie_leadactor int(11) NOT NULL default 0,
  movie_director int(11) NOT NULL default 0,
  PRIMARY KEY (movie_id),
  KEY movie_type (movie_type,movie_year)
  )";
 
$results = mysql_query($movie)
   or die (mysql_error());
 
//create "movietype" table
$movietype = "CREATE TABLE movietype (
  movietype_id int(11) NOT NULL auto_increment,
  movietype_label varchar(100) NOT NULL,
  PRIMARY KEY (movietype_id)
)";
 
$results = mysql_query($movietype)
  or die (mysql_error());
 
//create "people" table
$people = "CREATE TABLE people (
 people_id int(11) NOT NULL auto_increment,
 people_fullname varchar(255) NOT NULL,
 people_isactor tinyint(1) NOT NULL default 0,
 people_isdirector tinyint(1) NOT NULL default 0,
 PRIMARY KEY (people_id)
)";
 
$results = mysql_query($people)
   or die (mysql_error());
 
 echo "Movie Database successfully created!";
 
 ?>

hhtp://localhost/XAMPP