Проблем с една система

  • Автор Автор html
  • Начална дата Начална дата
H

html

Registered
Здравей те!Така един приятел ми даде една система за добавяне на файлове ама иска се таблица mp3z,която не мога да направя ако някой може да ми помогне ще съм му благодарен.

baza danni c.php
Код: 
<?php
$server = "localhost";
$mysql_user = "root";
$mysql_pass = "";
$mysql_db = "tuka slojih bazata danni";

$connect = mysql_connect("$server", "$mysql_user", "$mysql_pass");
if(!$connect){
die(mysql_error());
}
$select_db = mysql_select_db("$mysql_db");
if(!$select_db){
die(mysql_error());
}
?>

index.php

Код: 
<?php
include "c.php";
?>
<?php
  $sql = mysql_query("SELECT * FROM mp3z ORDER BY `id` DESC LIMIT 20");
while($arr = mysql_fetch_assoc($sql))
  {
 
 
  $name = $arr["name"];
  $link = $arr["link"];
  $size = $arr["size"];
  $year = $arr["year"];
 
  ?>
  <tr>
    <td align="left" bgcolor="#4E4E4E" class="table_link"><a href="<?=$link?>" class="menu_link"><?=$name?></a></td>
    <td align="left" bgcolor="#4E4E4E"><?=$size?></td>
    <td align="left" bgcolor="#4E4E4E"><?=$year?></td>
  </tr>
  <p>
    <?php
  }
  ?>
</p>
  <p><tr>
    <td height="29" align="center" background="menu_header.jpg"><div align="right"><a href="archive.php?letter=a" class="footer_link">A</a> . <span class="style19"><a href="archive.php?letter=b" class="footer_link">B</a></span> . <a href="archive.php?letter=c" class="footer_link">C</a> . <a href="archive.php?letter=d" class="footer_link">D</a> .<a href="archive.php?letter=e" class="footer_link"> E</a> .<a href="archive.php?letter=f" class="footer_link"> F</a> .<a href="archive.php?letter=g" class="footer_link"> G</a> .<a href="archive.php?letter=h" class="footer_link"> H</a> .<a href="archive.php?letter=i" class="footer_link"> I</a> . <a href="archive.php?letter=j" class="footer_link">J</a> . <a href="archive.php?letter=k" class="footer_link">K</a> . <a href="archive.php?letter=l" class="footer_link">L</a> . <a href="archive.php?letter=m" class="footer_link">M</a> .<a href="archive.php?letter=n" class="footer_link"> N</a> . <a href="archive.php?letter=o" class="footer_link">O</a> . <a href="archive.php?letter=p" class="footer_link">P</a> . <span class="style19"><a href="archive.php?letter=r" class="footer_link">R</a></span> . <a href="archive.php?letter=s" class="footer_link">S</a> . <a href="archive.php?letter=t" class="footer_link">T</a> . <a href="archive.php?letter=v" class="footer_link">V</a> . <a href="archive.php?letter=w" class="footer_link">W</a> . <a href="archive.php?letter=x" class="footer_link">X</a> . <a href="archive.php?letter=y" class="footer_link">Y</a> . <a href="archive.php?letter=z" class="footer_link">Z      </a></div></td>
  </tr></p>

archive.php

Код: 
<table width="799" border="0" align="center">
  <tr>
    <td width="632"><span class="style15 style17">Name</span></td>

    <td width="60"><span class="style15">Size</span></td>
    <td width="60"><span class="style15">Year</span></td>
  </tr>
 
  <?php
 $sql = mysql_query("SELECT * FROM mp3z WHERE name LIKE '".$_GET["letter"]."%' order by name asc") or die(mysql_error);
while($arr = mysql_fetch_assoc($sql))
  {
 
 
  $name = $arr["name"];
  $link = $arr["link"];
  $size = $arr["size"];
  $year = $arr["year"];
 
  ?>
  <tr>
    <td align="left" class="table_link"><a href="<?=$link?>" class="menu_link"><?=$name?></a></td>
    <td align="left"><?=$size?></td>
    <td align="left"><?=$year?></td>
  </tr>
  <?php
  }
  ?>
</table>

add.php

Код: 
<?
include "c.php";
$name = $_POST['name'];
$link = $_POST['link'];
$size = $_POST['size'];
$year = $_POST['year'];
if($_POST["ddd"] == '1')
{
mysql_query("INSERT INTO mp3z (name,link,size,year) values ('$name','$link','$size','$year') ");



}
?>
<table width="800" border="0" align="center">

<form method="post" action="add.php">
<input type="hidden" name="ddd" value="1">
<tr>
<td>????????</td><td><input type="text" size="40" name="name"></td>
</tr>

<tr>
<td>????</td><td><input type="text" size="40" name="link"></td>
</tr>
<tr>
<td>??????</td><td><input type="text" size="5" name="size"></td>
</tr>

<tr>
<td>??????</td><td><select name="year">
  <option value="2000">2000</option>
  <option value="2001">2001</option>
  <option value="2002">2002</option>
  <option value="2003">2003</option>
  <option value="2004">2004</option>
  <option value="2005">2005</option>
  <option value="2006">2006</option><option value="2007">2007</option>
  <option value="N/A">N/A</option>
</select></td>
</tr>

<tr>
<td><input type="submit" value="????!"></td>
</tr>
</form>


</table>
[/code]
 
Значи кажи все пак какви полета ти трябват базата ти mp3z, полетета са "name, year,size, link" други има ли?
 
Все пак ако ти трябжа база ето :) НЕ гарантирам но може да пробваш подобна структура

CREATE database mp3z



CREATE TABLE `mp3z` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`link` varchar(255) NOT NULL default '',
`size` varchar(255) NOT NULL,
`year` varchar(255) NOT NULL,

PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `link` (`link`),
)
 
Дава ми грешка ето:

Код: 
Грешка

SQL заявка:

CREATE TABLE `mp3z` (
`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) NOT NULL ,
`link` varchar( 255 ) NOT NULL default '',
`size` varchar( 255 ) NOT NULL ,
`year` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` ) ,
UNIQUE KEY `link` ( `link` ) ,
)

MySQL отговори: Документация
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 11
 
CREATE TABLE `mp3z` (
`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) NOT NULL ,
`link` varchar( 255 ) NOT NULL default '',
`size` varchar( 255 ) NOT NULL ,
`year` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` ) ,
UNIQUE KEY `link` ( `link` )
) ;
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе