Im quite new to php and mysql but ive figured out how to upload and display content from my database, but im still facing quite a lot of problems.
- First how do you display an image uploaded in the database?
- Second how do you make the content only display a certain amount of rows per page + how to make it automatically make new pages?
- Third how to make only the newest content display?
- Finally how do you make content display side-by-side in two columns instead of directly under each other?
Output code:
<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tutorials WHERE tut_program='Photoshop' AND tut_category='Text Effects' ";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
?>
<link href="file:///C|/Users/Scott/SlyGraphics/style.css" rel="stylesheet" type="text/css" />
<title>SlyGraffix: Database Test</title><table width="287" border="0" align="center" cellpadding="2" cellspacing="0">
<?
$i=0;
while ($i < $num) {
$tut_name=mysql_result($result,$i,"tut_name");
$tut_link=mysql_result($result,$i,"tut_link");
$tut_program=mysql_result($result,$i,"tut_program");
$tut_category=mysql_result($result,$i,"tut_category");
$tut_video=mysql_result($result,$i,"tut_video");
$tut_download=mysql_result($result,$i,"tut_download");
$tut_image=mysql_result($result,$i,"tut_image");
?>
<tr>
<td width="140"><a href="<? "$tut_link"; ?>"><img src="images/tutorials/fire_reflection.jpg" alt="d" width="140" height="120" border="0" /></a></td>
<td width="139" valign="top"><p align="left"><a href="<? "$tut_link"; ?>"><? echo "$tut_name"; ?> </a> </p>
<p align="left"> Video: <? echo "$tut_video"; ?><br />
Download: <? echo "$tut_download"; ?><br />
External Link: Yes <br />
<br />
>
<? echo "$tut_program"; ?></p>
</td>
</tr>
<?
++$i;
}
echo "</table>";
?>Input Code/page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/template-tut.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>SlyGraffix: Tutorials</title>
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
body {
background-repeat: repeat-x;
background-image: url(images/background.png);
background-color: #08167F;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style3 {font-size: 10px}
-->
</style>
<style type="text/css">
<!--
.style4 {color: #FFFFFF}
-->
</style>
<!-- InstanceEndEditable -->
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
a:link {
color: #00FFFF;
}
a:visited {
color: #00FFFF;
}
a:hover {
color: #0099FF;
}
a:active {
color: #00FFFF;
}
.style1 {font-size: 4px}
.style2 {color: #000000}
-->
</style></head>
<body>
<script language="JavaScript1.2" src="http://www.killersites.com/mvnforum/mvnplugin/mvnforum/js/vietuni.js" type="text/javascript"></script>
<script type="text/javascript">
function SubmitForm() {
if (ValidateForm() == true ) {
document.submitform.submitbutton.disabled=true;
document.submitform.submit();
}
}
function ValidateForm() {
if (document.submitform.tut_name.value=="") {
alert("Please check your Tutorial Name, it might not be there!"); return false;
}
if (document.submitform.tut_link.value=="http://") {
alert("Please check your Tutorial Link, it might not be there!"); return false;
}
if (document.submitform.tut_program.value=="") {
alert("Please select a Program!"); return false;
}
if (document.submitform.tut_category.value=="") {
alert("Please select a Category!"); return false;
}
if (document.submitform.antispam.value=="") {
alert("Please check your Anti-Spam Measure, it might not be there or wrong!"); return false;
}
return true;
}
</script>
<script type="text/javascript">
function SubmitFormSearch() {
if (ValidateFormSearch() == true ) {
document.submitformsearch.submitbutton.disabled=true;
document.submitformsearch.submit();
}
}
function ValidateFormSearch() {
if (isBlank(document.submitformsearch.key, "Search")) return false;
return true;
}
</script>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="7"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="banner" align="right" valign="middle"><form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span class="style1"><span class="style2"><br />
.
.</span></span><br />
<input type="hidden" name="cmd" value="_s-xclick">
<input type="image" src="https://www.paypal.com/en_AU/i/btn/btn_donate_SM.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
<img alt="" border="0" src="https://www.paypal.com/en_AU/i/scr/pixel.gif" width="1" height="1">
<input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIHTwYJKoZIhvcNAQcEoIIHQDCCBzwCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYAPmbVMz77gbQx2zIQM1ZKnFw9Ku2U7cptd4SNcC7uBmLuq9E2pZA57wlbv1l+AGvgZ82qBzkGH6v8+3EOZhYRpLzIeujGdcheqBA/BVnndf3aQgjroB0iwr9Cjar10V2lT/H33zN2B13Jy6mFbKE6TqTF2a/lUhQSL4ObJvdNT5zELMAkGBSsOAwIaBQAwgcwGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQI6Squhb6P1yiAgagi+w1g2qU9x+GFW448FZiorGNS9zlZk1LCu1Xury8RdUQRCzM1s1osiG0ZeFdyDd0bAtPOnrGGMVje1xPUPg5EOsSAlWezDZcn/fnkAOfMyjId/tM6C1gQ3w5TFnpUtJWFck7cTOylO7f3KORfIuxhQS5tVXuJWLtsXLvENkg+kXGCPAy+PowCLru388b4wO3Xj9fhNdtR4SKCMrruQvri2/UMGuvFUWGgggOHMIIDgzCCAuygAwIBAgIBADANBgkqhkiG9w0BAQUFADCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20wHhcNMDQwMjEzMTAxMzE1WhcNMzUwMjEzMTAxMzE1WjCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMFHTt38RMxLXJyO2SmS+Ndl72T7oKJ4u4uw+6awntALWh03PewmIJuzbALScsTS4sZoS1fKciBGoh11gIfHzylvkdNe/hJl66/RGqrj5rFb08sAABNTzDTiqqNpJeBsYs/c2aiGozptX2RlnBktH+SUNpAajW724Nv2Wvhif6sFAgMBAAGjge4wgeswHQYDVR0OBBYEFJaffLvGbxe9WT9S1wob7BDWZJRrMIG7BgNVHSMEgbMwgbCAFJaffLvGbxe9WT9S1wob7BDWZJRroYGUpIGRMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbYIBADAMBgNVHRMEBTADAQH/MA0GCSqGSIb3DQEBBQUAA4GBAIFfOlaagFrl71+jq6OKidbWFSE+Q4FqROvdgIONth+8kSK//Y/4ihuE4Ymvzn5ceE3S/iBSQQMjyvb+s2TWbQYDwcp129OPIbD9epdr4tJOUNiSojw7BHwYRiPh58S1xGlFgHFXwrEBb3dgNbMUa+u4qectsMAXpVHnD9wIyfmHMYIBmjCCAZYCAQEwgZQwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tAgEAMAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODAyMjQxMDE5MzRaMCMGCSqGSIb3DQEJBDEWBBSdda1dzMgMYgRLV95pf0B6zkKx4DANBgkqhkiG9w0BAQEFAASBgFvZCAewsHlerECOdVS2NYkJiEXzA8yZAMR4fkXDESi1fEWmNscSrLUtATgmIHPfTvDcs/j2Ee0AX2wSvTU2+Ivi5aYJFtB0cGoQdyPFha+b0I0rD3u6VEPX1tkDJ10Lh8+IHqRcPs4hoDrjzgBL9CKkJw5Vh5mIZX6f8J8W4py4-----END PKCS7-----
">
</form></td>
</tr>
</table> </td>
</tr>
<!-- InstanceBeginEditable name="nav" -->
<tr>
<td><a href="/index.html" class="navhome"></a></td>
<td><img src="/images/nav-tutorials-ro.png" width="125" height="45" /></td>
<td><a href="/gallery.html" class="navgallery"></a></td>
<td><a href="/downloads.html" class="navdownloads"></a></td>
<td><a href="/forums" class="navforums"></a></td>
<td><a href="/about.html" class="navabout"></a></td>
<td><a href="/contact.html" class="navcontact"></a></td>
</tr>
<!-- InstanceEndEditable -->
<tr>
<td colspan="7" background="images/content-background.png"><!-- InstanceBeginEditable name="Content" --> <div align="center">
<table width="450" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="200"><p><span class="bold">Photoshop Tutorials:</span> 37</p></td>
<td width="50"> </td>
<td width="200"><p><span class="bold">Fireworks Tutorials:</span> 0</p></td>
</tr>
<tr>
<td background="tutorials/text_effect_tutorials.html"><div align="left">
<ul class="style1">
<p><a href="tutorials/effect_tutorials.html">Effects</a> (7)<br />
<a href="tutorials/interface_tutorials.html">Interface</a> (9)<br />
Basics<br />
<a href="tutorials/textures_patterns_tutorials.html">Textures/Patterns</a> (4)<br />
<a href="tutorials/text_effect_tutorials.html">Text Effects</a> (11)<br />
<a href="tutorials/filter_effect_tutorials.html">Filter Effects</a> (6)<br />
Website Layouts </p>
</ul>
</div></td>
<td background="tutorials/text_effect_tutorials.html"> </td>
<td background="tutorials/text_effect_tutorials.html"><div align="left">
<ul class="style1">
<p>Effects<br />
Interface<br />
Basics<br />
Textures/Patterns<br />
Text Effects<br />
Filter Effects<br />
Website Layouts </p>
</ul>
</div></td>
</tr>
<tr>
<td background="tutorials/text_effect_tutorials.html"> </td>
<td background="tutorials/text_effect_tutorials.html"> </td>
<td background="tutorials/text_effect_tutorials.html"> </td>
</tr>
<tr>
<td background="tutorials/text_effect_tutorials.html"><p><span class="bold">Illustrator Tutorials:</span> 0</p></td>
<td background="tutorials/text_effect_tutorials.html"> </td>
<td background="tutorials/text_effect_tutorials.html"><p><span class="bold">Flash Tutorials:</span> 0</p></td>
</tr>
<tr>
<td background="tutorials/text_effect_tutorials.html"><div align="left">
<ul class="style1">
<p>Effects<br />
Interface<br />
Basics<br />
Textures/Patterns<br />
Text Effects<br />
Filter Effects<br />
Website Layouts </p>
</ul>
</div></td>
<td background="tutorials/text_effect_tutorials.html"> </td>
<td background="tutorials/text_effect_tutorials.html"><div align="left">
<ul class="style1">
<p>Effects<br />
Interface<br />
Basics<br />
Textures/Patterns<br />
Text Effects<br />
Filter Effects<br />
Website Layouts </p>
</ul>
</div></td>
</tr>
</table>
<br />
<table class="submit" width="65%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center" class="bold">
<p class="bold">Submit a Tutorial <span class="style8 style3 style4">(Under Construction)</span></p>
<form action="/insert.php" method="post" name="submitform">
<input type="hidden" name="require" value="tut_name,tut_link,tut_program,tut_category,tut_image,antispam">
<input type=hidden name="missing_fields_redirect" value="http://www.slygraffix.com/tutorials.html">
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="30%"><div align="left">
<p class="style6">Tutorial Name:</p>
</div></td>
<td width="70%"><label>
<div align="left">
<input name="tut_name" type="text" maxlength="30" />
</label>
</div></td>
</tr>
<tr>
<td><div align="left">
<p class="style6">Tutorial Link:</p>
</div></td>
<td><label>
<div align="left">
<input name="tut_link" type="text" value="http://" size="50" maxlength="255" />
</div>
</label></td>
</tr>
<tr>
<td><div align="left">
<p class="style6">Graphic Program:</p>
</div></td>
<td><label>
<div align="left">
<select name="tut_program">
<option selected="selected">Please Select One...</option>
<option value="Photoshop">Adobe Photoshop</option>
<option value="Fireworks">Adobe Fireworks</option>
<option value="Illustrator">Adobe Illustrator</option>
<option value="Flash">Adobe Flash</option>
</select>
</div>
</label></td>
</tr>
<tr>
<td><div align="left">
<p class="style6">Graphic Category:</p>
</div></td>
<td><div align="left">
<label>
<select name="tut_category" id="tut_category">
<option selected="selected">Please Select One...</option>
<option value="Effects">Effects</option>
<option value="Interface">Interface</option>
<option value="Basics">Basics</option>
<option value="Textures/Patterns">Textures/Patterns</option>
<option value="Text Effects">Text Effects</option>
<option value="Filter Effects">Filter Effects</option>
<option value="Website Layouts">Website Layouts</option>
</select>
</label>
</div></td>
</tr>
<tr>
<td><p align="left">Video:</p> </td>
<td><div align="left">
<select name="tut_video">
<option value="Yes">Yes</option>
<option value="No" selected="selected">No</option>
</select>
</div></td>
</tr>
<tr>
<td><p align="left">Download:</p> </td>
<td><div align="left">
<select name="tut_download">
<option value="Yes">Yes</option>
<option value="No" selected="selected">No</option>
</select>
</div></td>
</tr>
<tr>
<td><p align="left">Image:<br />
<span class="style7"><span class="style3">(Please add an image with the dimentions of 140px x 120px)</span></span></p> </td>
<td valign="top"><div align="left">
<input name="tut_image" type="file" />
</div></td>
</tr>
<tr>
<td valign="top"><div align="left">
<p class="style6">Anti-Spam Measure:</p>
</div></td>
<td><label>
<div align="left">
<input type="text" name="antispam" id="antispam" />
<img id="imgCaptcha" src="create_image.php" /><br />
</div>
</label></td>
</tr>
<tr>
<td colspan="2"><div align="left"></div>
<div align="left">
<label></label>
</div>
<label>
<div align="left"></div>
</label>
<label>
<div align="left"></div>
</label></td>
</tr>
<tr>
<td> </td>
<td><div align="left">
<label>
<input name="submitbutton" type="button" class="mainoption" value="Submit" onClick="javascript:SubmitForm();">
<input type="reset" value="Reset" class="liteoption">
</label>
</div></td>
</tr>
</table>
</form>
</div></td>
</tr>
</table>
<p> </p>
</div><!-- InstanceEndEditable --> <br />
<center><script type="text/javascript"><!--
google_ad_client = "pub-3504045271097060";
/* SlyGraffix Ads */
google_ad_slot = "8787691705";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script></center><br /><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/footer.png" width="800" height="45" /></td>
</tr>
</table> </td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
I hope someone here can help me with atleast one of my problems.
If you want to see the pages they are: Input Page Output Page