March 10 study summary

The third week of school year is over.

Book:

After reading MySQL, I finally learned the basic structure of MySQL. I know the MySQL components I have not touched in PHP programming before, such as triggers, cursors, views, stored procedures, and so on. I know more about indexes, where to create indexes, what types of indexes to create, the cost of indexes, and so on.

I read PHP cabbage again and got a better understanding of MySQL, the common SQL tunning, and the index abuse price, and the efficiency and connection of subqueries. In terms of regular expressions, I still don't know about some advanced parts, but I can write simple collections or use simple_html_dom for assistance, but I still don't know how to properly use the memory. In terms of OOP, I have learned a little more about some OO Knowledge and really know _ set () ,__ get (), thanks to the book "Let's talk about PhP, oo's knowledge is reviewed through this book.

Oracle SG1 saw the maintain redo log file section. If you have time to continue learning with the video on boobooke, you can also read it.

After reading "CSS", I reviewed CSS knowledge, especially about positioning and the difference between absolute, relative, and fixed, floating is positioned in absolute positioning application scenarios.

I read SQL injection attacks and defense, combined with the video I saw on boobooke, and manually injected or used tools such as sqlmap, havij, and yujian for SQL injection attacks. I took a C language course this semester and didn't go to the school. I had acm oj platform and made a few questions. I found the feeling of C, by the way, I checked the security of the OJ platform and found the injection vulnerability.

MySQL Administrator's Guide, a big book, takes a long time and considers learning from the BBK video.

Video:

I posted the vim video in my sophomore year and posted it on my blog.

After reading the MySQL Optimization of itcast, I learned how to use explain to analyze and query the table horizontally and vertically. Understand DDL and DML.

After reading several episodes of "The Great Tang Dynasty and the legend of the Dragon", I couldn't find the feeling of playing games and watching TVB. I didn't try again.

Google & Baidu:

I searched some interview questions, most of which are basic and simple. I did it again. I have known some functions that I have never seen before, such as parse_url (), pathinfo (), and basename (), which are recorded in the mic library.

Work:

I made a set of ecshop templates and learned about the content of ecshop, such as the dwt, LBI, and insert_info of ecshop, as well as ecshop copyright issues ......

After learning phpcms, I tracked it with Nb xdebug, from index. PHP to base. PHP, then pc_base: create_app (). I learned about the modular development of phpcms V9. Currently, I still need to study it and try to understand it. By the way, I will separate the core of phpcms and use it as a framework. Learn some PHP design patterns, such as Singleton mode and factory mode.

Vim made some more, added syntax prompts, and now it is better to use it.

Major study:

I did not study well. I listened to linear algebra carefully the previous week, but did not write my homework seriously. The same is true for high numbers and college physics, and drawing is even more difficult. Counselors also forced our group of children to go to their own lessons. Then, they should learn their own majors well and graduate honestly.