Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $MySQLPassword = "indian";
- $HostName = "localhost";
- $UserName = "monty";
- mysql_connect($HostName,$UserName,$MySQLPassword)
- or die("ERROR: Could not connect to database!");
- mysql_select_db("sachin") or die("cannot select db");
- $keyword = $_POST['keyword'];
- echo $keyword;
- /* Execute the query that performs the actual search in the DB: */
- $result = mysql_query(" SELECT p.page_url AS url,
- COUNT(*) AS occurrences
- FROM page p, word w, occurrence o
- WHERE p.page_id = o.page_id AND
- w.word_id = o.word_id AND
- w.word_word = "$keyword"
- GROUP BY p.page_id
- ORDER BY occurrences DESC
- " );
- $output = new DOMDocument();
- $output->formatOutput = true;
- $output = "<loginsuccess>";
- for( $i = 1; $row = mysql_fetch_array($result); $i++ ) {
- $output .="<person><keyword>".$_POST['keyword']."</keyword><name>".$row['url']."</name><occur>".$row['occurrences']."</occur></person>";
- }
- $output .= "</loginsuccess>";
- print ($output);
- ?>
- $handle = fopen($filename , "wb")
Add Comment
Please, Sign In to add comment