PHP - Any Way To Identify Bots?

Hello

We have a series of sites that use Google API to serve locations stored in local DB, that show google maps from within given PHP pages within our sites (these pages also have other db driven content we wish to keep....

Each 'member' in our sites,  they each have a google map shown on each page present for their 'location' menu tab...

These calls to the google map API,  often goes over our daily allotment of freebie map presentations from the google API

It is SE and other Bots that run these view numbers off the charts and prevent the google maps from loading the actual maps - we get a google map err message - advising that maximum views have been reached... (we see this in our server error logs)

Thoughts on how i can serve this map code to only legit http requests (human eyes)  or at least reduce the burden of bot crawl requests to the google API?

here is the code we use to call the maps

 - We need to encapsulate Google Map Display in a snippet that will block it from getting hit by bots....

Huge Thanks!

Code: [Select]
<form target="_blank" method="GET" action="http://maps.google.com/maps">
<input type="hidden" name="daddr" value="<? echo "$address, $city, $state $zip $country" ?>">
<?php display_tooltip("Please enter your starting point in the form address, city, state zip country or simply enter your city", "mapdir");?>
<input type="text" name="saddr" value="your starting point" onfocus=this.select()>
<input class="clickableL" type="submit" value="Map and Directions">
</form>

I was just wondering what the best way to identify an empty set is.  At the moment I have this but this doesn't seem to work so I was wondering what the best way is.  Thanks. 


$article_rs = mysql_query($article_sql, $mysql_conn);

if (!$article_rs) {
$_SESSION['no_articles'] = "<p>Sorry but there are no articles that match your search.</p>";
}

Hi, how to identify whether the array is single or two dimensional array?

I need to be able to identify the  browser tab that sent each request the server receives.

I originally planned to do this by passing an ID back from each web page. However, I found that when the user leaves a web page by clicking a non-form button or a link, this causes huge problems. The ID really has to be returned via POST to prevent users from using it inappropriately, and the prospect of making a button or link do a POST is not appealing.

Is there any other technique I can use? I've examined all of the superglobals, but I didn't find anything that would work.

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=345438.0

Good Evening,

What I am trying to do in here is to display data based on my selected option in the drop down list. I don't have submit button, I just want it to automatically display results based on my selection. Here's my code:

<link href="add_client.css" rel="stylesheet" type="text/css">

<?PHP
include("dbconnection.php"); //Include database connection to file

$query = "SELECT * FROM records";

if(isset($_POST["territory"]))

{
$query .= " WHERE territory LIKE '%".$_POST["territory"]."%' ORDER BY territory ASC LIMIT 0,15"  ;
$result = mysql_query($query, $connection) or die(mysql_error());

} 

 

?>

<!-- Start of table -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<td>
      <table width="760" border="0" cellpadding="0" cellspacing="0">
        
<!-- Table data containing the Asia Logo -->
            <td width="199" align="center" valign="top">
                <a href="login.html">
                 <img src="asia.gif" alt="" width="152" height="58" border="0" />
                </a>
            </td>
            <!-- Table data containing Home button -->
            <td width="176" align="right" valign="bottom">
                <a href="main.php">
                 <img src="Home.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Table data containing View Client button -->
            <td width="130" align="right" valign="bottom">
                <img src="View.jpg" width="104" height="20" border="0"/>
            </td>
            <!-- Table data containing the Add Client button -->
            <td width="146" align="right" valign="bottom">
                <a href="add_client.php">
                 <img src="Add.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Blank table data -->
            <td width="109" align="right" valign="bottom">&nbsp;
            
            </td>
        </table>

        <!-- Table design division and body-->
        <table width="760" border="0" cellpadding="0" cellspacing="0">
     <td width="200" height="3"  bgcolor="#1B1C78">
     <img src="images/topspacerblue.gif" alt="" width="1" height="3" /></td>
    <td width="560"  bgcolor="#0076CC">
     <img src="images/topspacerlblue.gif" alt="" width="1" height="3" /></td>
    <tr>
    <td height="500" colspan="2" align="center" valign="top"  bgcolor="#F3FAFE">
            <!-- Page contents -->
            <!-- Search Query -->
            <br>
            <form name="form" action="trustlist.php" method="post">
            <table width="293" border="0">
<tr>
                    <td width="140" align="left" valign="middle">
                        SEARCH RECORD:
                    </td>
                    <td width="143" align="center" valign="middle"><select name="territory" id="territory" style="width: 143px" width="230">
                      <option selected="selected" disabled="disabled">Select Territory</option>
                      <option>Territory 01</option>
                      <option>Territory 02</option>
                      <option>Territory 03</option>
                      <option>Territory 04</option>
                      <option>Territory 05</option>
                      <option>Territory 06</option>
                      <option>Territory 07</option>
                      <option>Territory 08</option>
                      <option>Territory 09</option>
                      <option>Territory 10</option>
                    </select></td>
                </tr>
</table>
            <br>
            <!-- End of search query-->
            <!-- Start of Search Results-->
            <table border="0" cellpadding="3" cellspacing="1" bordercolor="38619E" >
                <tr>
                    <th width="148" align="center" bgcolor="#E0E8F3">Acute Trusts</th>
                    <th width="262" align="center" bgcolor="#E0E8F3">Employer</th>
                    <th width="160" align="center" bgcolor="#E0E8F3">Name</th>
                    <th width="80" align="center" valign="middle" bgcolor="#E0E8F3">&nbsp;</th>
                </tr>
<?php
if($result)
{
for($i=0; $i<mysql_num_rows($result); $i++)
   {
$id = trim(mysql_result($result, $i, "id"));
$territory = trim(mysql_result($result, $i, "territory"));
$employer = trim(mysql_result($result, $i, "employer"));
$first_name = trim(mysql_result($result, $i, "first_name"));
$last_name = trim(mysql_result($result, $i, "last_name"));
  
echo "<tr>";
   echo "<td>".$territory."</td>";
   echo "<td>".$employer."</td>";
   echo "<td>".$last_name.", ".$first_name."</td>";
   echo "<td><a href='edit_client.php?id=".$id."'>edit</a> | <a href='delete_client.php?id=".$id."'>delete</a></td>";
   echo "</tr>";
}   
}  
?>

</table>
            </form>
            <!-- End of page -->
            </td>
          </tr>
        </table>
</td>
<tr>
     <td height="38">
         <table width="760" border="0" cellpadding="0" cellspacing="0">      
         <td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white>
         <a href="disclaimer.html">
             <font color="#FFFFFF">Legal Disclaimer</font>
             </a>
         </td>
         <td width="560" align="center"  bgcolor="#0076CC">
         Copyright &copy; 2006 - 2010 AsiaLimited. All rights reserved.
         </td>
</table></td>
</tr>
</table>

Hi Guys,

I keep getting the following error:

Parse error: syntax error, unexpected T_ECHO in /Applications/XAMPP/xamppfiles/htdocs/pet/petCatalog1.php on line 51

I have copied the code from a tutorial and cannot for the life of me work out what the problem is with line 51????

I have attached the file and pasted the code below. The real problem line is:


      echo "<tr><td valign='top' width='15%' style='font-weight: bold; font-size: 1.2em'\n"

The full code is attached - btw, inserting the ">" does not help to fix it!!

<?php
/* Programme:   PetCatalog.php
 * Desc:      Lists all pet categories with radio buttons
 */
?>

<html>
   <head>
      <title>Select a Pet Category</title>
   </head>
<body>

   <?php
   /* Database login info - Move to an Include
    */
      
   $host="localhost";
   $user="root";
   $passwd="";
   $dbname="information_schema";   
   
   /* Establishes a connection with the databse
    */
   
   $cxn = mysqli_connect ($host, $user, $passwd, $dbname)
   or die ("Could not connect to the database JAMIE!");
   
   /* SQL Query to select all categories of pet from the petType column in the pet table
    */
   
   $query = "SELECT * FROM PetCatalog.petType ORDER BY petType";
   $result = mysqli_query($cxn,$query)
   or die ("Unable to connect to the database JAMIE");
   
   /* Echo of H1 & H2 above the pet table
    */
   
   echo "<div style='margin-left: .lin'>\n
   <h1 style='text-align: center'>Pet Catalogue</h1>\n
   <h2 style='text-align: center'>The following categories of pets are now available</h2>\n";
   
   /*   Create form to diplay pet categories
    */
   
   echo "<form action='ShowPets.php' method='POST'>\n";
   echo "<table cellpadding='5' border='1'>";
   $counter=1;
   while ($row = mysqli_fetch_assoc($result))
   {
      extract ($row)
      echo "<tr><td valign='top' width='15%' style='font-weight: bold; font-size: 1.2em'\n"
      echo "<input type='radio' name='interest' value='$petType'\n";
      if( $counter == 1 )
      {
         echo "checked='checked'";
      }
      echo ">$petType</td>";
      echo "<td>$typeDescription</td></tr>";
      $counter++;
   }
   echo "</table>";
   echo "<p>input type='submit' value='Select Pet Type'>
   </form></p>\n";
   
   ?>
</body>
</html>

I have approximately 2,300 videos embedded on my site, and I am constantly adding more. The videos are hosted by YouTube. When a video is deleted from YouTube, it becomes unavailable on my site.

Each video's ID is in my MySQL database. A video ID looks like this:

ZFOuxAx-dkc

I need a script that will do the following: select the IDs from my database check if the videos are still available on YouTube create a list of the videos that are unavailable. If possible, it would be great if the script could also tell me if any of the videos have been blocked in certain countries.

The script has to be fully commented so that I can understand it.

I want to run the script manually every few days. I don't want to have to change my database tables.

I've been told that you can use YouTube's API or YouTube's oEmbed interface. I've also been told that, because there are so many videos, you will have to use cURL multi handles.

If interested in this project, please PM me your price.   This is an urgent project. I have placed ads elsewhere.