QuerifyPHP

querifyphpについて

クエリをより速く簡単にするPHPライブラリ。

はじめる

 // Include the file in your project
include ' querify.php ' ;

// Create an object
$ querify = new Querify ();

// Create a database
$ database = $ querify -> CreateDB ( " databaseName " );

//Connect to database
$ querify -> connect ( $ servername , $ username , $ password , $ database );

データのインポート

 $ querify -> Import ( $ servername , $ username , $ password , $ database , $ sqlfile );

データの選択

 //assign a variable to store the array returned 
$ results = $ querify -> SelectAll ( $ tablename );

//loop and display the data from the array
foreach ( $ results as $ results )
{
	echo $ result [ ' columnName ' ];

}

データの挿入

 // create an array with table column names as array keys and user inputs as array values

$ data = array 
(
	' columnName ' => $ _POST [ ' data ' ],
	' columnName ' => $ _POST [ ' data ' ],
	' columnName ' => $ _POST [ ' data ' ]

);
// pass the values of the tablename and array in the parameter
$ querify -> Insert ( $ tablename , $ data );

データの検索

 //assign a variable to store the array returned 
$ results = $ querify -> Search ( $ tablename , $ column , $ id );

//loop and display the data from the array
foreach ( $ results as $ results )
{
	echo $ result [ ' columnName ' ];

}

データの更新

 // create an array with table column names as array keys and user inputs as array values
$ fields = array
(
	' columnName ' => $ _POST [ ' data ' ],
	' columnName ' => $ _POST [ ' data ' ],
)
// create an array with table column names as array keys and condition value as array values

$ condition = array 
(
	' columnName ' => $ _POST [ ' data ' ];

)

//pass the variables into the update method
$ querify-> Update ( $ tablename , $ fields , $ condition );

データの削除

 //pass the values of the tablename and row id in the parameter
$ querify -> Delete ( $ tablename , $ id );