php - How to display images from mysql table after selection of a dropdown category from database? -

-

i want show category based shopping items images on web page can found in online shopping sites.i crated two mysql tables: ist id, category_name , 2nd id, categoryid, product, image_path. able display product images @ time on page, don't know how show product images of single category selected dropdown list submit button @ top of page. hope point clear otherwise feel free ask me.

below attached code shows product images on php page @ time without dropdown list. ideas , advice on doing welcome.

 <head>  <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />  <title>untitled document</title>  <style type="text/css">   ul, li {  list-style-type:none;  }  ul.display { width: 500px; }  ul.display li {  float: left;   width: 100px;  height: 120px; margin-left: 5px;  margin-right: 5px; margin-bottom: 5px; position: relative; vertical-align:middle; text-align:center; } ul.display li img {  width: 94px;  height: 114px; display: inline;   }   </style>  </head>    <body>    <div align="center">  <?php     include('connect.php');     $sql = "select * becuart";     $result = mysql_query( $sql );     echo "<ul class='display'>";     while( $row = mysql_fetch_array( $result ) ) {     $filepath = $row["path"];      echo "<li>";     echo "<a href=\"$filepath\"><img src=\"$filepath\" border=\"0\"></a>";     echo "</li>";      }     echo "</ul>";     ?>    </div>     </body>    </html>`

because it's way long -> new answer:

<?php include 'dbconnect.php'; ?>  <form name="product" method="post" action=""> <table align="right" width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>category</td> <td> <select name="category">  <?php $sql = "select id, art_name, path category;"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) { ?>  <option value="<?= $row['id']; ?>"><?= $row['art_name']; ?></option>   <?php } ?> </select> </td> </tr> <tr> <td>&nbsp;</td> <td><input name="go" type="submit" value="go" /></td> </tr> </table>    </form> <div align="center">   <ul class='display'>  <?php  $id = (int)$_post['category'];  $sql_search = "select id, art_name, path category id = $id";  $search = mysql_query($sql_search);  if (isset($_post['go'])) {  while ($row = mysql_fetch_assoc($search)) {      ?>   <li><a href="<?= $row['path']; ?>"><img src="<?= $row['path']; ?>" border="0"></a></li> <?php }  }  else {  }   ?> </div>

Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more