Jump to content

kanchatchai

Members
  • Posts

    107
  • Joined

  • Last visited

Posts posted by kanchatchai

  1. 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>

  2. 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>

  3. 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>

  4. 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>

  5. 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';}}

  6. 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>';}

  7. 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")

  8. <?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}?>

  9. <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*/}?>

  10. 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="); ?>

  11. <?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>";?>

  12. 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>";?>

×
×
  • Create New...