#sql

1
2
3
4

SELECT *
FROM orders, customers
WHERE orders.customer_id = customers.customer_id
AND customers.first_name = 'John'

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

<?php

$con = mysql_connect("localhost", "username", "password");
mysql_select_db("my_database", $con);

$qry = "SELECT * FROM user WHERE id = '$id'";
$result = mysql_query($qry);

while ($row = mysql_fetch_array($result)) {
  $f = $row['field1'];
  $g = $row['field2'];
  $h = $row['field3'];
}

mysql_close($con);

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

$title=$_POST['title'];
$genre=$_POST['genre'];
$actor=$_POST['actor'];

mysqli_query($connect,"INSERT INTO movies(title,genre,actor)
				VALUES('$title','$genre','$actor')");
					
if(mysqli_affected_rows($connect) > 0){
	echo "<p>Movie Added</p>";
	echo "<a href='searchdisplay.php'>Search for movies!</a>";
} else {
	echo "Movie NOT Added<br />";
	echo mysqli_error ($connect);
}