Search result for add more fields script

muzaffar · June 18, 2013

1. How do i made recordset for add more fields script so that users can update later also
2. This code is related to Parent adding family details(add more fields script is used) and much more like simple matrimony site.
Example,My name is jone and i have three children ie jone1 (Age:25,Gender:male,status:divorced),jone2
(Age:18,Gender:female,status:unmarried),jone3 (Age:30,Gender:male,status:separated).If user search country:japan,Age:25,Gender:male,status:divorced then use get the result for only jone1 row(add more fields
script) and jone2 + jone3 does not be show in result.Keeping headname,native,country,state of parent default execute.

I put all the detail in server .Please refer to this link and if you have any solution tell me or you can give me hint also. http://caringhandsrehab.in/addmore/index.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head
<body>
<form method="post" action="" name="form1" id="form1" >
<select name="search_gender" id="search_gender" required >
<option value="" selected="selected">Looking for</option>
<option value="male">male</option>
<option value="female">female</option>
</select>
<select name="search_from" id="search_from" required>
<option value="" selected >Age from</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
</select>
<select name="search_to" id="search_to" required>
<option value="" selected>Age to</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
</select>
<select name="search_status" id="search_status" required>
<option value="" selected="selected">Marital Status</option>
<option value="unmarried">Unmarried</option>
<option value="widow">Widow/Widower</option>
</select>
<select onchange="print_offstate('offstate',this.selectedIndex);" id="offcountry" name ="offcountry" required> </select>
<select name ="offstate" id ="offstate" required></select>
<script language="javascript">print_offcountry("offcountry");</script>

<input type="submit" name="doSearch" id="doSearch2" value="Search" />
</form>
<table width="960" border="1" cellspacing="0" cellpadding="4">
<tr>
<td width="50" bgcolor="#CCCCCC"><strong>ID</strong></td>
<td width="150" bgcolor="#CCCCCC"><strong>Head name</strong></td>
<td width="100" bgcolor="#CCCCCC"><strong>Native place</strong></td>
<td width="150" bgcolor="#CCCCCC"><strong>Name</strong></td>
<td width="60" bgcolor="#CCCCCC"><strong>Gender</strong></td>
<td width="75" bgcolor="#CCCCCC"><strong>Birthdate</strong></td>
<td width="30" bgcolor="#CCCCCC"><strong>Age</strong></td>
<td width="95" bgcolor="#CCCCCC"><strong>Relation</strong></td>
<td width="125" bgcolor="#CCCCCC"><strong>Education</strong></td>
<td width="75" bgcolor="#CCCCCC"><strong>Status</strong></td>
<td width="50" bgcolor="#CCCCCC"><strong>Detail</strong></td>
</tr>
<?php
$doSearch = $_GET['doSearch'];
if($_REQUEST["search_gender"] <>'' && $_REQUEST["search_from"] <>'' && $_REQUEST["search_to"] <>'' && $_REQUEST["search_status"] <>'' && $_REQUEST["offcountry"] <>'' && $_REQUEST["offstate"] <>'') {
$sql = "select * from users u LEFT JOIN web w on (w.id = u.id) WHERE MATCH(id,full_name,native,country,state) AGAINST('%$doSearch%' IN BOOLEAN MODE) "; }
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
if (mysql_num_rows($sql_result)>0) {
while ($row = mysql_fetch_assoc($sql_result)) {
?>
<tr>
<td><?php echo $row["id"]; ?></td>
<td><?php echo $row["full_name"]; ?></td>
<td><?php echo $row["native"]; ?></td>
<td><?php echo $row["dynname"]; ?></td>
<td><?php echo $row["dyngender"]; ?></td>
<td><?php echo $row["dyndob"]; ?></td>
<td><?php echo $row["dynage"]; ?></td>
<td><?php echo $row["dynrelation"]; ?></td>
<td><?php echo $row["dyneducation"]; ?></td>
<td><?php echo $row["dynstatus"]; ?></td>
<td><?php echo '?id='. $row['id']; ?> </td>
</tr>
<?php
}
} else {
?>
<tr><td colspan="5">No results found.</td>
<?php
}
?>
</table>
</body>
</html>

Sign In

Search result for add more fields script

Recommended Posts

muzaffar

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information