Здравейте!
Имам проблем със странциране ето и системата.
config.php
index.php
news.php
sql.sql
И дава грешка.
Warning: include(config.php) [function.include]: failed to open stream: No such file or directory in /home/a6080885/public_html/site1/cat/news.php on line 2
Free Web Hosting
PHP Error Message
Warning: include() [function.include]: Failed opening 'config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/a6080885/public_html/site1/cat/news.php on line 2
Free Web Hosting
PHP Error Message
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a6080885'@'localhost' (using password: NO) in /home/a6080885/public_html/site1/cat/news.php on line 3
Free Web Hosting
Не може да свърже с базата данни
Имам проблем със странциране ето и системата.
config.php
Код:
<?php
$hostname = "mysql7.000webhost.com";
$dbuser = "0885_admin";
$dbpass = "pass";
$dbname = "a6080885_new";
?>
index.php
Код:
<?php
include("conf.php");
$connect = mysql_connect($host, $username, $password)
or die("Не може да свърже с базата данни");
mysql_select_db($database, $connect)
or die("Не може да селектира базата данни");
mysql_query("SET CHARACTER SET cp1251");
$result = mysql_query("SELECT id, name FROM categories")
or die("Не може да изпълни заявката");
while($row = mysql_fetch_array($result)) {
echo '<a href="news.php?category='.$row['id'].'">'.$row['name'].'</a><br />';
}
?>
news.php
Код:
<?php
include("conf.php");
$connect = mysql_connect($host, $username, $password)
or die("Не може да свърже с базата данни");
mysql_select_db($database, $connect)
or die("Не може да селектира базата данни");
mysql_query("SET CHARACTER SET cp1251");
$category = 1;
if(isset($_GET['category']) and is_numeric($_GET['category'])) {
$category = intval($_GET['category']);
}
$result = mysql_query("SELECT title FROM news WHERE catid = '".$category."'")
or die("Не може да изпълни заявката");
if(mysql_num_rows($result) > 0) {
while($row = mysql_fetch_array($result)) {
echo $row['title']."<br />";
}
} else {
echo "Няма резултати в тази категория.";
}
?>
sql.sql
Код:
CREATE TABLE IF NOT EXISTS `categories` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`name` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `categories` (`id`, `name`) VALUES
(1, 'ʠ⥣'),
(2, 'ʠ⥣'),
(3, 'ʠ⥣'),
(4, 'ʠ⥣'),
(5, 'ʠ⥣'),
(6, 'ʠ⥣'),
(7, 'ʠ⥣');
CREATE TABLE IF NOT EXISTS `news` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`catid` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`)
);
И дава грешка.
Warning: include(config.php) [function.include]: failed to open stream: No such file or directory in /home/a6080885/public_html/site1/cat/news.php on line 2
Free Web Hosting
PHP Error Message
Warning: include() [function.include]: Failed opening 'config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/a6080885/public_html/site1/cat/news.php on line 2
Free Web Hosting
PHP Error Message
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a6080885'@'localhost' (using password: NO) in /home/a6080885/public_html/site1/cat/news.php on line 3
Free Web Hosting
Не може да свърже с базата данни