PHP - Need Someone To Write A Script That Will Identify Deleted Videos On My Site

Hi

I have deleted quite lot data from mysql database however,  php still shows that page but blank ie page.php?id=186  - this id and all assosiated fields with this id has been removed from mysql but id still showing on the net and google cached all of them ( 600 pages) . page.php is still in use but I was wondering if there is any way not to show these blank pages/ids from mysql db and more importantly how can I remove these blank pages from google?

Thanks for your help.

I have a mysql table like so

ID  OrderID  Name  Image       CatalogID
1   1             test     pic1.jpg    1
2   2             test2   pic2.jpg    1
3   1             test3   pic3.jpg    2
4   1             test4   pic4.jpg    3
5   1             test5   pic5.jpg    4
6   2             test6   pic6.jpg    4
7   3             test7   pic7.jpg    4

etc etc

(1) I want to use up and down buttons so that the OrderID can be modified to reflect the users order preference, how would I code it so it changes all the OrderID values in the table as  necessary to produce the correct order using the buttons, the only affected items each time would be the ones in the same CatalogID group.

(2) How do I re number the OrderID when an item is deleted so that it moves all the items below it in the same CatalogID group up one value to still reflect the correct order and not skip OrderID values.

How can I recover deleted iphone contacts?

I'm pulling my hair out here...
Here's my problem. I'm about halfway done with my site (It's a site to sell stuff and I'm working on the shopping cart) when I noticed a big problem. I've got session cookies working in every browser (FF, chrome, safari) except Internet Explorer. For some reason IE likes to delete my session cookies so there's nothing there after I click 'view shopping cart'. I've verified that the session is set but then it gets deleted. Now I am using IFrames and I searched for possible causes and tried changing headers, making sure there's no underscores, etc... No joy

The problem is that getting the problem to show up would require a lot of copying code onto this page since it's like 4 or 5 pages to get something into the cart and then view the cart itself. What do you folks recommend? Should I just link to the site itself?

Hello,

I'm using this plain and simple script below to count page views.  Is there a way to identify a spider bot with php and then do something like..   if this visitor is a bot, don't count it.   If not, count it?


Here's my simple script:

Code: [Select]
$querySelect = mysql_query("SELECT * FROM  video WHERE video.id = '$_GET[id]'");
$rowcount = mysql_fetch_assoc($querySelect);
$count = $rowcount['counter'];

if (empty($count)) {
$counter = 1;
$insert = mysql_query("INSERT INTO video (counter) VALUES ($counter) WHERE video.id = '$_GET[id]'");
}

$add = $count+1;
$insertNew = mysql_query("UPDATE video SET counter='$add' WHERE video.id = '$_GET[id]'");

thanks,
Ryan

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.

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>

This topic has been moved to PHP Applications.

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

Im trying to get a login/register script to work in my existing page design but im getting an error, i have no idea what im doing i know next to nothing about php, i just follow tutorials. Most of the error is hidden because the font is the same color as the background but is says:
   
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/aretheyh/public_html/nealeweb.com/index.php:16) in /home/aretheyh/public_html/nealeweb.com/index.php on line 25

Heres the page link where the error occurs:

http://www.nealeweb.com/index.php

Please help, im useless!

I was wondering if anyone is aware of a php script that can pull html from a external site and create a local page with all the urls and image paths rewritten to local paths.

I'm trying to create a module for Drupal that does this. Any script already written that I can adapt to Drupal would be great.

If no one is aware of a current script that does this, can anyone point me in the right direction?

Hello,

Ive got a fairly successful website and im looking at cloning it, I want to set up a cron to check the main site if there are any new posts and if there are insert it into the DB.

Ive got them on 2 separate hosts so i don't want to just read from the DB increase the main site goes down and brings the whole 2nd site down.

What would be the easiest way to do it? Not looking for people to give code, Just their suggestions.

Cheers

Hey all.  I've created a script that updates a website's config in a database. The script itself works fine but I feel it is rather uncanny. Where can I look to find better methods of achieving what I'm trying to accomplish?

Here's my script that updates my table with columns id, showlogin, colorscheme, blogmenu, aboutus.
I explain the script below it.

if (isset($_POST['submit']))
{
        // id will always be 1 and only query if only submit was pressed
$sql = "UPDATE config SET id=1";

        // showlogin values are 1 for show login form and 2 for don't
if(!empty($_POST['showlogin']))
{
$showlogin = $_POST['showlogin'];
$sql .= ", showlogin='$showlogin'";
}
if(!empty($_POST['colorscheme']))
{
$colorscheme = $_POST['colorscheme'];
$sql .= ", colorscheme='$colorscheme'";
}
if(!empty($_POST['blogmenu']))
{
$blogmenu = $_POST['blogmenu'];
$sql .= ", blogmenu='$blogmenu'";
}
else
{
$sql .= ", blogmenu=2";
}
if(!empty($_POST['aboutus']))
{
$aboutus = $_POST['aboutus'];
$sql .= ", aboutus='$aboutus'";
}
else
{
$sql .= ", aboutus=2";
}

mysql_query($sql, $connect) or die (mysql_error());
}

It works like this.  I have a form with a few selects and checkboxes. The selects are the colorscheme and showlogin. The checkboxes are blogmenu and about us, both defaulting to the number 2 if they are not checked. 1 means show this item on the live site and 2 means do not show.  This is pulled out of the database on page loads.

So, I hope I was clear as my mind is spaghetti right now.

Cheers!