yasql/yasql

yasql is mysql library using php language

yasql

yasql is mysql library using php language, _(*1)

How to use yasql?

Step 1 : Create yasql object

$object_name=new yasql();, _(*2)

br/, _(*3)

Step 2 : Call function using object name

List of functions:

1 . insert query

Usage: , _(*4)

$object_name->insert($table,$values);
returns 1 if query successfully executed else display error
example:
$response=$object_name->insert("table_name"," col1 = 'abc' , col2 = '10'");, _(*5)

2. update query

Usage:, _(*6)

$object_name->update($table,$updation,$condition);
returns 1 if query successfully executed else display error
example:
$response=$object_name->update("table_name" , " col1 = 'abcd' " , "col2>10");
$response=$object_name->update("table_name" , " col1 = 'abcde' " , "1"); to update all rows, _(*7)

3 . delete query

Usage: , _(*8)

$object_name->delete($table,$condition);
returns 1 if query successfully executed else display error
example:
$response=$object_name->delete("table_name"," col1 > '10' ");
$response=$object_name->delete("table_name","1"); to delete all rows, _(*9)

4 . select rows

Usage: , _(*10)

$object_name->select_rows($column,$table,$condition);
returns resultset if query successfully executed else display error
example:
$response=$object_name->select_rows("col1","table_name"," col1 > '10' ");
$response=$object_name->select_rows("*","table_name"," col1 > '10' "); to fetch all columns, _(*11)

5 . select count of rows

Usage: , _(*12)

$object_name->select_count($column,$table,$condition);
returns resultset if query successfully executed else display error
example:
$response=$object_name->select_count("","table_name"," col1 > '10' ");
$response=$object_name->select_rows("","table_name"," 1 "); to count all rows, _(*13)

6 . select sum of rows

Usage: , _(*14)

$object_name->select_sum($column,$table,$condition);
returns resultset if query successfully executed else display error
example:
$response=$object_name->select_sum("col1","table_name"," col1 > '10' ");
$response=$object_name->select_rows("col1","table_name"," 1 "); to sum all rows, _(*15)

7 . select average of rows

Usage: , _(*16)

$object_name->select_avg($column,$table,$condition);
returns resultset if query successfully executed else display error
example:
$response=$object_name->select_sum("col1","table_name"," col1 > '10' ");
$response=$object_name->select_rows("col1","table_name"," 1 "); to average all rows, _(*17)

8 . select minimum value from a row

Usage: , _(*18)

$object_name->select_min($column,$table,$condition);
returns resultset if query successfully executed else display error
example:
$response=$object_name->select_min("col1","table_name"," 1 ");, _(*19)

9 . select maximum value from a row

Usage: , _(*20)

$object_name->select_max($column,$table,$condition);
returns resultset if query successfully executed else display error
example:
$response=$object_name->select_max("col1","table_name"," 1 ");, _(*21)