[PHP] pobierz, plaintext 
<?php
	$link = mysql_connect("localhost", "root", "tatiana13")
		or die("Sprawdź połączenie z serwerem.");
	mysql_select_db("moviesite")
		or die(mysql_error());
 
	//modyfikacja tabeli "movie" w celu dodania pól czasu trwania, kosztu i zysków
	$add = "ALTER TABLE movie AND COLUMN ( " .
		"movie_running_time int NULL, " .
		"movie_cost int NULL, " .
		"movie_takings int NULL)";
	$results = mysql_query($add)
		or die(mysql_error());
 
	//wstawienie nowych danych do tabeli "movie" dla każdego filmu
	$update = "UPDATE movie SET " .
		"movie_running+time=102, " .
		"movie_cost=10, ".
		"movie_takings=15 ".
		"WHERE movie_id = 1";
	$results = mysql_query($update)
		or die(mysql_error());
 
	$update = "UPDATE movie SET " .
		"movie_running_time=90, " .
		"movie_cost=3, " .
		"movie_takings=90 ".
		"WHERE movie_id = 2";
	$results = mysql_query($update)
		or die(mysql_error());
 
	$update = "UPDATE movie SET " .
		"movie_running_time=134, " .
		"movie_cost=15, " .
		"movie_takings=10 " .
		"WHERE movie_id = 3";
	$results = mysql_query($update)
		or die(mysql_error());
?>
[PHP] pobierz, plaintext