kanchatchai
-
Posts
107 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by kanchatchai
-
Can variable values be passed more than once? can arrays be passed?
kanchatchai replied to BigD's topic in PHP
SOME CODE <?PHPforeach ($_REQUEST as $key => $val) {echo "$key => $val <br>";}?> -
Can variable values be passed more than once? can arrays be passed?
kanchatchai replied to BigD's topic in PHP
Do you want like this.xxxF <html><head><title>Radio Buttons</title></head><FORM NAME ="form1" METHOD ="POST" ACTION ="xxxxa.php"><?PHP $aray2 = array("Tom", "Jan"); foreach ($aray2 as $i => $value) { echo "<br/><input name=\"name".$i."\" value=\"".$value."\" />"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"male\" >Male"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"female\" >Female"; $maxarray=$i; } echo "<br/><input type=\"hidden\" name=\"maxarray\" value=\"".$maxarray."\" />";/* echo "<br/>"; print_r($aray2); echo "<br/>"; */?><br/><INPUT TYPE = "Submit" Name = "Submit1" VALUE = "Submit"></FORM></html> xxxA.php <html><head><title>Radio Buttons action</title></head><FORM NAME ="form2" METHOD ="PUT" ACTION ="radioButton2.php"><?PHPif (isset($_REQUEST["maxarray"])){for ($i = 0; $i <= $_REQUEST["maxarray"]; $i++){ echo "<br/><input name=\"name".$i."\" value=\"".$_REQUEST["name".$i]."\" />"; if ($_REQUEST["grp".$i]=="male") { echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"male\" checked=\"checked\">Male"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"female\">Female"; } else { echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"male\" >Male"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"female\" checked=\"checked\">Female"; } //echo $_REQUEST["grp".$i];}}//print_r($aray2);?><br/><INPUT TYPE = "Submit" Name = "Submit1" VALUE = "Next"></FORM></html> -
Cannot Add HTML Hyperlink to Replies to Comments in Wordpress
kanchatchai replied to carolm's topic in HTML/XHTML
http://en.support.wordpress.com/links/ -
Can variable values be passed more than once? can arrays be passed?
kanchatchai replied to BigD's topic in PHP
May Be: Change echo "<INPUT TYPE = \"Submit\" Name = \"Submit".$i."\" VALUE = \"Submit\">"; to echo "<INPUT TYPE = \"Submit\" Name = \"Submit\" VALUE = \"Submit\">"; and Use new variable for verification. <html><head><title>Radio Buttons</title></head><body><?PHP$aray2 = array("Tom", "Jan"); foreach ($aray2 as $i => $value) {?><p><FORM NAME ="form<?PHP echo $i;?>" METHOD ="POST" ACTION ="radioButtonA.php"><?PHP echo "<input name=\"name".$i."\" value=\"".$value."\" />"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"male\" >Male"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"female\" >Female"; echo "ID: <input name=\"id\" value=\"".$i."\" />"; echo "<INPUT TYPE = \"Submit\" Name = \"Submit\" VALUE = \"Submit\">";/* echo "<br/>"; print_r($aray2); echo "<br/>"; */?></FORM></p><?PHP }?></html> -
Can variable values be passed more than once? can arrays be passed?
kanchatchai replied to BigD's topic in PHP
Or USExxxxF: By Multi Form <html><head><title>Radio Buttons</title></head><body><?PHP$aray2 = array("Tom", "Jan"); foreach ($aray2 as $i => $value) {?><p><FORM NAME ="form<?PHP echo $i;?>" METHOD ="POST" ACTION ="radioButtonA.php"><?PHP echo "<input name=\"name".$i."\" value=\"".$value."\" />"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"male\" >Male"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"female\" >Female"; echo "<INPUT TYPE = \"Submit\" Name = \"Submit".$i."\" VALUE = \"Submit\">";/* echo "<br/>"; print_r($aray2); echo "<br/>"; */?></FORM></p><?PHP }?></html> -
Can variable values be passed more than once? can arrays be passed?
kanchatchai replied to BigD's topic in PHP
xxxxF: By Single Form <html><head><title>Radio Buttons</title></head><FORM NAME ="form1" METHOD ="POST" ACTION ="radioButtonA.php"><?PHP $aray2 = array("Tom", "Jan"); foreach ($aray2 as $i => $value) { echo "<br/><input name=\"name".$i."\" value=\"".$value."\" />"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"male\" >Male"; echo "<INPUT TYPE = \"Radio\" Name =\"grp".$i."\" value= \"female\" >Female"; $maxarray=$i; } echo "<br/><input type="hidden" name=\"maxarray"\" value=\"".$maxarray."\" />";//<-----Use Max array For Form xxxxA With out Session/* echo "<br/>"; print_r($aray2); echo "<br/>"; */?><br/><INPUT TYPE = "Submit" Name = "Submit1" VALUE = "Submit"></FORM></html> -
Can variable values be passed more than once? can arrays be passed?
kanchatchai replied to BigD's topic in PHP
<?PHP$aray2 = array("Tom", "Jan");foreach ($aray2 as $i => $value) { echo $value.'<br/>'; }?> -
http://w3schools.invisionzone.com/index.php?showtopic=44425&view=findpost&p=247264
-
Use This. <?PHP//------------Config----------------define('upload_allowfiletype','tif,gif,png,jpg,jpeg,doc,docx,xls,xlsx,ppt,pptx,jpg,pdf,zip,rar,txt');define('allowfilesize',3);//Maximum File Size (Mb);define('uploadfolder','upload/');//Upload Folderdefine('rename_on_upload',true);//Random and rename file While Upload//----------------------------------?><form name="upload file" method="post" enctype="multipart/form-data" action=""><br/>File: <input type="file" name="file1"><br/><input type="submit" value="Start Upload" name="submit"></form><?PHPif (isset($_POST['submit'])){createfolder(uploadfolder);$uploadedfilename=upload('file1');/*$checkerror=explode(":",$uploadedfilename);if ($checkerror[0]<>'error'){ //store $uploadedfilename in database;}*/}echo '<br/>----------------------------------<br/>'; //------------Function----------------function upload($file){$allowedExts=explode(",",upload_allowfiletype); $filetype = explode(".", $_FILES[$file]["name"]);$filetype = end($filetype);if (($_FILES[$file]["type"] == "image/gif"|| $_FILES[$file]["type"] == "image/jpeg"|| $_FILES[$file]["type"] == "image/pjpeg")&& $_FILES[$file]["size"] < (allowfilesize*1024*1024)&& in_array($filetype, $allowedExts)){if ($_FILES[$file]["error"] > 0){ echo "Return Code: " . $_FILES[$file]["error"] . "<br />"; return 'error: '.$_FILES[$file]["error"];}else{echo "Upload: " . $_FILES[$file]["name"] . "<br />";echo "Type: " . $_FILES[$file]["type"] . "<br />";echo "Size: " . ($_FILES[$file]["size"] / 1024) . " Kb<br />";echo "Temp file: " . $_FILES[$file]["tmp_name"] . "<br />";}if (file_exists(uploadfolder."/" . $_FILES[$file]["name"])){ echo '<span style=" color:#00F;"> '.$_FILES[$file]["name"].'</span>' . '<span style=" color:#F00;">Already exists. </span>'; return 'error: File Already exists';}else{ if (rename_on_upload==TRUE) { //$filenewcon = strstr($_FILES[$file]["tmp_name"],'.'); $now = date("Ymd"); //date("Dgis"); $passw = rand()*7; $random_file_name=$now."-".$passw; //$random_file_name="$now$passw$filenewcon"; move_uploaded_file( $_FILES[$file]["tmp_name"],uploadfolder.'/'.$random_file_name.'.'.$filetype); echo '<span style=" color:#00F;">Stored in: ' .uploadfolder.'/'. $random_file_name.'</span><br/><br/>'; return $random_file_name; } else { //---------------------------------------------------------------------------------------------------- move_uploaded_file($_FILES[$file]["tmp_name"],uploadfolder.'/'.$_FILES[$file]["name"]); //echo "Stored in: " .uploadfolder.'/'. $_FILES[$file]["name"]."<br/><br/>"; echo '<span style=" color:#00F;">Stored in: <a href="'.uploadfolder.'">' .uploadfolder.'</a>'.$_FILES[$file]["name"].'</span>'; return $_FILES[$file]["name"]; }}}else{ echo '<div style=" color:#F00;">Invalid file</div>'; return 'error: Invalid file';}}function createfolder($foldername){//$foldername='FolderName';if(!file_exists($foldername)){$flgCreate = mkdir($foldername,"0777");if($flgCreate){ echo 'Folder <a href="'.$foldername.'">$foldername</a> Created.';}else{ echo 'Folder <a href="'.$foldername.'">$foldername</a> Not Create.<br/> Please Create Folder '.$foldername.' and Cmod to 777 By Your Self';}}else{// echo 'Folder <a href="'.$foldername.'">$foldername</a> Already Created';}}
-
http://w3schools.invisionzone.com/index.php?showtopic=44522
-
I like That easter egg Website. cheer.
-
i'v seen Site that resize image.May b You can use for your project.http://www.white-hat-web-design.co.uk/blog/resizing-images-with-php/
-
Changed With Download... <?PHPif (isset($_GET["data_inf"])){//------------------------------For download------------------------download_file($_GET["table_db"].'_ins_f.php',$_GET["data_inf"]);}function download_file($filename,$file_data){ header('Content-Disposition: attachment; filename='.$filename); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate'); header('Pragma: public'); //header('Content-Length: ' . filesize($file_data)); //ob_clean();//Clean Header Befor Download File echo $file_data; //flush(); exit;}?><?PHP//Step1--------Get Database Name and Howmany Field------------//Or you can get from your database by use mysql_fetch_row($result)?><H2>Step 1 Input Table Name and Number of fields</h2><form name="step1" method="GET" action=""> <table width="519" bgcolor="#FFFFCC"><tr><td colspan="2"></td></tr><tr><td width="162">db table name: </td><td width="345"><input type="text" name="table_db" /></td></tr><tr><td> Number of fields: </td><td><input type="text" name="numbfield" /></td></tr><tr> <td></td> <td><input name="submit1" type="submit" value = "OK" /> <input name="reset" type="reset" value = "Cancel" /></td></tr></table><a href="?">[ New Project ]</a> <p><br /> </form><?PHP//---------Step 2 Get Field Name and Title-------------if (isset($_GET['numbfield'])&&isset($_GET['table_db'])){echo '<H2>Step 2 Input Field Name and Label</H2>';echo '<form name="step2" method="GET" action="">';$numbfield=$_GET["numbfield"];$table_db=$_GET["table_db"];for ($x = 1; $x <=$numbfield; $x++){ echo '<br>Field '.$x.' Name :<input type="textfield" name="fields_name'.$x.'">'; echo ' Field '.$x.' Title :<input type="textfield" name="fields_title'.$x.'">';}echo '<input type="hidden" name="numbfield" value='.$numbfield.'>';echo '<input type="hidden" name="table_db" value="'.$table_db.'">';echo '<br><input type="submit" name="submit2" value = "OK">';}//---------Step 3 Generate Input Form-------------if (isset($_GET['submit2'])){?><p><strong><? echo $table_db?>_ins_f.php</strong></p><?PHP$insert_form='';$insert_form.='<form name="'.$_GET["table_db"].'" method="post" action="'.$table_db.'_ins.php"><table border="0">';for ($x = 1; $x <=$numbfield; $x++){$insert_form.=' <tr> <td>'.$_GET["fields_title$x"].'</td> <td> <input type="textfield" name="'.$_GET["fields_name$x"].'"> </td> </tr> ';}$insert_form.=' <tr> <td colspan="2"> <input type="reset" name="reset" value="Cancel"> <input type="submit" name="submit" value="OK"> </td> </tr> </table></form>';echo '<form name="insert_form" name="" action="GET"><textarea rows="30" cols="80" name="data_inf">'.$insert_form.'</textarea><br/>';echo '<input type="hidden" name="table_db" value="'.$table_db.'">';echo '<br><input type="submit" name="download_ins_f" value = "download Insert Form">';echo '</form>';}
-
http://dev.mysql.com/downloads/connector/odbc/ 'Practicum 2 Public cnnMySQL As New ADODB.Connection Public RS As New ADODB.Recordset Public MysqlCharset As String = "UTF8" Public Sub ConnectMy(ByVal dbName As String, ByVal DbUser As String, ByVal DbPass As String) On Error GoTo ado2 Dim MySqlHost As String = "127.0.0.1" 'MySqlHost = "localhost" cnnMySQL.CursorLocation = ADODB.CursorLocationEnum.adUseClient cnnMySQL.Open("Driver={MySQL ODBC 5.1 Driver};Server=" & MySqlHost & ";Database=" & dbName & "; User=" & DbUser & ";Password='" & DbPass & "';Option=3;") Exit Subado2: MsgBox("Error Please Check !?!" & MySqlHost & " * " & Err.Description, vbOKOnly) 'MsgBox() End End Sub-----------------------------------...Onload...ConnectMy("dbName", "DbUser", "dbPassword")
-
Do you have upload folder and chmod it to allow upload file?
-
How to Insert...1. http://www.w3schools...toincrement.asp2. Insert Code With out ID
-
<?PHP//Step1--------Get Database Name and Howmany Field------------//Or you can get from your database by use mysql_fetch_row($result)?><H2>Step 1 Input Get Database Name and Number of fields</h2><form name="step1" method="GET" action=""> <table width="519" bgcolor="#FFFFCC"><tr><td colspan="2"></td></tr><tr><td width="162">db table name: </td><td width="345"><input type="text" name="table_db" /></td></tr><tr><td> Number of fields: </td><td><input type="text" name="numbfield" /></td></tr><tr> <td></td> <td><input name="submit1" type="submit" value = "OK" /> <input name="reset" type="reset" value = "Cancel" /></td></tr></table><a href="?">[ New Project ]</a> <p><br /> </form><?PHP//---------Step 2 Get Field Name and Title-------------if (isset($_GET['numbfield'])&&isset($_GET['table_db'])){echo '<H2>Step 2 Input Field Name and Label</H2>';echo '<form name="step2" method="GET" action="">';$numbfield=$_GET["numbfield"];$table_db=$_GET["table_db"];for ($x = 1; $x <=$numbfield; $x++){ echo '<br>Field '.$x.' Name :<input type="textfield" name="fields_name'.$x.'">'; echo ' Field '.$x.' Title :<input type="textfield" name="fields_title'.$x.'">';}echo '<input type="hidden" name="numbfield" value='.$numbfield.'>';echo '<input type="hidden" name="table_db" value="'.$table_db.'">';echo '<br><input type="submit" name="submit2" value = "OK">';}//---------Step 3 Generate Input Form-------------if (isset($_GET['submit2'])){?><p><strong><? echo $table_db?>_ins_f.php</strong></p><textarea rows="30" cols="80"><form name="<?PHP echo $_GET["table_db"]; ?>" method="post" action="<? echo $table_db?>_ins.php"><table border="0"><?for ($x = 1; $x <=$numbfield; $x++){?> <tr> <td><?echo $_GET["fields_title$x"];?></td> <td> <input type="textfield" name="<?echo $_GET["fields_name$x"];?>"> </td> </tr> <?}?> <tr> <td colspan="2"> <input type="reset" name="reset" value="Cancel"> <input type="submit" name="submit" value="OK"> </td> </tr> </table> </form></textarea><?PHP}?>
-
First Sample PHP Generate. <?PHPecho 'echo \'Hello word\';';?>
-
http://www.connectionstrings.com/
-
<a href=\"view_album.php?album_id=" . $row['album_id'] That mean... <?PHP$sql = "SELECT * from photo";if (isset($_GET['album_id']))//<----------$_GET['album_id']{ $result1 = mysql_query("select * from album where album_id='".$_GET['album_id']."'") or die("Error retrieving records from the database: " . mysql_error()); $sql = $sql." ".$_GET['album_id']; while( $row = mysql_fetch_assoc($result1)) { /* Show Album Description */ /* Show Admin part To Insert more Photo*/ }}/* If want pagination see my last code copy my function to function.php and include it*/$result2 = mysql_query($sql) or die("Error retrieving records from the database: " . mysql_error());$i = 0; // Row counterecho "<table>";while( $row = mysql_fetch_assoc($result2)){/* Do It Like First Code *//* Show Photo *//* Show Admin part To Update/Delete Photo*/}?>
-
Or use<script type="text/javascript">function printpage() { window.print() }</script> <input type="image" src="printer.png" alt="[Print]" onclick="printpage()" />
-
http://www.fpdf.org/http://www.fpdf.org/en/tutorial/tuto1.htm
-
DDS1 Do you Insert Admin Code. and pagination <?PHPsession_start();if (!isset($_SESSION["uid"]))echo "<a href=\"login.php\">Login <img src=\"icon/security.png\" alt=\"[Login]\" title=\"[Login]\" border=\"0\"></a>";else{echo "<a href=\"logout.php\">Logout <img src=\"icon/logout.png\" title=\"Logout\" alt=\"[Logout]\" border=\"0\"></a>";echo "<a href=\"album_insert_form.php\">Add <img src=\"icon/add.png\" title=\"Add Ablum\" alt=\"[Add Ablum]\" border=\"0\"></a>";}require("connect.php");/*---------------Begin pagination Check-----------------*/define("per_page",1);$total_pages = mysql_fetch_array(mysql_query("SELECT COUNT(*) as num FROM album"));$total_pages = $total_pages["num"]; $stages = 3; if (isset($_GET['page'])) { $page = mysql_escape_string($_GET['page']); if($page){ $start = ($page - 1) * per_page; }else{ $start = 0; } } else { $page=1; $start = 0; }/*---------------End Begin pagination Check-----------------*/ //define("IMAGE_DISPLAY",2);//define("cover_width",300);//include('function.php');$sql = "SELECT album.album_id, album.album_name, album.album_desc, album.album_cover, COUNT(photo.photo_id) as imagesFROM album LEFT JOIN photo ON album.album_id = photo.album_idGROUP BY album.album_name, album.album_descORDER BY album.album_id ASC LIMIT $start ,".per_page; $result = mysql_query($sql) or die("Error retrieving records from the database: " . mysql_error());$i = 0; // Row counterecho "<table>";while( $row = mysql_fetch_assoc($result)){$album_cover=''; //$data[] = $row; if(($i % IMAGE_DISPLAY) == 0 && ($i != 0)) { echo("</tr>\n<tr>"); } if($row['album_cover']) { $album_cover='upload/'.$row['album_cover']; echo("<td valign=\"top\" width=\"" . floor(100 / IMAGE_DISPLAY) . "%\">\n"); echo("<p><a href=\"view_album.php?album_id=" . $row['album_id'] . "\">" . $row['album_name'] . " (" . $row['images'] . ")</a></p><a href=\"view_album.php?album_id=" . $row['album_id'] . "\"><img src=\"" . $album_cover . "\" alc=\"" . $album_cover . "\"title=\"" . $row['album_desc'] . "\" align=\"middle\" width=\"".cover_width."\"></a>"); if (isset($_SESSION["uid"])) { //or you can add code in view_album.php echo "<br /><a href=\"add_image.php?album_id=".$row['album_id']."\"><img src=\"icon/add.png\" alt=\"add\" border=\"0\"></a>"; echo "<a href=\"album_update_form.php?album_id=".$row['album_id']."\"><img src=\"icon/edit.png\" alt=\"[edit]\" border=\"0\"></a> "; if ($row['images']==0)//if no have image you can delete album echo "<a href=\"?action=delete&album_id=".$row['album_id']."\"><img src=\"icon/del.png\" alt=\"[del]\" border=\"0\"></a>"; } echo("<br /><p>" . $row['album_desc'] . "</p>\n</td>\n"); } else { echo("<td valign=\"top\" width=\"" . floor(100 / IMAGE_DISPLAY) . "%\"> "); echo("</td>\n"); } $i++; }echo "</table>"; Function pagination($total_pages,$page,$start,$stages,$more_url){ // Initial page num setup if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil($total_pages/per_page); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= "<div class='paginate'>"; // Previous if ($page > 1){ $paginate.= "<a href='?page=1$more_url'>«</a>"; // |< First $paginate.= "<a href='?page=$prev$more_url'>‹ </a>"; //<Back }else{ $paginate.= "<span class='disabled'>«</span>"; // |< First $paginate.= "<span class='disabled'>‹ </span>"; //<Back } // Pages if ($lastpage < 7 + ($stages * 2)) { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='?page=$counter$more_url'>$counter</a>";} } } elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few? { // Beginning only hide later pages if($page < 1 + ($stages * 2)) { for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='?page=$counter$more_url'>$counter</a>";} } $paginate.= "..."; $paginate.= "<a href='?page=$LastPagem1$more_url'>$LastPagem1</a>"; $paginate.= "<a href='?page=$lastpage$more_url'>$lastpage</a>"; } // Middle hide some front and some back elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) { $paginate.= "<a href='?page=1$more_url'>1</a>"; $paginate.= "<a href='?page=2$more_url'>2</a>"; $paginate.= "..."; for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='?page=$counter$more_url'>$counter</a>";} } $paginate.= "..."; $paginate.= "<a href='?page=$LastPagem1$more_url'>$LastPagem1</a>"; $paginate.= "<a href='?page=$lastpage$more_url'>$lastpage</a>"; } // End only hide early pages else { $paginate.= "<a href='?page=1$more_url'>1</a>"; $paginate.= "<a href='?page=2$more_url'>2</a>"; $paginate.= "..."; for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='?page=$counter$more_url'>$counter</a>";} } } } // Next if ($page < $counter - 1){ $paginate.= "<a href='?page=$next$more_url'> ›</a>"; //Next > //$paginate.= "<a href='?page=".($counter-1)."$more_url'>»</a>"; //Last >| $paginate.= "<a href='?page=$lastpage$more_url'>»</a>"; //Last >| }else{ $paginate.= "<span class='disabled'> ›</span>"; //Next > $paginate.= "<span class='disabled'>»</span>"; //Last >| } $paginate.= "</div>"; } return $total_pages.' Results '.$paginate; } /*---------------pagination-----------------*/ echo pagination($total_pages,$page,$start,$stages,"&orderby="); ?>
-
<?PHPrequire("connect.php");define("IMAGE_DISPLAY",3);define("cover_width",300);define("upload_folder","upload/");//include('function.php');$sql = "SELECT album.album_id, album.album_name, album.album_desc, album.album_cover, COUNT(photo.photo_id) as imagesFROM album LEFT JOIN photo ON album.album_id = photo.album_idGROUP BY album.album_name, album.album_descORDER BY album.album_id ASC";$result = mysql_query($sql) or die("Error retrieving records from the database: " . mysql_error());$data = array();while( $row = mysql_fetch_assoc($result)){ $data[] = $row;} echo "<table border=\"1\">"; foreach ($data as $i => $value) { $album_cover=''; //echo $data[$i]['album_name']; if(($i % IMAGE_DISPLAY) == 0 && ($i != 0)) { echo("</tr>\n<tr>"); } if($data[$i]['album_cover']) { echo("<td valign=\"top\" width=\"" . floor(100 / IMAGE_DISPLAY) . "%\">\n"); echo("<p><a href=\"view_album.php?album_id=" . $data[$i]['album_id'] . "\">" . $data[$i]['album_name'] . " (" . $data[$i]['images'] . ")</a></p><a href=\"view_album.php?album_id=" . $data[$i]['album_id'] . "\"><img src=\"" . upload_folder.$data[$i]['album_cover'] . "\" title=\"" . $data[$i]['album_desc'] . "\" align=\"middle\" width=\"".cover_width."\"></a>"); echo("<br /><p>" . $data[$i]['album_desc'] . "</p>\n</td>\n"); } else { echo("<td valign=\"top\" width=\"" . floor(100 / IMAGE_DISPLAY) . "%\"> "); echo("</td>\n"); } }echo "</table>";?>
-
Do you Mean Like this. Do you mean.<?PHPrequire("connect.php");define("IMAGE_DISPLAY",4);define("cover_width",300);//include('function.php');$sql = "SELECT album.album_id, album.album_name, album.album_desc, album.album_cover, COUNT(photo.photo_id) as imagesFROM album LEFT JOIN photo ON album.album_id = photo.album_idGROUP BY album.album_name, album.album_descORDER BY album.album_id ASC";$result = mysql_query($sql) or die("Error retrieving records from the database: " . mysql_error());$i = 0; // Row counterecho "<table>";while( $row = mysql_fetch_assoc($result)){$album_cover='';//$data[] = $row; if(($i % IMAGE_DISPLAY) == 0 && ($i != 0)) { echo("</tr>\n<tr>"); } if($row['album_cover']) { $album_cover='upload/'.$row['album_cover']; echo("<td valign=\"top\" width=\"" . floor(100 / IMAGE_DISPLAY) . "%\">\n"); echo("<p><a href=\"view_album.php?album_id=" . $row['album_id'] . "\">" . $row['album_name'] . " (" . $row['images'] . ")</a></p><a href=\"view_album.php?album_id=" . $row['album_id'] . "\"><img src=\"" . $album_cover . "\" title=\"" . $row['album_desc'] . "\" align=\"middle\" width=\"".cover_width."\"></a>"); echo("<br /><p>" . $row['album_desc'] . "</p>\n</td>\n"); } else { echo("<td valign=\"top\" width=\"" . floor(100 / IMAGE_DISPLAY) . "%\"> "); echo("</td>\n"); } $i++; /*echo $row['album_id'];echo $row['album_name'];echo $row['album_desc'];echo $row['images'];echo '<br/>';*/}echo "</table>";?>
