PHP - Moved: Search For <a Href="

Hey guys, I'm looking for some sort of tutorial on how to code a search script which would allow users to select number of results per page (and take care of the page 1, page 2, etc. links accordingly) as well as order them by date, most views, etc.

I thought I'd be good to do this on my own but my script is looking very dirty and I'm pretty sure it isn't very secure.. anyone ever consult a tutorial with main guidance as how to code the kind of script I'm interested in??

thanks

This topic has been moved to HTML Help.

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

Hi everyone!! I just started learning PHP two weeks ago and I hope someone can help me!!
I need to do a find and replace on a string, and each replace needs to have an unique id, and if that unique id exists in a table then return the value on the table. Make sense?

So like "find all the Xs in the string, replace with "X1, X2, X3...", then if "X3' exists on TableB, return value "X3 is on the table and has a value of Y3".

I actually got this to work already but it takes a long time to do it so I'm hoping someone could give me some advice on how to make it more EFFICIENT:



// PART ONE, find all "X" and replace with unique_id

for ($count = 1; $count <= strlen($string); $count++) // do this loop as many times as there are characters in $string
{
$unique_id = "replacement_" . $count; // give each replacement an unique id (replacement_1, replacement_2, replacement_3, etc..)
$string = preg_replace("X", $unique_id, $string , 1); // find X and replace it with the $unique_id in $string, and only do this ONCE
} 
$count_replacements = substr_count($string,"replacement_"); // count how many replacements occured in total


// PART TWO, find all unique_ids in tableB and echo the unique_id_value

for ($count = 1; $count <= $count_replacements; $count++) // do this loop as many times as there were replacements
{
$unique_id  = "replacement_" . $count; // set the unique_id of each replacement


$show_tableB = mysqli_query($link, 'SELECT * FROM tableB');      // select  the unique_ids and the unique_id_values in TableB
while ($row = mysqli_fetch_array($show_tableB)) { $tableBs[] = array('unique_id' => $row['unique_id'], 'unique_id_value' => $row['unique_id_value']);  }    

foreach($tableBs as $tableB): // for each entry in TableB, if the unique_id in TableB matches the unique_id of the replacement, return the unique_id_value
if ($tableB['unique_id'] == $unique_id) 
{ echo $unique_id . " is on TableB and it has a value of ". $tableB['unique_id_value'] }
endforeach;

}



The problem with this is: its not very efficient.
If $string has 500 charachters, it does the "PART ONE" 500 times. Then, say it found 300 Xs, it does "PART TWO" 300 more times. And every time it does "PART TWO", it checks all entries in TableB (which could be 200 or more).

So, that's it. Anyone has a better idea of how to do this??

Thanks!!!!

I have a script which queries a database and displays the relevant information.  However, to query the database I currently have to manually edit the URL.  Now I am trying to develop into a search form.

On the homepage I have a form which enters into "searchterm".    But I am but confused as to what I do with the "searchterm", can anyone advise how I can transfer the "searchterm" as the term which queries the database?

Code: [Select]
<input  type="text" name="searchterm" class="homepagesearch" > 

This is the code which queries and displays the query:

Code: [Select]


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


$query = "SELECT * FROM questions";

if(isset($_GET['question']))
{
/*query the database*/
$question = $_GET['question'];
$query .= " WHERE question like '%$question%' LIMIT 0, 10";
}

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$question = $row['question'];
$notes = $row['notes'];

echo "$question
$notes  </br>";
}

if ($_GET['question'] == $question ) {
echo 'Sorry, this product is not available.  Please visit our <a href="http://www.domain.co.uk">Homepage</a>.';
}

This topic has been moved to Ajax Help.

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

This topic has been moved to PHP Regex.

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

Can someone please help me with an array problem i can not figure out.

I need the array to be numbered from 1 to how ever many fields that are needed in the form and have a mysql field name and the title of the field also in the array.

1, "mysql_field_name", "Title of form field"
2, "", ""

and so on

then the form will be shown based on the array.

I have the following draft code which I am working with.

any suggestions on how i may do this array ?

Code: [Select]
<?php
$options = array(
'1'=> array('fieldtext'=>'option1', 'mysqlfield'=>'option1'),
'2'=> array('fieldtext'=>'option2', 'mysqlfield'=>'option2'),
'3'=> array('fieldtext'=>'option3', 'mysqlfield'=>'option3'),
'4'=> array('fieldtext'=>'option4', 'mysqlfield'=>'option4'),
);


// $options = array(1 => "option1", "option2", "option3", "option4");

// the line above works but i want to include the name of the mysql field as well.

$userid = 1;

?>
<div style="align: center; margin: 12px; font-family:Tahoma;">
<br><br><?php
if ($_POST['Update'] != "Update") { // check if form submitted yet, if not get data from mysql.
$res = db_query("SELECT * FROM `users` WHERE `userid` = '" . $userid . "'");
foreach($options as $key => $value) { $_POST[$key] = mysql_result($res, 0, $value); }
$ok_to_update = "no";
} elseif ($_POST['Update'] == "Update") { // check if form submitted yet, if so get POST data.
// error checking
// foreach($options as $key => $value) {
// $_POST[$i] = "";
// }
$ok_to_update = "yes";
}

if ($_POST['Update'] == "Update" && $ok_to_update == "yes") {
// $res = db_query("INSERT INTO `users` () VALUES ()"); // add user details to database.
?><p><br><br><br>Thank you for updating</p><?php
} else {
?><form name="form1" method="post" action="">
<?php foreach($options as $key => $value) {
?><p><?php echo($value); ?>:&nbsp;<input type="text" name="<?php echo($key); ?>" value="<?php echo($_POST[$key]);?>"></p>
<?php } ?>
<input name="Update" type="submit" value="Update">
</form>
<?php } ?>
</div>

This topic has been moved to PHP Applications.

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

This topic has been moved to Application Design.

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

This topic has been moved to Miscellaneous.

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

This topic has been moved to PHP Regex.

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

This topic has been moved to PHP Regex.

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

This topic has been moved to HTML Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to Third Party PHP Scripts.

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