скоро си купих книга за web дизайн и програмиране с php5,mysql,apache и сега съм стигнал до база данни и проблема ми е следния. ако се опитам да се каннектна към phpmyadmin през url нямам проблем и се свързван, но понеже сега уча как да си пиша кодовете сам и да се каннектвам през тях и имам някакъв проблем с канекта. при опит ми излиза
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'bp5am'@'localhost' (using password: YES) in D:\xampp\htdocs\createmovie.php on line 3
Hey loser, check your server connection
ето вижте и скриптовете:
това е първия
<?php
//moqt host,user i pass
$connect = mysql_connect("localhost","bp5am","bp5ampass")or
die ("Hey loser, check your server connection.");
//syzdavane na moqta baza danni
$create=mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") or
die (mysql_error());
mysql_select_db("moviesite");
//syzdavane na movie tablica
$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());
//syzdavane na movietype tablica
$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());
//syzdavane ne people tablica
$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 seccussfully created!";
?>
това втория:
<?php
//connect to MySql
$connect=mqsql_connect("localhost","bp5am","bp5ampass")
or die ("Hey loser,check your server connection!");
mysql_select_db("moviesite");
//insert data into "movie" table
$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 Kanyon', 2, 1991, 4, 3)";
$results=mysql_query($insert) or
die (mysql_error());
//insert data into "movietype" table
$type="INSERT INTO movietype (movietype_id, movietype_label) ".
"VALUES (1, 'Sci Fi'),".
"(2, 'Drama'),".
"(3, 'Adventure'),".
"(4, 'War'),".
"(5, 'Comedy'),".
"(6, 'Horror'),".
"(7, 'Action'),".
"(8, 'Kids')";
$results=mysql_query($type) or
die (mysql_error());
//insert data into "people" table
$people="INSERT INTO people (people_id, people_fullname, ".
"people_isactor, people_isdirector),".
"VALUES (1, 'Jim Carrey', 1, 0),".
"(2, 'Tom Shadyac', 0, 1),".
"(3, 'Lawrence Kasdan', 0, 1),".
"(4, 'Kevin Kline', 1, 0),".
"(5, 'Ron Livingston', 1, 0),".
"(6, 'Mike Judge', 0, 1)";
$results=mysql_query($people) or
die (mysql_error());
echo "Data inserted seccessfully!"
?>
дано можете да ми помогнете
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'bp5am'@'localhost' (using password: YES) in D:\xampp\htdocs\createmovie.php on line 3
Hey loser, check your server connection
ето вижте и скриптовете:
това е първия
<?php
//moqt host,user i pass
$connect = mysql_connect("localhost","bp5am","bp5ampass")or
die ("Hey loser, check your server connection.");
//syzdavane na moqta baza danni
$create=mysql_query("CREATE DATABASE IF NOT EXISTS moviesite") or
die (mysql_error());
mysql_select_db("moviesite");
//syzdavane na movie tablica
$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());
//syzdavane na movietype tablica
$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());
//syzdavane ne people tablica
$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 seccussfully created!";
?>
това втория:
<?php
//connect to MySql
$connect=mqsql_connect("localhost","bp5am","bp5ampass")
or die ("Hey loser,check your server connection!");
mysql_select_db("moviesite");
//insert data into "movie" table
$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 Kanyon', 2, 1991, 4, 3)";
$results=mysql_query($insert) or
die (mysql_error());
//insert data into "movietype" table
$type="INSERT INTO movietype (movietype_id, movietype_label) ".
"VALUES (1, 'Sci Fi'),".
"(2, 'Drama'),".
"(3, 'Adventure'),".
"(4, 'War'),".
"(5, 'Comedy'),".
"(6, 'Horror'),".
"(7, 'Action'),".
"(8, 'Kids')";
$results=mysql_query($type) or
die (mysql_error());
//insert data into "people" table
$people="INSERT INTO people (people_id, people_fullname, ".
"people_isactor, people_isdirector),".
"VALUES (1, 'Jim Carrey', 1, 0),".
"(2, 'Tom Shadyac', 0, 1),".
"(3, 'Lawrence Kasdan', 0, 1),".
"(4, 'Kevin Kline', 1, 0),".
"(5, 'Ron Livingston', 1, 0),".
"(6, 'Mike Judge', 0, 1)";
$results=mysql_query($people) or
die (mysql_error());
echo "Data inserted seccessfully!"
?>
дано можете да ми помогнете
показва ми database но като му дам show tables ; и ми излиза грешка. аз искам да изтрия всички които се записват по подразбиране и да си вкарам мой user i pass. usera по подразбиране гледам че е root, може ли да се сменя с какъвто искам аз и как? 