PHP - How To Make The Search Period Longer

Hi, thanks in advance for any help here.  I have a PHP 'contact us' form on my website that recently stopped returning the information that gets entered into the form.  I don't know why it's no longer working and was hoping someone here could help.  It's worked for the last 4 years and only stopped working within the last week.  I still get the email, but none of the information is returned, only blanks.  Any ideas?

Here's the script I'm using:
Code: [Select]
<?php

      /*----------------------*/ 
      /*   URL of the site.   */
      /*----------------------*/
      $site_URL    =    "http://www.Website.com/";       
      
      /*----------------------*/ 
      /*   Name of the site.   */
      /*----------------------*/
      $site_Name    =    "Website.com";                   
      
      /*----------------------*/ 
      /*   ADMIN email id.   */
      /*----------------------*/
      $admin_from =    "webmaster@Website.com";
      
      /*----------------------*/ 
      /*   ADMIN email id to which comments are sent.   */
      /*----------------------*/
      $admin_email =    "info@Website.com";
      

   
   $name =     $_REQUEST["firstname"];
   $lastname = $_REQUEST["lastname"];
   $email =    $_REQUEST["email"];
   $zipcode =  $_REQUEST["zipcode"];
   $phone =    $_REQUEST["phone"];
   $message =  $_REQUEST["message"];

   $subject = "$site_Name has Received your Message";
        
   $sendmessage = "<font face='tahoma, verdana, arial, helvetica' size=2>New Comments Received...<br><br>";
   $sendmessage .= "<strong>Name:</strong> $name $lastname<br>";
   $sendmessage .= "<strong>Zipcode:</strong> $zipcode<br>";
   $sendmessage .= "<strong>Phone:</strong> $phone<br>";
   $sendmessage .= "<strong>Email:</strong> <a href='mailto:$email' style='color:#6095cc; text-decoration: none;'>$email</a><br>";
   $sendmessage .= "<strong>Message:</strong> $message<br>";
   
   $sendmessage .= "<br><a href='$site_URL' target=_blank>$site_Name</a></font>";
       
   $headers = "Content-Type: text/html; charset=iso-8859-1\n"; // Mime type
   $headers .="From: $site_Name Registration <$admin_from>\n";
   
   
   mail($admin_email, $subject, $sendmessage, $headers);
   
      
   $reply_msg = "<font face='tahoma, verdana, arial, helvetica' size=2>Thank you for your comments at $site_Name.  We will reply soon!<br>";
   $reply_msg .= "<br>- <a href='$site_URL' target=_blank>$site_Name</a></font>";
   
   $headers = "Content-Type: text/html; charset=iso-8859-1\n"; // Mime type
   $headers .="From: $site_Name<$admin_from>\n";
   
   // send an email to confirm the referer.
   mail($email, "$site_Name - Your comments have been received!", $reply_msg, $headers);
   
?>


<center>
  <font face='tahoma, verdana, arial, helvetica' color='#333333'>
  <h2>
    <?=$site_Name?>
  </h2>
  <p><font size="2" face="Arial, Helvetica, sans-serif"><strong>Please wait while your comments are being sent.</strong>.<br />
    If your page does not refresh automatically, <a href="<?=$site_URL?>">Click Here</a>.</font></p>
</center>
<script language="javascript">   
   window.location.href = "<?=$site_URL?>";
</script>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi,

I have tried to merge two queries into one however a piece of code keeps coming up with an error:

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource.

It relates to this.  I cant see it doesn't work and I have tried around 10 different options but this is the nearest I can get.  Can anyone advise me what the problem is and why this no longer works please?

while($row = mysql_fetch_assoc($myQuery)) 


<?php

ini_set('display_errors', 1);
error_reporting(-1);

if( isSet($_GET['description'])) 
$description = $_GET['description'];


if(isSet($_GET['price'])) 
$price = explode('-',$_GET['price']);
$low = (int)$price[0];
$high = (int)$price[1];

($myQuery = "SELECT * FROM productfeed WHERE 1 . 
if(isset($description)) ' AND if description = '. $description;
if(isset($price)) ' AND if price = '. $price;
. ");

while($row = mysql_fetch_assoc($myQuery)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

$fulldescription = substr("$fulldescription", 0, 400);    

echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image' width=\"95%\" /></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
}

Ok, I made some changes to my code (change in variable names only) and now it doesn't seem to work.

Here is the code.


<?php
if ($_REQUEST['postal'] != "" && $_REQUEST['lbs'] != "") {
$postal = $_REQUEST['postal'];
$lbs = $_REQUEST['lbs'];
$type = $_REQUEST['type'];
if ($type == "splist") {
$ztype = "cansp_zone" ;
$lbstype = "sp";
} else {
$ztype = "canmp_zone";
$lbstype = "mp";
}
$qP1 = "SELECT * FROM " . $dbprefix . "_canzones WHERE canzone_postal = '$postal'  "; $which = $handle_db2;
$rsP1 = mysql_query($qP1,$which);
if (mysql_num_rows($rsP1) > 0) {

$row1 = mysql_fetch_array($rsP1);

extract($row1);
$prov = trim($canzone_prov);
$zone = trim($canzone_zone);

$dzone = $ztype.$zone;
$dlbs = "can" . $lbstype . "_lbs";


$query = "SELECT $dzone FROM " . $dbprefix . "_can" . $type . " WHERE $dlbs = '$lbs'  "; $which = $handle_db2;
    $result = mysql_query ($query,$which);
    $row = mysql_fetch_array($result);
    $dzone = $row[0];

$qP3 = "SELECT * FROM settings WHERE storeid = '$dbprefix'  "; $which = $handle_db2;
$rsP3 = mysql_query($qP3,$which);
$row3 = mysql_fetch_array($rsP3);
extract($row3);
$taxsetting = trim($taxsetting);
$gst = trim($gst);
$pst = trim($pst);
$hst = trim($hst);
$cp_fuelcharge = trim($cp_fuelcharge);
$cp_markup = trim($cp_markup);

include("./inc/taxcalc.php");
include("./inc/markcalc.php");


./inc/markcalc.php is as follows:

<?php
if ($cp_markup != "") {
$cp_mark = ($dzone * ($cp_markup / 100));


When I output $cp_mark, it comes out as the same value as $cp_markup

Any ideas?

I apologize if this isn't the exact right location for this question, but it's the best place I could find.  I work for a small business and the server hosting our website recently disabled FormMail.  We no longer have a webdesigner per se and I've been the one taking care of the website.  Unfortunately the few programming classes I've taken have mostly left me by now and I'm banging my head against the wall trying to find a way to get back our multiple feedback forms.  I'm sure the best thing would be to hire someone, but business hasn't been great and the boss is counting on me, so I'm hoping someone here may have some suggestions.  I've been corresponding with our server trying to get some suggestions on what to do and this is the best they've been able to tell me;

"The reason being that Shared Servers must have
the ability for php/cgi to send mail disabled as a protection against
darkmailer, so any form or scripts that would send mail must be able to
authenticate itself to the server as a valid user."

"If you can find a method to send the
mail without php/cgi, or one that does go through the steps to authenticate as
a valid user (specifically, as you), then we can probably get you all set up."

"The only option at this point would
be to correct your script to authenticate as a valid email user."

"...you would need to change your scripts to
login with a mail user to authenticate and send mail."

Now I'm not completely programming illiterate; I mean, I passed my classes in college, but I can't figure out how to do this.  They say they don't allow any FormMail or FormMail Clones, so I'm fairly lost.  If anyone has any helpful hints or suggestions I would appreciate it greatly.

Thanks,
Zach

I'm sure there is a very simple fix to this problem.

I have an image uploader in the backend of my site. Since moving hosts this no longer works.

The PHP is



if((!empty($_FILES["indeximage"]))) {

$indeximagename = basename($_FILES['indeximage']['name']);
$indeximagenew = $_SERVER['DOCUMENT_ROOT'] . '/images/uploaded/index/' . $indeximagename;

if (!file_exists($indeximagenew)) {
if ((move_uploaded_file($_FILES['indeximage']['tmp_name'], $indeximagenew)) === true) {
echo $indeximagename;
echo ' was successfully uploaded.';
}else {
echo 'Unable to move';
echo $indeximagename;
echo ' into the right folder.';
}
}else {
echo 'You did not upload an index image.';
}
}



I'm guessing the problem is with the document root part. $indeximagenew echos /var/www/vhosts/webaddress.co.uk/httpdocs/images/uploaded/index/imagename.jpg

The actual actual address of the image, when on the site, is http://www.webaddress.co.uk/images/uploaded/index/imagename.jpg

Any help would be great!

We're moving to a new web server and we recently migrated to a new MS SQL server, as well. All PHP functions on the old web server were switched to point to the new SQL server and all was well.

But..... Now I''m trying to move my PHP functions to the new web server and it won't connect to the database. PHP works fine because I can echo "Testing" or whatever. I've downloaded the SQL Server PHP drivers from Microsoft, changed the connection string from MSSQL to SQLSRV, updated the PHP.ini file, and taken several other steps. It still can't see the database.

Ideas?

Oh, yeah. And both the new web server and MS SQL server are Server 2008 R2.

I had to move hosters recently and I have a couple of scripts run using CRON to backup my MySql database and manage the number of backups that I keep.  I can ask the hosters to deprecate the version of PHO backwards but I don't want to lose the opportunity of features that may be available in the new version.  The main script essentially performs a MySqlDump to a specified directory and then emails me to tell me that it completed successfully.  The second script just deletes any files in the backup folder more than x days old.

I know mysqldump is a valid call so I should need to use anything other than that but I'm lost when it comes to seeing what is wrong with my scripts.

backup.php

<?
$datestamp = date("Y-m-d");      // Current date to append to filename of backup file in format of YYYY-MM-DD
                                 // run the command php -q /home/mysite/public_html/scripts/ffbackup.php

/* CONFIGURE THE FOLLOWING SEVEN VARIABLES TO MATCH YOUR SETUP */
//    require($_SERVER["DOCUMENT_ROOT"]."/config/db_config.php");
    require("/home/mysite/config/db_config.php");
    $connection = mysql_connect($db_host, $db_user, $db_password);
    mysql_select_db($db_name, $connection);

//$dbuser = $db_user, $conection ;            // Database username
//$dbpwd = ($db_password, $conection);            // Database password
//$dbname = ($db_name, connection);            // Database name. Use --all-databases if you have more than one
$backdir ="/home/mysite/forumbackup/";
$filename= "backup-$datestamp.sql.gz";   // The name (and optionally path) of the dump file
$to = "my-email@address.com";      // Email address to send dump file to
$from = "admin@mysite.com";      // Email address message will show as coming from.
$subject = "Mysite MySQL backup file-$datestamp";      // Subject of email

$command = "mysqldump -u $db_user --password=$db_password $db_name | gzip > $filename";
$result = passthru($command);
$newfile = $filename;

copy ($filename, $backdir.$newfile);

$message = "Compressed database backup file $filename copied to backup directory.";
$headers = "From: $from\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

mail($to, $subject, $message, $headers);

unlink($filename);   //delete the backup file from the server
?>

 

and delold.php

<?php
$path = "/home/mysite/forumbackup/";

//echo "script is running";
//echo "the path is $path ";

      if (is_dir("$path") )
        {
           $handle=opendir($path);
           while (false!==($file = readdir($handle))) {
               if ($file != "." && $file != "..") { 
                   $Diff = (time() - filectime("$path/$file"))/60/60/24;
                   if ($Diff > 10) unlink("$path/$file");

               }
           }
           closedir($handle);
   }
?>

 

  $start = 0;

I have a 'subscribe' form on a website that uses Ajax to validate the input fields, the form is then processed via php. The actual html code resides on a Wordpress page.   I had actually just got the form to work again. The website was static, and I transferred everything over to Wordpress, and the form didnt work. I was able to get it working by specifying the url: in ajax, as an absolute path to my php form. Overnight, something, I'm not sure what, stopped the form from processing. No data is posted to myql, and no email is sent or received. The status message just hangs at "Please wait while we process your information..." This message is in part of my Ajax code, so I am thinking something is wrong with my php script. I have a 'contact' page that uses nearly identical code that the 'subscribe' pages uses to validate the input fields, and it works.   I was able to recover both the ajax and php script from an earlier time when they did work, I uploaded back to my server and nothing, the form still does not process. I also made sure my database credentials were correct with my host, and even tested my connection to mysql which I was able to connect. Next, I made sure I was able to send mail with my host.   I don't know what is causing the form to hang, and I would love to get this solved; any help would be appreciated!

So this script did work in previous versions oh php but in php5 I get the error, "Sorry, uploaded images must be of type jpg or jpeg, (not )."
So it looks like it's not recognizing my file as a jpeg??

Any contributions towards a fix are GREATLY appreciated!!!   If there are clean, nice (EASY) php5 scripts available for this simple image uploading and thumbnail creation I would consider starting this over.


//Listing page code:

echo "<form name=\"addCat\" enctype=\"multipart/form-data\" action=\"preview.php\" method=\"post\">";
<INPUT type="file" name="pic1" size="50" value="">
<INPUT type="file" name="pic2" size="50" value="">
<INPUT type="file" name="pic3" size="50" value="">
<INPUT type="file" name="pic4" size="50" value="">
<input type="submit" value="Upload Images">

//preview.php page code:

$pic1 = $_FILES['pic1'];
$pic2 = $_FILES['pic2'];
$pic3 = $_FILES['pic3'];
$pic4 = $_FILES['pic4'];

function ResizeImage($im,$maxwidth,$maxheight,$name){
   $width = imagesx($im);
   $height = imagesy($im);
   if(($maxwidth && $width > $maxwidth) || ($maxheight && $height > $maxheight)){
      if($maxwidth && $width > $maxwidth){
         $widthratio = $maxwidth/$width;
         $RESIZEWIDTH=true;
      }
      if($maxheight && $height > $maxheight){
         $heightratio = $maxheight/$height;
         $RESIZEHEIGHT=true;
      }
      if($RESIZEWIDTH && $RESIZEHEIGHT){
         if($widthratio < $heightratio){
            $ratio = $widthratio;
         }else{
            $ratio = $heightratio;
         }
      }elseif($RESIZEWIDTH){
         $ratio = $widthratio;
      }elseif($RESIZEHEIGHT){
         $ratio = $heightratio;
      }
       $newwidth = $width * $ratio;
        $newheight = $height * $ratio;
      if(function_exists("imagecopyresampled")){
            $newim = imagecreatetruecolor($newwidth, $newheight);
            imagecopyresampled($newim, $im, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
      }else{
         $newim = imagecreate($newwidth, $newheight);
            imagecopyresized($newim, $im, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
      }
        ImageJpeg (($newim),$name . ".jpg");
      ImageDestroy ($newim);
      }else{
      ImageJpeg ($im,$name . ".jpg");
      }
}


// Set up some variables
flush();
set_time_limit(210);  // set process page limit to 3.5 minutes
$maxfilesize = "102400"; //# individual file size limit - in bytes (102400 bytes = 100KB)
$path="2012images";
$thumbpath="thumbs";

// two data pulls to rename images - would be easier to have a permanent counter...fix later
$mysql[getpicname] = mysql_query("select pic from picname");
$z = mysql_fetch_array($mysql[getpicname]);
$new_filename=$z[pic];
$new_z[pic]=$z[pic]+$total_pics;
if(@mysql_query("UPDATE picname SET pic = '$new_z[pic]' "))  echo "";


// Create thumbnail from imgurl and store in thumbs

// Height to reszie image to (in pixels)
$RESIZEHEIGHT=200;
// Width to reszie image to (in pixels)
$RESIZEWIDTH=200;
//thumbnail to thumbs folder, named same as 1st image
$FILENAME=$thumbpath."/".$new_filename;
$thumb_name=$thumbpath."/".$new_filename.".jpg";

// create a thumbnail from the first image only
$im = imagecreatefromjpeg($_FILES['pic1']['tmp_name']);
if($im)
   {
   if(file_exists("$pic_1.jpg")) {
      unlink("$pic_1.jpg");
      }
   if (ResizeImage($im,$RESIZEWIDTH,$RESIZEHEIGHT,$FILENAME))
      ImageDestroy ($im);
   }


//now upload the images.....
for ($i=1;$i<5;$i++)
   {
    //check if blank or image

    $xpic="pic".$i;
    if (($$xpic<>"none") and ($$xpic<>"")) {
   
        // check if jpg
        $cert1 = "image/pjpeg"; //jpg
        $cert2 = "image/jpeg"; //jpg (for MAC)
        $xtype =$HTTP_POST_FILES[$xpic]['type'];
      $xsize =$HTTP_POST_FILES[$xpic]['size'];

        if (($xtype <> $cert1) AND ($xtype <> $cert2)) {
         echo "<DIV class=\"errorsubheading\"><br><br>Alert - Missing or Invalid Information</DIV><br>";
         echo "<DIV class=\"requiredtext\">Sorry, uploaded images must be of type jpg or jpeg, (not $xtype).</DIV><BR>";
         echo "<BR><br><br>";
         include ("footer.php");
         exit();
         }
       if ($xsize > $maxfilesize) {
         echo "<DIV class=\"errorsubheading\"><br><br>Alert - Missing or Invalid Information</DIV><br>";
         echo "<DIV class=\"requiredtext\">Sorry, uploaded images must be under the maximum size requirements.</DIV><BR>";
         echo "<BR><br><br>";
         include ("footer.php");
         exit();
         }
         
        else {
         
            // upload to server
            
            $dest=$path."/".$new_filename.".jpg";
            If (move_uploaded_file($$xpic, $dest)) {
               $photo[$i]=$dest;
               $new_filename+=1;
                 }
              else  {
                  echo "<DIV class=\"errorsubheading\"><br><br>Alert - Upload Failed!</DIV><br>";
                  echo "<BR><br><br>";
                  include ("footer.php");
                  exit();
                    } // upload sucessful
         
         } // end type check
      } // end check if blank
   }

 The result pages is supposed to have  pagination like google  help me please

 

I'm using an Upload Script, and I've been working on trying to style the 'Choose File Button' (input file button)

I require a page to be added to my website. This page will facilitate a refined search via Google, Bing and Yahoo search engine simultaneously , show the top 5 of each engine.

Is this possible using php ?

Thank's

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

I have code to search a database of members, I can search by lastname but having a little problem. I want to be able to search by lastname starting with the first letter. (ie:  a or b or c or d and so on). As it is right now I can only search by first letter of last name if I add % to the search (ie: a% b% c%) will give me all members with the last names starting with the approiate letter designation. I'm not sure how to handle this, any help would be appreciated. Thanks.
Code: [Select]
<!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></title>
 
</head>
<body>
<center><table cellspacing="10" cellpadding="10" width="750" border="0">
<h4>Search</h4>
 
<form name="search" method="post" action="<?php $PHP_SELF?>">
Seach for: <input type="text" name="find" /> in <Select NAME="field">

<Option VALUE="lname">Last Name</option>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
 
<?php 
 
// check to see if anything is posted
if (isset($_POST['find'])) {$find = $_POST['find'];}
if (isset($_POST['searching'])) {$searching = $_POST['searching'];}
if (isset($_POST['field'])) {$field = $_POST['field'];}
 
//This is only displayed if they have submitted the form 
if (isset($searching) && $searching=="yes") {
echo "<h4>Results</h4><p>";
// If they did not enter a search term we give them an error
if (empty($find)) {
echo "<p>You forgot to enter a search term"; exit;
}
 
// Otherwise we connect to our Database 
mysql_connect("localhost", "root", "1910") or die(mysql_error());
mysql_select_db("cmc_member") or die(mysql_error());
 
// We preform a bit of filtering 
$find = strtoupper($find);
$find = strip_tags($find); $find = trim ($find); 
 
// Now we search for our search term, in the field the user specified 
$results = mysql_query("SELECT * FROM members WHERE upper($field) LIKE'$find'");
 
// And we display the results 
if($results && mysql_num_rows($results) > 0)
{
    $i = 0;
    $max_columns = 3;
    while($row = mysql_fetch_array($results))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)
          echo "<tr>";

       // make sure we have a valid product ALIGN='CENTER'

       if($fname != "" && $fname != null)
          echo "<td ALIGN='CENTER'><FONT COLOR='red'><b>$fname $lname</b></FONT><br> $address <br> $city $state $zip <br>$phone<br><a href=\"mailto: $email\">$email</a><br></td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
           }  // end if
   } // end while

} // end if results

// clean up table - makes your code valid!
if($i < $max_columns)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";

}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that 
$anymatches = mysql_num_rows($results);
 
if ($anymatches == 0) {
echo "Sorry, but we can not find an entry to match your query<br><br>"; }
 
//And we remind them what they searched for 
echo "<b>Searched For:</b> " .$find;
}
?>
</tr>
</table></center>
</body>
</html>