data search

  • spiritualight

    (@spiritualight)


    16 years, 7 months ago

    Hi

    Does anyone know of a plugin that would allow my blog members to search a database of names that I input myself.

    So for example: I would input details of each person in my directory like
    Name
    Age
    Etc

    and then my members could search using the Name fields. The names in my database wouldnt necessarily be members of my blog, but their names would be searchable by members of my blog, if that makes sense! lol

    Any help or suggestions would be greatly appreciated.

    I should also add that I would like the search function to search only the data I have inputted rather than posts or pages. 🙂

    Any Ideas?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter spiritualight

    (@spiritualight)

    16 years, 7 months ago

    I dont seem to get any replies on my posts here! 🙁

    cogmios

    (@cogmios)

    16 years, 7 months ago

    Just download any php addressbook mysql application, install it and then either use an iframe to load it into a wp page or use wp-exec as plugin to query the db directly e.g. for searches or other things.

    So: download XAMP , create a mysql db, create the db at your host, export/import the data and then create a WP page queering it:

    ini_set('display_errors',0);
error_reporting(E_ALL|E_STRICT);
$dbname = 'YOURDBNAME';

$mysql_link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die (mysql_error() . 'Error connecting to mysql');
mysql_select_db($dbname, $mysql_link) or die (mysql_error() . 'problem connecting with database');
$sql ="SELECT * from names";
$result = mysql_query($sql, $mysql_link) or die('Failed Query of '. $sql . ' ' . mysql_error());

    you can now use e.g.

    while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<tr>";
echo "<TD>$i</TD>";
echo "<TD>{$row['NAME']}</td>";
echo "<TD>{$row['PRODUCT']}</td>";
echo "</tr>";
}

    to walk through your db and display it.

    don’t forget to change the db back if you query the wp db e.g. if you further down query it for categories:

    <?php
mysql_select_db(DB_NAME, $mysql_link) or die (mysql_error() . 'problem connecting with database');
wp_list_categories('sort_column=name&number=10&title_li=&depth=10');
?>

    Pretty easy. So start by downloading XAMP and then read the XAMP documentation on how to use phpmyadmin to create the database, fill it and export it.

    cheers!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘data search’ is closed to new replies.