Home > Developer > PHP

Share a self-written php class for mysql database operations

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
Share a self-written php class for mysql database operations
This is a Class I wrote by myself. You are welcome to discuss and guide it.
Some usage methods:
// Declare the database object
$ Conn = new Mysql;
// Load database parameters
$ Conn-> Parameter (database server, database username, database password, database name, database code, database table prefix [can be blank]);

The above code has loaded this class file and initialized some database connection parameters!
The following describes several basic methods and functions:
1. $ Conn-> Table ();
Select a data table. the parameter is the data table name.
2. $ Conn-> Field ();
Names of the selected fields separated by commas (,). if this method is not called, all fields are returned.
3. $ Conn-> Where ();
SQL Where substatement, filtering by conditions
4. $ Conn-> Order ();
SQL sorting
5. $ Conn-> Page (int );
The parameter is a positive integer. if you call this method, the record is displayed on pages.
6. $ Conn-> Select (Boolean );
Execute the query and return the query result. If yes, it is a two-dimensional array. If no, it returns false. the parameter can be omitted. if omitted, it is true by default. the returned array contains numeric elements.
7. $ Conn-> Del ();
Delete record
8. $ Conn-> Edit (array ());
Modify record. the parameter is a one-dimensional array. the array key is the field name, and the array value is the field value.
9. $ Conn-> Into (array ());
Add record. the parameter is a one-dimensional array, the array key is the field name, and the array value is the field value.

The preceding methods can be called consecutively, for example:

$ Rult = $ Conn-> Table ('user')-> Select (); // query returns all records of the user Table.
$ Rult = $ Conn-> Table ('user')-> Page (20)-> Select (); // query all records in the user Table and display them on pages, 20 entries per page;

There are a lot of methods to call and learn more!

  1. /*
  3. Database operations
  4. Operation method: Face objects
  5. Production time:
  6. Current version: BqhMysql (mysqli) 1.0.1
  7. Software author: Sad Songs
  8. Contact QQ: 36975.
  9. Contact number: 18907975647
  10. Email: admin@q128.com
  11. Contact Address: Xiaosong town, Shicheng county, Ganzhou city, Jiangxi province
  12. Zip code: 342706
  14. */
  15. Class Mysql {
  16. Private $ LocalHost = 'localhost ';
  17. Private $ LoaclUser = 'root ';
  18. Private $ LocalPass = '20140901 ';
  19. Private $ LocalBase = 'jiangxibaiyi ';
  20. Private $ LocalCode = 'utf8 ';
  21. Private $ PreFix;
  22. Private $ Conn;
  23. Private $ Start = 0;
  24. Private $ Error = false; // database connection status; false indicates no connection or the connection is abnormal
  25. Public $ Err = true; // SQL execution result
  27. Private $ Table;
  28. Private $ Field = '*';
  29. Private $ Where = '';
  30. Private $ Order = '';
  32. Private $ PageSize = 0; // display by page-> how many entries per page, 0 is not displayed by page
  33. Private $ PageCount = 1; // display by page-> Total number of items
  34. Private $ PageNum = 1; // display by page-> Total number of pages
  35. Private $ PageNo = 1; // display by page-> current page
  36. Private $ PageKey = 'page'; // PageKey
  37. Private $ PageStart = 0; // display by page-> The number of returned results starting from
  40. Private $ Select;
  41. Private $ Rest;
  43. Private $ Result = false; // Result set
  45. Public $ FormArray = array ();
  47. Public $ region _id = 0;
  48. Private $ j = 0;
  51. Public function Parameter ($ Loca, $ Root, $ Pass, $ Base, $ Code, $ PreFix = ''){
  52. $ This-> LoaclUser = $ Root;
  53. $ This-> LocalBase = $ Base;
  54. $ This-> LocalCode = $ Code;
  55. $ This-> LocalHost = $ Loca;
  56. $ This-> LocalPass = $ Pass;
  57. $ This-> PreFix = $ PreFix;
  58. Return $ this;
  59. }
  60. Private function Connection ($ SQL ){
  61. ! Function_exists (mysqli_connect )? Die ('query failed, unable to load mysqli extension'): null;
  62. $ This-> Conn = @ new mysqli ($ this-> LocalHost, $ this-> LoaclUser, $ this-> LocalPass, $ this-> LocalBase );
  63. $ This-> Error = mysqli_connect_errno () = 0? True: false;
  64. ! $ This-> Error? Die ('database connection error, check database connection parameters'): null;
  65. $ This-> Conn-> query ('set names'. $ this-> LocalCode );
  66. $ This-> Rest = $ this-> Conn-> query ($ SQL );
  67. $ This-> Err = mysqli_error ($ this-> Conn );
  68. $ This-> consumer _id = mysqli_insert_id ($ this-> Conn );
  69. $ This-> Rest-> free_result;
  70. $ This-> Conn-> close;
  71. $ This-> FormArray = '';
  72. Return $ this;
  73. }
  75. Public function null (){
  76. $ This-> PageSize = 0;
  77. // $ This-> PageCount = 1;
  78. $ This-> PageStart = 1;
  79. $ This-> Field = '*';
  80. $ This-> Select = '';
  81. Unset ($ this-> Table, $ this-> Where, $ this-> Order, $ this-> Result );
  82. }
  84. Public function Table ($ TableName) {// data Table
  85. $ This-> null ();
  86. $ This-> Table = '''. $ this-> PreFix. $ TableName .''';
  87. Return $ this;
  88. }
  90. Public function Field ($ Array = '*') {// data Field
  91. ! Empty ($ this-> Field )? $ This-> Field = '': null;
  92. $ Array = explode (',', $ Array );
  93. Foreach ($ Array as $ field ){
  94. $ This-> Field. =! $ This-> Start? '''. $ Field. ''': ', ''. $ field .''';
  95. $ This-> Start ++;
  96. }
  97. $ This-> Start = 0;
  98. Return $ this;
  99. }
  101. Public function Where ($ Where) {// condition
  102. $ This-> Where = 'where'. $ where;
  103. Return $ this;
  104. }
  106. Public function Order ($ Order) {// sort
  107. $ This-> Order = 'Order by'. $ order;
  108. Return $ this;
  109. }
  111. Public function pk ($ key) {// pagination url parameter key
  112. $ This-> PageKey = $ key;
  113. Return $ this;
  114. }
  116. Public function Page ($ PageSize) {// Page
  117. $ This-> PageSize = $ PageSize;
  118. $ This-> PageNo = $ this-> get ($ this-> PageKey );
  119. $ This-> PageNo = empty ($ this-> PageNo) |! Isset ($ this-> PageNo) |! Is_numeric ($ this-> PageNo) | $ this-> PageNo <1? 1: $ this-> PageNo;
  120. Return $ this;
  121. }
  123. Public function post ($ Key, $ Filter = true ){
  124. Return $ Filter? Strip_tags ($ _ POST [$ Key]): $ _ POST [$ Key];
  125. }
  127. Public function get ($ Key, $ Filter = true ){
  128. Return $ Filter? Strip_tags ($ _ GET [$ Key]): $ _ GET [$ Key];
  129. }
  131. Public function Sel (){
  132. $ This-> Select = 'select'. $ this-> Field. 'from'. $ this-> Table. $ this-> Where. $ this-> Order;
  133. $ This-> Connection ($ this-> Select );
  134. If ($ this-> Rest-> num_rows ){
  135. While ($ Rs = $ this-> Rest-> fetch_assoc ()){
  136. $ This-> Result [] = $ Rs;
  137. }
  138. }
  139. $ DataBase = $ this-> Result;
  140. Return empty ($ DataBase )? False: $ DataBase;
  141. }
  143. Public function querys ($ SQL = '', $ Type = 'not', $ biao = false ){
  144. $ This-> Select = $ SQL;
  145. $ This-> Connection ($ this-> Select );
  146. If ($ this-> Rest-> num_rows ){
  147. If (! $ Biao ){
  148. While ($ Rs = $ this-> Rest-> fetch_array ()){
  149. $ This-> Result [] =! Preg_match ('/^ \ d + $/I', $ Type )? $ Rs: $ Rs [$ Type];
  150. }
  151. } Else {
  152. While ($ Rs = $ this-> Rest-> fetch_assoc ()){
  153. $ This-> Result [] = $ Rs;
  154. }
  155. }
  156. }
  157. $ DataBase = $ this-> Result;
  158. Return empty ($ DataBase )? False: $ DataBase;
  160. }
  162. Public function executes ($ SQL = ''){
  163. $ This-> Connection ($ SQL );
  164. Return $ this-> Rest;
  165. }
  168. Public function exists ($ T = '', $ F ='', $ W = ''){
  169. If (empty ($ F) {return 0 ;}
  170. $ Cmd = empty ($ W )? 'Select sum ('. $ F. ') as 'policyinum' from ''. $ this-> PreFix. $ T. ''': 'Select sum ('. $ F. ') as 'policyinum' from ''. $ this-> PreFix. $ T. ''where '. $ W;
  171. $ This-> Connection ($ cmd );
  172. Unset ($ T, $ F, $ W, $ cmd );
  173. $ Rel = $ this-> Rest-> fetch_array ();
  174. Return round ($ Rel ['categoryinum'], 2 );
  175. }
  178. Public function ExistsTo ($ Bili = 10000, $ T = '', $ F ='', $ W = ''){
  179. If (empty ($ F) {return 0 ;}
  180. $ Cmd = empty ($ W )? 'Select sum ('. $ F. ') as 'policyinum' from ''. $ this-> PreFix. $ T. ''': 'Select sum ('. $ F. ') as 'policyinum' from ''. $ this-> PreFix. $ T. ''where '. $ W;
  181. $ This-> Connection ($ cmd );
  182. Unset ($ T, $ F, $ W, $ cmd );
  183. $ Rel = $ this-> Rest-> fetch_array ();
  184. Return round ($ Rel ['policyinum'] * $ Bili );
  185. }
  188. Public function Select ($ Type = true, $ ListNum = 1) {// return record (array format, number of returned Records)
  189. $ This-> Select = 'select'. $ this-> Field. 'from'. $ this-> Table. $ this-> Where. $ this-> Order;
  190. If (is_numeric ($ ListNum )){
  191. If ($ this-> PageSize> 0 ){
  192. $ This-> Connection ($ this-> Select); // execute the query
  193. $ This-> PageCount = $ this-> Rest-> num_rows; // gets the total number of records.
  194. $ This-> PageNum = ceil ($ this-> PageCount/$ this-> PageSize); // total number of pages
  195. $ This-> PageNo = $ this-> PageNo> $ this-> PageNum? $ This-> PageNum: $ this-> PageNo;
  196. $ This-> PageStart = ($ this-> PageNo-1) * $ this-> PageSize; // The number of items returned from the current start
  197. $ This-> Select. = 'limit'. $ this-> PageStart. ','. $ this-> PageSize; // re-construct an SQL statement
  198. } Else {
  199. $ This-> Select. = 'limit '. $ ListNum; // reconstructs an SQL statement.
  200. }
  201. } Else {
  202. $ This-> Select. = 'limit 1'; // reconstructs an SQL statement.
  203. }
  204. // Echo $ this-> Select;
  205. $ This-> Connection ($ this-> Select); // run the query again
  206. If ($ this-> Rest-> num_rows) {// if the record exists
  207. If ($ Type ){
  208. While ($ Rs = $ this-> Rest-> fetch_array ()){
  209. $ This-> Result [] = $ Rs;
  210. }
  211. } Else {
  212. While ($ Rs = $ this-> Rest-> fetch_assoc ()){
  213. $ This-> Result [] = $ Rs;
  214. }
  215. }
  216. }
  217. If ($ ListNum = 1 or! Is_numeric ($ ListNum ))&&! $ This-> PageSize) {$ this-> Result = $ this-> Result [0];}
  218. $ DataBase = $ this-> Result;
  219. Return empty ($ DataBase )? False: $ DataBase;
  220. }
  222. Public function Num () {// total number of returned Records
  223. $ This-> Select = 'select'. $ this-> Field. 'from'. $ this-> Table. $ this-> Where. $ this-> Order;
  224. $ This-> Connection ($ this-> Select); // execute the query
  225. Return $ this-> Rest-> num_rows; // Retrieve the total number of records
  226. }
  228. Public function PageNav ($ NumNav = false) {// pagination
  229. $ Action = $ this-> get ('action ');
  230. ! Empty ($ Action) or $ Action = 'index ';
  231. $ Module = $ this-> get ('module ');
  232. ! Empty ($ Module) or $ Module = 'index ';
  233. $ NavUrl = '/'. $ Module. '/'. $ Action. '/'. $ this-> PageKey .'/';
  234. $ NaIndex = '/'. $ Module. '/'. $ Action;
  235. $ PageHtml = "\ n

    ";

  236. $ PageHtml. = ''. $ this-> PageCount. 'record '. $ this-> PageNo.'/'. $ this-> PageNum. 'page ';
  237. $ This-> PageNo <= 1 or $ PageHtml. = "homepage \ nPageNo-1)." \ "> Previous Page \ n ";
  238. If ($ NumNav) {$ PageHtml. = $ this-> NumPage ($ NavUrl );}
  239. $ This-> PageNo >=$ this-> PageNum or $ PageHtml. = "PageNo + 1 ). "\"> Next Page \ nPageNum. "\"> Last Page \ n ";
  240. $ PageHtml. ="

    \ N ";
  241. Return $ PageHtml;
  242. }
  244. Private function NumPage ($ Can = '') {// numeric page
  245. $ NumHtml = '';
  246. $ First = 1;
  247. $ Last = $ this-> PageNum;
  248. If ($ this-> PageNum> 5 ){
  249. If ($ this-> PageNo <$ this-> PageNum ){
  250. $ First = $ this-> PageNo-2;
  251. $ Last = $ this-> PageNo + 2;
  252. } Else {
  253. $ First = $ this-> PageNo-4;
  254. $ Last = $ this-> PageNum;
  255. }
  256. }
  257. If ($ First <1) {$ First = 1; $ Last = $ First + 4 ;}
  258. If ($ Last> $ this-> PageNum) {$ First = $ this-> PageNum-4; $ Last = $ this-> PageNum ;}
  259. For ($ I = $ First; $ I <= $ Last; $ I ++ ){
  260. $ NumHtml. = $ this-> PageNo! = $ I? "\ N \ t ". ''. $ I. ''. "\ n \ t": "\ n \ t ". ''. $ I. ''. "\ n \ t ";
  261. }
  262. Unset ($ Can, $ First, $ I, $ Last );
  263. Return $ NumHtml;
  264. }
  266. Public function UserPage ($ NumNav = false, $ PageName = 'index', $ Mulu = 'user') {// Member Center page
  267. $ NavUrl = '/'. $ Mulu. '/'. $ PageName. '/'. $ this-> PageKey .'/';
  268. $ PageHtml = "\ n

    ";

  269. $ PageHtml. = ''. $ this-> PageCount. 'record '. $ this-> PageNo.'/'. $ this-> PageNum. 'page ';
  270. $ This-> PageNo <= 1 or $ PageHtml. = "homepage \ nPageNo-1)." \ "> Previous Page \ n ";
  271. If ($ NumNav) {$ PageHtml. = $ this-> NumPage ($ NavUrl );}
  272. $ This-> PageNo >=$ this-> PageNum or $ PageHtml. = "PageNo + 1 ). "\"> Next Page \ nPageNum. "\"> Last Page \ n ";
  273. $ PageHtml. ="

    \ N ";
  274. Return $ PageHtml;
  275. }
  278. // Form processing starts
  280. // Submit when judging the form
  281. Public function FormIs ($ Keys = 'mm '){
  282. Return $ _ POST [$ Keys] = 1? True: false;
  283. }
  285. // Obtain data in post mode
  286. Public function _ post ($ Keys = '', $ TiHuan = ''){
  287. $ Values = strip_tags ($ _ POST [$ Keys]);
  288. $ This-> FormArray [$ Keys] = empty ($ Values )? $ TiHuan: $ Values;
  289. Return empty ($ Values )? $ TiHuan: $ Values;
  290. }
  292. // Get the data
  293. Public function _ get ($ Keys = '', $ TiHuan = ''){
  294. $ Values = strip_tags ($ _ GET [$ Keys]);
  295. Return empty ($ Values )? $ TiHuan: $ Values;
  296. }
  298. // Determine whether the value is a number and not less than 0
  299. Public function IsNum ($ Num = 0, $ Mesg = 'parameter must be a number '){
  300. If (is_numeric ($ Num )&&! Empty ($ Num) & $ Num> = 0 ){
  301. Return $ Num;
  302. } Else {
  303. Die ($ Mesg );
  304. }
  305. }
  307. // Returns True/False if it is a number and is not less than 0.
  308. Public function NumBer ($ Num = 0 ){
  309. Return is_numeric ($ Num )&&! Empty ($ Num) & $ Num> = 0? True: false;
  310. }
  312. // Detection data seems to exist
  313. Public function IsData ($ Types = true, $ memg = 'data already exists '){
  314. $ This-> Connection ('select'. $ this-> Field. 'from'. $ this-> Table. $ this-> Where );
  315. If ($ Types ){
  316. $ This-> Rest-> num_rows> 0? Die ($ memg): null;
  317. } Else {
  318. Return $ this-> Rest-> num_rows;
  319. }
  320. }
  323. // Write database records
  324. Public function into ($ Mesg = ''){
  325. ! Is_array ($ this-> FormArray )? Die ($ Mesg): null;
  326. $ SQL = 'insert'. $ this-> Table .'('';
  327. $ I = 0;
  328. Foreach ($ this-> FormArray as $ Key => $ Val ){
  329. $ Duan. =! $ I? $ Key. ''': ', ''. $ Key .''';
  330. If (is_numeric ($ Val )){
  331. $ Vals. =! $ I? $ Val: ','. $ Val;
  332. } Else {
  333. $ Vals. =! $ I? '\ ''. $ Val.' \'': ', \ ''. $ Val .'\'';
  334. }
  335. $ I ++;
  336. }
  337. $ SQL. = $ Duan. ') values ('. $ Vals .')';
  339. // @ File_put_contents ('1. SQL ', $ SQL, FILE_APPEND );
  341. $ This-> Connection ($ SQL );
  342. Return! Empty ($ this-> Err )? False: true;
  343. }
  345. // Write data in array form
  346. Public function MsgBox ($ Table = '', $ Filed = array ()){
  347. $ This-> Table ($ Table );
  348. Foreach ($ Filed as $ Key => $ Val ){
  349. $ This-> FormArray [$ Key] = $ Val;
  350. }
  351. Return $ this-> Into ('data not obtained ');
  352. }
  354. // Modify database records
  355. Public function Edit ($ Array = array ()){
  356. If (empty ($ Array) {$ Array = $ this-> FormArray ;}
  357. If (! Is_array ($ Array) | empty ($ Array )){
  358. Return false;
  359. } Else {
  360. $ SQL = 'update'. $ this-> Table. 'set ';
  361. $ I = 0;
  362. $ Sub = '';
  363. $ Huan = array ('-' => '[jian]', '+' => '[jia]', '*' => '[cheng]', '/' => '[chu]');
  364. $ Zhan = array ('[jian]' => '-', '[jia]' => '+', '[cheng]' => '*', '[chu]' => '/');
  366. Foreach ($ Array as $ Files => $ Val ){
  367. $ Val =! Is_numeric ($ Val )&&! Preg_match ('/\' \ w + \ '\ s * (\ + | \-| \ * | \/)/I', $ Val )? '\ ''. $ Val.' \'': $ Val;
  368. Foreach ($ Huan as $ key => $ val ){
  369. $ Val = str_replace ($ key, $ val, $ Val );
  370. }
  371. $ Duan =! $ I? '''. $ Files. ''= ':',''. $ Files. ''= ';
  372. $ Sub. = $ duan. $ Val;
  373. $ I ++;
  374. }
  375. $ SQL. = $ Sub. $ this-> Where;
  376. Foreach ($ Zhan as $ Fan =>$ Hui ){
  377. $ SQL = str_replace ($ Fan, $ Hui, $ SQL );
  378. }
  380. // Echo $ SQL; die;
  382. $ This-> Connection ($ SQL );
  383. Unset ($ Array, $ duan, $ Fan, $ Files, $ Huan, $ Hui, $ I, $ key, $ SQL, $ Sub, $ Val, $ Zhan, $ val );
  384. Return! Empty ($ this-> Err )? False: true;
  385. }
  386. }
  388. // Delete database records
  389. Public function del (){
  390. $ SQL = 'delete from'. $ this-> Table. $ this-> Where;
  391. $ This-> Connection ($ SQL );
  392. Unset ($ SQL );
  393. Return! Empty ($ this-> Err )? False: true;
  394. }
  396. // Form processing ends
  398. // Page jump
  399. Public function Msg ($ Text = 'Operation succeeded '){
  400. Echo' ';
  401. Echo'

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
php mysql database connection class share mysql database mysql database class how to share mysql database in network php class self php database class php database class example

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More