I need a sort of simple content managment script...

So, I need a mySQL database with the following fields:

Field : example of use

ID : 1
Name : Orange Distster
Description : The best
Image : http://sponk......file.png
Location : http://sponk......file.zip

And I need to be able to display this in a tabel

And will display these in order, newest to olders, 5,4,3,2,1...


That sort of thing, you get me? if someone could do this for me, I would be that happiers person in the world...

Thank you,
Craig.

 

 

 

Reply

<?
$query = mysql_query("SELECT * FROM table ORDER BY id DESC");
?>
<table border="1" cellpadding="0" cellspacing="0">
<?
while($var = mysql_fetch_array($query)){
?>
<tr>
<td align="center" valign="top">
<img src="<?=$var[image]?>">
</td>
<td width="397" align="left" valign="top">
<font size="2" face="Arial"><strong><?=$var[name]?></strong><br>
<?=$var[description]?><br>
<a href="<?=$var[location]?>">DOWNLOAD</a></font>
</td>
</tr>
<?
}
?>
</table>


Try to do it, if its not in the order u want, try to change "DESC" for "ASC".

 

 

 

Reply

ok, im kind of new to mySQL, how does it connect to the database? and what fields do I need to put in?


Also, how can I sho how many times it has been downloaded or how many times the link has been clicked?

Reply

Connecting to database:
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'password';
$dbname = 'name';

mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

You will have to add the fields name, image, description... just like we have used above.

Note: I have user vars to define the database info, but its not needed.

If you have any other question, post again and I'll try to help you :)

Reply

Ive put it all in and it works fine, other things i wish to know is,

How to dhow how many times the file had been downloaded or the dwnload link clicked... and hoe to display 10 per page...

Reply

OK, put this code on your page:

<?
$query = mysql_query("SELECT * FROM table ORDER BY id DESC");
?>
<table border="1" cellpadding="0" cellspacing="0">
<?
while($var = mysql_fetch_array($query)){
?>
<tr>
<td align="center" valign="top">
<img src="<?=$var[image]?>">
</td>
<td width="397" align="left" valign="top">
<font size="2" face="Arial"><strong><?=$var[name]?></strong><br>
<?=$var[description]?><br>
<a href="download.php?id=<?=$var[id]?>">DOWNLOAD</a></font>
</td>
</tr>
<?
}
?>
</table>

And now, lets do download.php:

<?
if(!$id)
return;

$query = mysql_query("SELECT * FROM table WHERE id=$id;");
$download = mysql_fetch_array($query);

if(!file_exists($download[location])){
print "Download file not found.";
exit;
}

mysql_query("UPDATE table SET clicks=(clicks+1) WHERE id=$id;");

header("Location: $download[location]");
?>

Don't forget to connect with database and add the column "id" to your database (with auto_increment). If it doesn't work, please post again and i'll look for the problem.

Reply

When I click the link to download it shows the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/cragllo/public_html/download.php on line 15
File not found.


Also Ive added two more fields:
Preview: for large image preview
creator: to show the author

Does that make a difference?

Also I need a page with a form to add new data...

Reply

Are you sure you have conected to the database on download.php?

Reply

My mistake, I fogot to change:

$query = mysql_query("SELECT * FROM templates WHERE id=$id;");


How can I make a form to ad records to the database?



You can see what im doing here: http://sponkindustries.co.uk/templatesfree2.php

Reply

let's make insert.php (or something else):

<?
if($go){ // if var $go is set
mysql_query("INSERT INTO table(name,description,image,location) VALUES ('$name','$desc','$image','$location') or die (mysql_error());
print "Done!";
exit;
} else { // not really required at this case but...
?>

<form action="insert.php" method="post">
Name: <input type="text" name="name"><br>
Description: <input type="text" name="desc"><br>
Image: <input type="text" name="image"><br>
Location: <input type="text" name="location"><br>
<input type="submit" name="go" value="Submit">
</form>
<?
}
?>

But don't forget to connect this page with the database. I suggest that you make a new page called conection.php with all the details and connections, and put: include("conection.php"); at the top of the pages which requires an connection.

Reply