scofield007
پنج شنبه 03 بهمن 1392, 17:43 عصر
سلام دوستان
خسته نباشید
تکه کد زیر در کدوم قسمت مشکل داره که هر بار موقع اجرا خطا میده
با تشکر
<?php
$db = mysql_connect('localhost','root','') or die ('Unable to connect');
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query,$db) or die (mysql_error($db));
//---------------------------------------------------
//etminan az ijad databsae
mysql_select_db('moviesite',$db) or die (mysql_error($db));
//sakht jadval
$query = 'CREATE TABLE movie
{
movie_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
movie_name VARCHAR(255) NOT NULL,
movie_type TINYINT NOT NULL DEFAULT 0,
movie_year SMALLINT UNSIGNED NOT NULL DEFAULT 0,
movie_leadactor INTEGER UNSIGNED NOT NULL DEFAULT 0,
movie_director INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (movie_id),
KEY movie_type (movie_type,movie_year)
}
ENGINE = MyISAM';
mysql_query($query , $db) or die (mysql_error($db));
//--------------------------------------------------------
$query = 'CREATE TABLE movietype
{
movietype_id TINYINT UNSIGND NOT NULL AUTO_INCREMENT,
movietype_lebel VARCHAR(100) NOT NULL,
PRIMARY KEY (movietype_id),
}
ENGINE = MyISAM';
mysql_query($query , $db) or die (mysql_error($db));
//------------------------------------------------------
$query = 'CREATE TABLE people
{
people_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
people_fullname VARCHAR(255) NOT NULL,
people_isactor TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (people_id),
}
ENGINE = MyISAM';
mysql_query($query , $db) or die (mysql_error($db));
//--------------------------------------------------------
echo "database ba movafaghiat sakhte shod";
?>
خسته نباشید
تکه کد زیر در کدوم قسمت مشکل داره که هر بار موقع اجرا خطا میده
با تشکر
<?php
$db = mysql_connect('localhost','root','') or die ('Unable to connect');
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query,$db) or die (mysql_error($db));
//---------------------------------------------------
//etminan az ijad databsae
mysql_select_db('moviesite',$db) or die (mysql_error($db));
//sakht jadval
$query = 'CREATE TABLE movie
{
movie_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
movie_name VARCHAR(255) NOT NULL,
movie_type TINYINT NOT NULL DEFAULT 0,
movie_year SMALLINT UNSIGNED NOT NULL DEFAULT 0,
movie_leadactor INTEGER UNSIGNED NOT NULL DEFAULT 0,
movie_director INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (movie_id),
KEY movie_type (movie_type,movie_year)
}
ENGINE = MyISAM';
mysql_query($query , $db) or die (mysql_error($db));
//--------------------------------------------------------
$query = 'CREATE TABLE movietype
{
movietype_id TINYINT UNSIGND NOT NULL AUTO_INCREMENT,
movietype_lebel VARCHAR(100) NOT NULL,
PRIMARY KEY (movietype_id),
}
ENGINE = MyISAM';
mysql_query($query , $db) or die (mysql_error($db));
//------------------------------------------------------
$query = 'CREATE TABLE people
{
people_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
people_fullname VARCHAR(255) NOT NULL,
people_isactor TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (people_id),
}
ENGINE = MyISAM';
mysql_query($query , $db) or die (mysql_error($db));
//--------------------------------------------------------
echo "database ba movafaghiat sakhte shod";
?>