Searching MySQL data

[mas_ab]

Hi all,

I'm a new member here  and I have some questions about building a database (MySQL) search engine using AMFPHP.
I know how to display MySQL data in a datagrid (thanks to Jorge's tutorials  ) but I have no clue about searching data.

Q:
- How do I send a query to my database (using a  textinput comp.)  and then display the result in a datagrid?

A: ... ?

TIA,
--
Anggie Bratadinata
I N D O N E S I A

[Jorge Solis]

Hi mas_ab, welcome to the Boards !

You need to pass a parameter to your amfphp method and use it in " WHERE ..." part of your query. Display in a datagrid have not change (is the same as using a select)

Jorge

[elchea23]

Q : first play flash application  I want to display all record in grid then I want only curent record to dispaly.
      what a parameter after " where "  condition must be follow;
 
select * from city where nmcity=  $x

what is parameter of  "$x"

please help me???


From Indonesia

[Jorge Solis]

Sorry, don't understand your question, try to ellaborate.

Jorge

[elchea23]

the table ---->city
I want flash first running (load) ----> show all record to the datagrid.
after that i want search a record in the text box and show in the same Datagrid.

i am use remoting(AMFPHP).

i want only a function php  query to show two  before process...

what is a syntax???.....Please

From
Indonesia


 

[Jorge Solis]

<?php
class search{

function search(){

$this->methodTable = array(

"searchRow" => array(

"description" => "Sear a row",

"access" => "remote", // available values are private, public, remote

"arguments" => array ("key")

)

);

}

function searchRow($key){
                        $result = mysql_query("select from mytable where columnToSearch='$key'")

return $result;

}
}
?>

This should be a method thart you add to the class, in my example I write a class with this only method. Replace mytable with the name of your table and columnToSearch with the column you want to filter.

Jorge