PHP - Auto Complete Site Search

I have a template written for me on another project that searches a MySQL database.

I'm moving this template to work with a database that only have 10 records in it and instead of having a search option

I would just like it to automatically display the database when the page opens. Is this possible?

The php page in close to 200 lines. This is the line of the code that has the search option. If you need more I can post it.

Thanks
Bob


Code: [Select]

<div id="search">
            <form action="parts.php" method="GET">
            Search: <input type="text" value="'.htmlentities($_GET['s']).'" name="s"/> <input type="submit" value="Search!"/>
           </form>
</div>

$connet = mysql_connect("host", "db_username", "pass") or die(mysql_error());
 
$user = $_SESSION['SESS_FIRST_NAME'];
mysql_select_db('db_name, $connet) or die(mysql_error());

mysql_query("SELECT members Get $earn='earned' WHERE $user='username' LIMIT 1;");
$earn = $total_earn;
?>
<a>$<?php echo "$total_earn";?></a>

I have a search bar that searches my databases for information.  It works perfectly on my site,.  I want to know how to make it modular so that other people can place my search box on their site and get results from my databse without having to give out all my site infomration.

Php search engine for my site

I have a Romanian based language site: http://www.firmelavedere.com with informations about business companies.

I implemented a simple php search engine for my website on pages like this on the top right corner:
http://www.firmelave...aj-Zalau-15.php

I want to add a new radio box field to select language for displayed text.

Is there a possibility to integrate Google Site Search with more languages?
How can i do that?

I need some code suggestions, to make this script run fast.

Thanks all.

Hey there,
wondering if anyone knows what this topic will be about okay lets start:

I have a search function on my site. Basically I do this:

Code: [Select]
if $_POST -> redirect ?search=$_POST

if $_GET['search'] - > sql_query($search);
Of course I am working with functions like
mysql_real_escape_string - addslashes - htmlspecialchars , but I have the following problem:

when redirecting chars like & % ? ! kill my $_GET var.

Which function solves this?

My solution:
I convert every char in $_POST into an ascii code -> redirect ?search=$ascii_codes
convert back into $string and do safe search.

Hi

I have a custom built website with 40 pages or so that I am working on. Its all PHP based.

However it is not on a CMS, it was a static HTML site converted into php with a bunch of include files etc now.

I am keen to add a search facility, however I have no idea how to go about this. I know there are 3rd party paid offerings from Google, but I was wondering if anyone can advise me if its easy to setup without having to pay a 3rd party?

Any advice is greatly appreciated.

hi guys,

i just finished highschool starting to do webdesign at uni, and for one of my major project i want to make a search engine as simple as google that searches for example 10 websites and with the keyword given it brings out the results.

im doing a website on jetski sales results so if someone want to buy a jetski they come to this website and just choose the choose one from those 10 website without going to them individually. so it brings out all search resuts in a nice results format, and when you click on each results it take you to the website but i wanna be able to show their photo and price so just like brings their results into your site but combing 10 website results.

and i need to have an advance search option where they can search year price age of jetski, and all these variables are also in the 10 websites that im getting the results from.

i have been doing some searching and i cant get my head around i need some help LOL i dont wanna fail...

cheers guys

Hi guys, I'm working on a project that handles a lot of inserts into a database and uploads files to FTP. Lets say this is the order:

- Step 1: Insert row into database
- Step 2: Upload files to FTP
- Step 3: Email user to confirm complete

If the user closes the browser soon after Step 1 has complete Step 2 and 3 will not run.

I would prefer if all 3 steps were complete or none at all. What can I do?

Thanks in advance.

//php code
<?php
include_once('con.php');
if(!empty($_GET['search'])) {
$search = $connect->prepare('SELECT * FROM posts WHERE title LIKE :search');
$search->bindValue(':search', '%'.$_GET['search'].'%', PDO::PARAM_STR);
$search->execute();
?>
<?php
while($row = $search->fetch()) {?>
<li class="result" onClick="searchValue('<?php echo $row['title'];?>')"><?php echo $row['title'];?></li>    
<?php } ?>
<?php } ?>

//ajax

$('#inputsch').keyup(function(){
	$.ajax({
	type: 'GET',
	url: 'fetch.php',
	data:'search='+$(this).val(),
	success: function(data){
		$('#box').show();
		$('#box').html(data);
	}
	});
}); 
});
function searchValue(val) {
$('#inputsch').val(val);
$('#box').hide();
}


//search box

 <form action="search.php">
 <input id="inputsch" type="text" name="search" placeholder="search..." autocomplete="off" autofocus>
 <button type="submit" value="search" >search</button> 
 </form>
 <div id="box"></div>


//the problem here is when i click the result is only added to input, but i want it to autosubmit

 

So a project I have simply to learn how it is done is to make an auto updating sitemap with a auto submitter. I have been doing a little research on sitemaps but haven't found much in the way of a tutorial or white paper or similar, anyway I was wondering if I am on the right track or not.

What I was thinking for the auto-updating sitemap is since site maps are XML, when an article is published using my custom CMS/Blogging system, I make it rewrite the sitemap appending the new URL that will be generated.

Then for the auto-submit, I can either make it a cron job or just manual press, but it would go though a for list of URLs, replacing the end part with my site map url. I think that is how it would be done.

If you have a better idea, or can point out an article so I can understand a lot more with sitemaps, I will appreciate it, I am trying to learn as much as possible, I have gone to the offical website (sitemaps.org) but it doesn't have what I am looking for.

Thanks,

James

Hi,
Basically I just downloaded wamp and got php and mysql etc.
I created a database for my "new social network to-be site" which I am trying to develop.. now I want to create a registration page and am trying to follow a guide on another website.. it lets you download a zip with all the php files required.

So now, I am totally confused.
Here is the guide: http://www.html-form-guide.com/php-form/php-registration-form.html
But I dont know what to do with any file or where to put it.. any basic help..

Just to confirm I want to make a login/registration/user database type thing

Browser HTTP client makes a request to a HTTP web server which makes a HTTP cURL request to a HTTP REST API which initiates a ReactPHP socket client to make a request to a socket server, and the socket server script eventually execute the following method:

    public function executeSpecificRequestCommand(array $data):bool {
        $status = $this->doSomething($data);
        return $status; //{success: $status} will be returned to the socket client
    }

All is good until doSomething()  takes a lot of time and results in a cURL error between the HTTP web server and HTTP REST API.  For this particular case, the task isn't meant to provide immediate feedback to the user, but to do some work and update the database, and as such, my desire is to return true status and then perform the work instead of extending the cURL timeout.

One option is to ran some process in the background and return status, but I don't think doing so is really right.  Using a queue seems excessive as I am already decoupled via the socket.  As such, I will probably just add some logic between the initial $string->on('data') and this executeSpecificRequestCommand() method to determine whether the success message should be returned before or after the method is complete.

Before doing so, however, I would like to know if there is a more appropriate approach to this scenario.  It appears that maybe a child process or a deferred might be appropriate, but am not sure whether I am going down the wrong path.

Hi. I'm currently taking a class in PhP and I'm having issues getting my code to work. I "borrowed" part of the code from elsewhere (but I fully understand each line - which is really the point of learning) I'm hoping a second set of eyes might help on what's wrong:

I'm running Wamp Server v2.0 on my local PC to test the scripts... I'm sure I'm probably going to have more then just this error with the script, but it's hard to move forward when you're stuck spinning your wheels. Any help would be greatly appreciated... and any suggestions as to a better way to approach this would be welcome as well. I am here to learn after all

Here's the error I'm getting:

Notice: Undefined variable: fname in C:\Web Server\wamp\www\daystoxmas.php on line 8
Please return to the main page and enter your First Name.

Here's the HTML 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"
 xml:lang="en" lang="en">

<head>
   <meta http-equiv="Content-Type"
    content="text/html; charset=utf-8"/>

<title>Days to Christmas Form</title>

</head>
<body>

<div><p><h1>Days to Christmas Form</h1></p>
<p>- Programmed by: Michael Custance</p>

<form action="daystoxmas.php" method="post">

   <p>First Name: </select><input type="text" name="fname" size="20" /></p>
   <p>Last Name: </select><input type="text" name="lname" size="20" /></p>
   <p>E-mail Address: <input type="text" name="email" size=20 /></p>
   For Christmas gift ideas, click here!
   <input type="submit" name="Submit" value="Christmas Gift Page" />

</form>
</body>
</html>

And here's the PhP Form:

<HTML>
<HEAD>
<TITLE>daystoxmas.php</TITLE></HEAD>
<BODY>

<?php
   if ($fname)
     {
      print ("Good ");
      if (date("A") == "AM")
        {
         print ("morning, ");
        }
      elseif ( (date("H") >= 12 ) and (date("H") < 18) )
        {
         print ("afternoon, ");
        }
         else
        {
         print ("evening, ");
        }
         print ("$FirstName<P>");

         $Christmas = mktime(0, 0, 0, 12, 25, date('Y'));
           $today = mktime();
             $seconds_to_christmas = $Christmas - $today;
               $days_to_christmas = $seconds_to_christmas / 86400;
               $days_to_christmas = floor($days_to_christmas);
                 $temp_remainder = $seconds_to_christmas - ($days_to_christmas * 86400);
                   $hours = floor($temp_remainder / 3600);
                 $temp_remainder = $temp_remainder - ($hours * 3600);
                     $minutes = round($temp_remainder / 60, 0);
         echo '<p>There is ' . $days_to_christmas . ' days and ' .
               $hours . ' hours and ' . $minutes .
               ' minutes until Christmas</p>';
     }
      else
     {
      print ("Please return to the main page and enter your First Name.");
     }
?>


</BODY>
</HTML>

can anybody tell me how i can complete this function in php?





// $page = html source file

define("LIST_OF_SCHOOLS", "Piarsaigh,Phiarsaigh,Vincents");

$schoolList = explode(',', LIST_OF_SCHOOLS);

function checkForSchool($page, $schoolList) {
   preg_match('|Goes to \\\u003ca href=\\\\"http:\\\/\\\/www.facebook.com\\\/pages\\\/[a-zA-Z-]*\\\/\d*\\\\" data-hovercard=\\\\"\\\/ajax\\\/hovercard\\\/page.php\?[a-zA-Z=0-9]*\\\\">([a-zA-Z\s]*)\\\u003c\\\/a>|', $page, $match);
    if($match && count($match)>0) {
        echo "Match Found";

// if any of the words in the schoolList array is found in the match from the preg_match function let the 
// checkForSchool function return true
// other wise return false

    }

}

}

Hi guys,

Please can anyone help me with a simple bit of PHP. I'm just starting out, so its all a bit confussing to me. Basically I need a bit of
code that does something like this:

My end user types in a password on a form on the html page.

The pasword is checked by the php page.

If pasword is correct the user gets sent to another page within my site.

If pasword is incorrect the user gets sent to an error page within my site.


I know this is real simple stuff, but as i said i'm realy new to this, hope some one can help.

Cheers People.