Php+mysql Library Management System (IV)

1. Search for booksA. Requests can be made on the category, title, publisher, year (year range), author, price (interval). Each book information includes the following:

(ISBN, category, title, publishing house, year, author, Price, total collection, stock)

B. Optional requirements: You can sort the book information by user-specified attributes. (default is title)

The biggest problem here is the problem of sorting Chinese characters because it is wrong to encode in Chinese first is a problem generally we will use the international general

Encoding is UTF-8, but using this to sort the results is not ideal if you use the GBK encoding format, the result is

More ideal.

But if you change the encoding format of a database and bring unpredictable results, try to find some way to compromise.

I've been looking for ways to do this, but I don't seem to have any eggs. Click to open the link

<style type= "Text/css" >table.hovertable {font-family:verdana,arial,sans-serif;font-size:11px;color: #333333 ; Border-width:1px;border-color: #999999; border-collapse:collapse;margin:20px 250px;width:800px;padding:0px 0px;} table.hovertable th {background-color: #c3dde0; Border-width:1px;padding:8px;border-style:solid;border-color: # A9C6C9;} table.hovertable TR {background-color: #d4e3e5;} Table.hovertable td {Border-width:1px;padding:8px;border-style:solid;border-color: #a9c6c9;} </style><?phpecho "

2. Introduction to other feature implementationsfor administrators and borrowing return books and library card management functions to achieve the same wayfor the user, only the ability to query the books and modify their own password The initial password is 123456 passwords are MD5 encrypted later stored
3. Summarythe main technical points to use:1. Use of PhpexcelThis open source tool is very powerful not only to read an Excel and can create an Excel table The most important thing is that you can set a lot of properties at the time of Creationthe detailed use method may refer hereUse of 2.MYSQLdata interaction via PHP with database MySQL in the background here I'm mostly using a series of functions provided by MySQLsimilar to JDBC and ODBC but seems simpler to encapsulate betterUse the method reference herehow 3.php data interactsIt is common to submit a data submission through a form to specify whether it is a post or get method to obtain this data through a global array defined by PHP, in addition to the cookie session can be said to be very simple4. Submit a form to a different pageThe simple thing is to use a JavaScript script to add a click event to the Sublim and then we change the action of the form when it triggers the Click event.property is good.
<input type= "Submit" value= "Implementation" style= "WIDTH:50PX;HEIGHT:25PX; margin:0px 250px; " onclick= "javascript:this.form.action= ' deletecard.php ';" >
5. DeficienciesWrite tight code messy some design not in place this is actually their own level not toexception handling may be problematic for a small amount of data it's going to be fine. Massive access is bound to go wrong
temporarily this multi-code post perfect will continue to update


Php+mysql Library Management System (IV)