, Guest!
Already a Member? Login or Register.



Due to the volume of spam happening on our forums, posting is now restricted to verified members only.  If you're not verified, drop us a note with your username.

Home > FlexCMS Support Forum > User Help > General Support Requests > Searchable directory?

FlexCMS Support Forum

Searchable directory?
Started July 6, 2008 @ 8:14am by cbc58
Post Message 

Posts: 15
Searchable directory?July 6, 2008 @ 8:14am
Is it possible to set up a searchable directory of members by state, city and/or zipcode or other fields?

Posts: 625
July 6, 2008 @ 4:44pm
That should be possible and not overly complicated. Everything you'll need should be located in the core-Users table.

If only you wanted to search through users for a specific purpose, you could use something like PHPMyAdmin to just access that database table and run searches on it based on your own criteria. For visitors to your site to access that, you could modify the code in the inc-core-admin-users.php file.


FlexCMS v3.2 Has Been Released!

Posts: 65
July 12, 2008 @ 11:55pm
I did something similar to that in one of my Flex applications. I disabled fields in the users record so the user doesn't see the data when editing the record, but can see it in a query.

1. Made a regular flex page
2. Added this code
3. Set to process php code
4. Display the page


$message = "";
if (!isset($block)){
$message = "List neighborhood watch block houses [home = block 23].";
} elseif ($block < 1){
$message = "Error: block number [$block] cannot be less than 1";
} elseif ($block >100){
$message = "Erorr: block number [$block] cannot be greater than 100";
} else {
$message = "Searching for BLOCK NUMBER [$block]";

print '<div>MainURL=['.$MainURL.']</div>';

<form action="<?php print $MainURL; ?>/pages/test_block_query.html" method="POST">
Type block number here: <input type="text" name="block">

$query55="SELECT * FROM `"."core-Users` WHERE Custom2 = "."\"Block $block\" order by `Custom1` asc, `Address2` asc, `Address1` asc";

print '<div>MainURL=['.$MainURL.']</div>';
print '<div><b>'.$message.'</b><br><br></div>';
print '<div>'.$query55.'</div>';

$result55 = mysql_query($query55) or die (mysql_error());

if (mysql_num_rows($result55) > 0)
print '<div>mysql_num_rows = '.mysql_num_rows($result55).'</div><br>';

while ($row55 = mysql_fetch_array($result55))
print $row55['Custom1'] .', ';
print $row55['Custom2'] .', ';
print $row55['Address1'] .' ';
print $row55['Address2'] .' ';
print $row55['Address3'] .', ';

print $row55['FirstName'] .' ';
print $row55['LastName'] .', ';
print $row55['Email'] .', ';
print $row55['Phone'] .'<br>';

$row55_custom1 = $row55['Custom1']; // save section number

Hope it gets you started!

Would love to see your code when you finish.Smile


Post Message 

Try & Buy FeedForAll - Easy to use RSS Feed Creator - great for iTunes users!


All Contents, Code, Scripts and Technologies Copyright 2003-2009 FlexCMS.
All Rights Reserved. Software License Agreement

Processing Time: 0.07744 seconds.
Management Login

Powered By FlexCMS
Powered By FlexCMS