Jump to content

naren7

Members
 View Profile  See their activity

  • Posts

    13

  • Joined

  • Last visited

naren7's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. naren7
    niche,i have tried ,its not working
  2. naren7
    look at this http://tellmeboss.com/citysearch.php, is an example.Am trying to do like this.like city city search,am doing pincode search.Am getting output but i need to get it on google map.
  3. naren7
    kk thanks Niche,I have already tried this but,its not working for me... this is my code -------------<!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"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Pincode search</title> </head><body><form method="post"action="index.php"><input type="hidden" name="submitted"value="true"/><label>search category:<select name="category"><option value="PINCODE">PINCODE</option><option value="AREANAME">AREANAME</option><option value="STATE">STATE</option><option value="COUNTRY">COUNTRY</option></select></label><label>search criteria:<input type="text" name="criteria"/></label><input type="submit"/></form> <iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.co.uk/maps?f=q&source=s_q&hl=en&geocode=&q=<?php echo "$PINCODE,+$AREANAME,+$STATE,+$COUNTRY";?>&sll=55.953252,-3.188267&sspn=0.180682,0.591202&ie=UTF8&hq=&hnear=Edinburgh,+City+of+Edinburgh,+United+Kingdom&t=m&z=2&iwloc=A&output=embed"></iframe><br /><small><a href="http://maps.google.co.uk/maps?f=q&source=embed&hl=en&geocode=&q=Edinburgh+uk&aq=&sll=55.953252,-3.188267&sspn=0.180682,0.591202&ie=UTF8&hq=&hnear=<?php echo "$PINCODE,+$AREANAME,+$STATE,+$COUNTRY";?>,+United+Kingdom&t=m&z=2&iwloc=A" style="color:#0000FF;text-align:left">View Larger Map</a></small><?phpif(isset($_POST['submitted'])){include('connect.php'); $category =$_POST['category'];$criteria =$_POST['criteria'];$query ="SELECT * FROM pincodesearch WHERE $category LIKE '%".$criteria."%'";$result = mysqli_query($dbcon,$query) or die(mysqli_error());$num_rows =mysqli_num_rows($result);echo"$num_rows results found";echo"<table>";echo"<tr> <th>PINCODE</th> <th>AREANAME</th> <th>STATE</th><th style='text-align:right'>COUNTRY</th></tr>";while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){echo "<tr><td>";echo $row['PINCODE'];echo"</td><td>";echo $row['AREANAME'];echo"</td><td>";echo $row['STATE'];echo"</td><td>";echo $row['COUNTRY'];echo"</td><tr>";}echo"</table>"; } ?> </body></html> please help..........
  4. naren7
    `Am doing small project on Php.I need to show the address(output) on google map.and .,I need to show recently requested pincodes also.please help.... thanks in advance.. this is my code---------------------------
  5. naren7
    How to display recent searches on a web page using php.......need help Thanks in advance
  6. naren7
    How to connect notepad++ to xamp..........,am unable to get output,,,I got output using same php file in (dreamweaver to xamp) please help...
  7. naren7
    Hi kanchatchai,I dnot want to add search engine to my site, I mean if any one search pincode or address,webpage have to show that particular address and google map dynamically in one page,please help..........
  8. naren7
    Thanks guys..Can you tell me how to link google API to search criteria in above program.....I mean if any one search pincode,webpage have to show that particular address and google map dynamically in one page,please help..........
  9. naren7
    Hi birbal,If i use this one($result = mysqli_query($dbcon, $query) or die(mysqli_error()); Am getting Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\project3\index.php on line 26
  10. naren7
    can any one post any other code for(how to retrieve specific data...from sql using php.)
  11. naren7
    Am not getting output, it shows (error getting data)
  12. naren7
    Error was rectified(i have used Criteria instead of criteria ,but am not getting output now,please help..
  13. naren7
    <!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"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Pincode search</title></head><body><form method="post"action="index.php"><input type="hidden" name="submitted"value="true"/><label>search category:<select name="category"><option value="PINCODE">PINCODE</option><option value="AREANAME">AREANAME</option><option value="STATE">STATE</option></select></label><label>search criteria:<input type="text" name="Criteria"/></label><input type="submit"/></form><?phpif(isset($_POST['submitted'])){include('connect.php');$category =$_POST['category'];$criteria =$_POST['criteria'];$query ="SELECT * FROM pincodesearch WHERE $category LIKE '%".$criteria."%'";$result = mysqli_query($dbcon, $query) or die('error getting data');$num_rows =mysqli_num_rows($result);echo"$num_rows results found";echo"<table>";echo"<tr> <th>PINCODE</th> <th>AREANAME</th> <th>STATE</th> </tr>";while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){echo "<tr><td>";echo $row['PINCODE'];echo"</td><td>";echo $row['AREANAME'];echo"</td><td>";echo $row['STATE'];echo"</td><tr>";}echo"</table>"; } ?> </body></html> ------------------------------------------------------------------------------------------ Notice: Undefined index: criteria in C:\xampp\htdocs\project3\index.php on line 24error getting data-------------------- Getting error.... please help.......................
×
×
  • Create New...