PHP - Wordpress Search Tweaks

Looking for some technical assistance on a property search query im having some problems with on WP.

Using the Agentpress theme I have put together a client site that is fully functional, however the client has asked that the search is altered is altered slightly and i'm having trouble working out how to do it.

I'm not a database / PHP person - I have managed so far, but this is beyond my understanding.

I have 2 separate search query issues.

The first is that my client wants the bedrooms to be searchable with the following options:

1 or more
2 or more
3 or more
4 or more

The second is that they want the availability of the property to only give 2 options:

Availabile properties only
Include Let Agreed

Here is the site: test.taylorslettings.co.uk

The property data and field names I have are being automatically created by their system and provides the information in the dropdowns as you see it in the search box on the site. The theme (Agentpress) dictates the search and how it works at present.

I have no idea how to alter the search so it shows presents the results to meet the clients needs.

We are at the very end stages of going live, so any urgent help would be gratefully appreciated.

Thanks very much.

This topic has been moved to PHP Applications.

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

I have a form which submits to a MySQL DB. There is validation in place so that all fields are required, and the form won't submit until the fields are filled in correctly and then submits. Everything works fine as far as the validation and submitting. A few tweaks, I would like to make are...
1) When you submit the form and there are validation errors, the info that was filled in correctly is wiped out. I would like the correct fields to stay intact so that say one field was not filled in or filled in correctly then the user wouldn't have to fill in all the fields all over again.

2) Currently after the user fills in their name, if the username is already taken, they get an error on the page "Error: Duplicate entry 'Bruce.Gilbert' for key 'usr'". This appears to be a built in MySQL function. The form dies not show at this point, even if you refresh the page. I would like the form to still display with the values intact if there is a duplicate entry is the Username field.

Here is the pertenant code.


<?PHP
require_once "formvalidator.php";
$show_form=true;
if(isset($_POST['Submit']))
{
   $validator = new FormValidator();
    $validator->addValidation("FirstName","req","Please fill in FirstName");
$validator->addValidation("LastName","req","Please fill in LastName");
$validator->addValidation("UserName","req","Please fill in UserName");
$validator->addValidation("Password","req","Please fill in a Password");
$validator->addValidation("Password2","req","Please re-enter your password");
$validator->addValidation("Password2","eqelmnt=Password","Your passwords do not match!");
    $validator->addValidation("email","email","The input for Email should be a valid email value");
    $validator->addValidation("email","req","Please fill in Email");
$validator->addValidation("Zip","req","Please fill in your Zip Code");
$validator->addValidation("Security","req","Please fill in your Security Question");
    if($validator->ValidateForm())
    {
        $con = mysql_connect("localhost","uname","pw") or die('Could not connect: ' . mysql_error());

mysql_select_db("DBName") or die(mysql_error());





$FirstName=mysql_real_escape_string($_POST['FirstName']); //This value has to be the same as in the HTML form file

$LastName=mysql_real_escape_string($_POST['LastName']); //This value has to be the same as in the HTML form file

$UserName=mysql_real_escape_string($_POST['UserName']); //This value has to be the same as in the HTML form file

$Password= md5($_POST['Password']); //This value has to be the same as in the HTML form file

$Password2= md5($_POST['Password2']); //This value has to be the same as in the HTML form file

$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file

$Zip=mysql_real_escape_string($_POST['Zip']); //This value has to be the same as in the HTML form file

$Birthday=mysql_real_escape_string($_POST['Birthday']); //This value has to be the same as in the HTML form file

$Security=mysql_real_escape_string($_POST['Security']); //This value has to be the same as in the HTML form file



$sql="INSERT INTO Profile (`FirstName`,`LastName`,`Username`,`Password`,`Password2`,`email`,`Zip`,`Birthday`,`Security`) VALUES ('$FirstName','$LastName','$UserName','$Password','$Password2','$email','$Zip','$Birthday','$Security')"; 

if (!mysql_query($sql,$con)) {

 die('Error: ' . mysql_error());

}



else{



mail('email@gmail.com','A profile has been submitted!',$FirstName.' has submitted their profile',$body);

echo "<h3>Your profile information has been submitted successfully.</h3>";

echo "<p>You may now <a href='login.php'>login</a></p>";



}

mysql_close($con);

        $show_form=false;
    }
    else
    {
        echo "<h3 class='ErrorTitle'>Validation Errors:</h3>";

        $error_hash = $validator->GetErrors();
        foreach($error_hash as $inpname => $inp_err)
        {
            echo "<p class='errors'>$inpname : $inp_err</p>\n";
        }        
    }
}

if(true == $show_form)
{
?>

<form name="test" id="ContactForm" method="POST" action="" accept-charset="UTF-8">
<fieldset>

               <div class='normal_field'><label for="FirstName">First Name</label></div>
               <div class='element_label'>
                
                  <input type='text' name='FirstName' size='20'>
               </div>
            
           
               <div class='normal_field'><label for="LastName">Last Name</label></div>
               <div class='element_label'>
                  <input type='text' name='LastName' size='20'>
               </div>
           
           </fieldset>
           <fieldset>
               <div class='normal_field'><label for="UserName">User Name</label></div>
               <div class='element_label'>
                  <input type='text' name='UserName' size='20'>
               </div>
           
            
               <div class='normal_field'><label for="Password">Password</label></div>
               <div class='element_label'>
                  <input type='password' name='Password' size='20'>
               </div>
               <div class='normal_field'><label for="Password2">Re-Enter Password</label></div>
               <div class='element_label'>
                  <input type='password' name='Password2' size='20'>
               </div>
            
           
               <div class='normal_field'><label for="Email">Email</label></div>
               <div class='element_label'>
                  <input type='text' name='email' size='20'>
               </div>
            </fieldset>
            <fieldset>
          
               <div class='normal_field'><label for="Zip">Zip Code</label></div>
               <div class='element_label'>
                  <input type='text' name='Zip' size='20'>
               </div>
            
            
               <div class='normal_field'><label for="Birthday">Birthday(mm/dd/yyyy format)</label></div>
               <div class='element_label'>
                  <input type='text' name='Birthday' size='20'>
               </div>
           
           
            
               <div class='normal_field'><label for="Security">Security Question</label></div>
               <div class='element_label'>
                  <input type='text' name='Security' size='20'>
               </div>
               </fieldset>
               <div id="agree">
                 <label for="tos">
                 <input type="checkbox" id="tos" name="tos" value="yes" />
                 I have read and agree to the <a href="ajax/serviceterms.html" id="terms">Terms of Service</a>.
                 </label>
                </div>
         <fieldset>
           <div id="service-terms" class="box rounded-all"></div>
                
                <div class="controls">
                    <input id="submit" type="submit" name="Submit" value="CREATE PROFILE"/>
                </div>
                </fieldset>
         

</form>
<?PHP
}//true == $show_form
?>

Hello

I've got a php script that generates random number every page refresh

Code: [Select]
<?php
srand ((double) microtime( )*1000000);
$random_number = rand(1000,5000);
echo "$random_number";
?>
I would like some advanced things...

first of all i don't want the random number to be generated every page refresh
I would like something like... based on pc hour

example:

- between 12 AM and 5 AM it will generate a number from 500 to 1000 randomly but the number should change also to a determined time i set such as every 5 minutes and not everytime i refresh the website page
- betweem 5 AM -  2 PM will generate a number from 3500 to 8000 and this number will change every 5 minutes too with one that exists between this interval
- and so on


Would appreciate if someone could help me with that


Thanks in advance

I have a php tutorial that I followed for creating, inserting, selecting and updating a MySQL database with php.  Everything works fine so I wanted to put it into Wordpress.  I took the code and placed it into the wordpress page and everything worked just fine except the update function. 

Here is the tutorial I used. http://www.phpsimple.net/mysql_insert_record.html  It is also the part I am having trouble with.  I am able to create a record and I am also able to select a record but when I choose "update" the form doesn't load the data.  It will outside the website but not inside wordpress.  I am hoping this is not vague but because of my inexperience I am not sure what else to say.  I will be more than happy to provide any other information you need.