Array, - Assumption University
Worksheet 6Array, foreach ?Loops, and MySQL Database???????????????:Array: : Array ????????????????????????????????????????????????????????????????????????????? array ?????????????????????? ????????$cars = array("Volvo", "BMW", "Toyota");????$cars[0] = "Volvo";$cars[1] = "BMW";$cars[2] = "Toyota";?????????????????? array ?????????????????????????????????????????? ????????$age = array("Peter"=>"35", "Ben"=>"37", "Joe"=>"43");????$age['Peter'] = "35";$age['Ben'] = "37";$age['Joe'] = "43";????????????1: ???????????????? array <?php$cars =?array("Volvo",?"BMW",?"Toyota");echo?"I like "?. $cars[0] .?", "?. $cars[1] .?" and "?. $cars[2] .?".";$age =?array("Peter"=>"35",?"Ben"=>"37",?"Joe"=>"43");echo?"Peter is "?. $age['Peter'] .?" years old.";?>foreach Loop foreach Loop ?? PHP ?????????????????????? array ?????????????????? array ???????????? ??????????????????????????????????????????????????????????????????????????? foreach loopforeach ($array?as?$value) {? ??//code to be executed;}????????????2: ?????? foreach loop ????????????????????? array $colors <?php?$colors =?array("red",?"green",?"blue",?"yellow");?foreach?($colors?as?$value) {????echo?"$value <br>";}?>MySQL Database MySQL ??? open source ??????????????MySQL AB ???????? ??????????? takeover ????Sun Microsystems ???? ?2008 ?????????????? Oracle ???? 2010 ??? function ??????????? relation database management system (RDBMS) ???????? Structured Query Language (SQL) ????????????????? ?????????? MySQL ??????????????????????Linux,?UNIX????? Windows ?????????????????????????????? ???????????????????????? web-based ?????????? ??????????????????????????????????? MySQL ???????????????????????open source enterprise stack ?????????????????? ” LAMP”??????????????? MYSQL???? web browser ????? URL ??? Install XAMPP ???? ????????????? ???????????? phpMyAdmin ?????????????????????3: ???????? ????????? ???? SCHOOL ??? ??????????????????? STUDENT ????????????????? 4 ????? ??? ??????????????? ???? ??????? ??? ????????? ???? New ??????????????????????????? ???? Collation ???????????? Create??????????????????????????????????????? SCHOOL ??? Collation ??????????????????????????????????? SCHOOL ?????????????????????????????????????????? ????????????????????????????????????????? ???????????????????????????????????? ??????????????????????????????????? STUDENT ??????? 4 ????? ??? ??????????????? ???? ??????? ??? ??????????????????????????????? ??????????????? ???? ??????? ??? ???? ???????????????Datatype in MYSQLVARCHAR :??????????????????????????????? ????????????????????????????????????????? ???????? ???????????????????????????????? ???????????????????????????? 1 - 255 ???????????? ????? ???????????????????????? ???? ???? ??????? ??????????????? ???????... ???????????????????? ?? ??????????? "???????????" ???? BINARY ??? ?????????????????????????????????????? (query) ?????? VARCHAR ????????? case-sensitive (???????????? ???????????????????????????) ??? ??????? "???????????" ???? BINARY ???? ??????????????????????????????????????????? ???????????CHAR :??????????????????????????????? ???????????????????????????????? 255 ???????? ??? ????????????????????????????? VARCHAR ?????????????????????????????? ??????????????? ??? case-sensitive ????????????????????????????? BINARY ??????????????????????????????? non case-sensitive ???????????? VARCHARTINYTEXT?: ???????????????????? ???????????????????????????? ??????????????? FULL TEXT SEARCH ??? MySQL ?????????????????????????????????????????????? VARCHAR ????????????? ??? 256 ???????? ????????????????????????? TEXT ??? ??? TINYTEXT ??? ?????????????????? ??? 256 ???????? ???????????? ????????????????????????????? CHAR ???? VARCHAR(255) ??? ??? ????? ???????????????? ?????FULL TEXT SEARCH ???TEXT?: ?????????????????????????????? ???????????? TINYTEXT ??????????????????????? ??? ????????? 65,535 ???????? ???? 64KB ???????????????????????????????????? ????????MEDIUMTEXT :????????????????????????? ???????????? TINYTEXT ???????????????? 16,777,215 ????????LONGTEXT :????????????????????????? ???????????? TINYTEXT ???????????????? 4,294,967,295 ????????TINYINT?: ??????????????????????????????????? 8 ??? ?????????????????????????????????????? ????????? "???????????" ????????????????? UNSIGNED ???? UNSIGNED ZEROFILL ??????????????????????????? ? ?- UNSIGNED : ????????????????????????????????????????? ???????????????????????????? ??????? 0 - 255?? ? ?- UNSIGNED ZEROFILL : ????????????? ?????????????????????????????????????????? ??????????????? ??? MySQL ??????????? 0 ????????????? ???? ????????????????? 3 ???? ??????????????????? 25 ?????? ??????????????? ???????????????????? 025 ??????????? "?? ?????????" ???????????????????? SIGNED ???????????????????????????????????????? ???/?? ?? ???????????????????????????????? -128 ??? 127 ????????SMALLINT?: ????????????????????????????????????? 16 ??? ?????????????????????????? -32768 ??? 32767 (???????????????????????) ???? 0 ??? 65535 (?????? UNSIGNED ?????????????????????)??????????????? Attribute ???? UNSIGNED ??? UNSIGNED ZEROFILL ??????????????? TINYINTMEDIUMINT?: ????????????????????????????????????? 24 ??? ??????????????????????????? ?????????????????????? -8388608 ??????? 8388607 (???????????????????????) ???? 0 ??? 16777215 (????????????? UNSIGNED ?????????????????????) ??????????????? Attribute ???? UNSIGNED ??? UNSIGNED ZEROFILL ??????????????? TINYINTINT?: ????????????????????????????????????? 32 ??? ?????????????????????????????? -2147483648 ??????? 2147483647 ???? (???????????????????????) ???? 0 ??? 4294967295 (????????????? UNSIGNED ?????????????????????) ??????????????? Attribute ???? UNSIGNED ??? UNSIGNED ZEROFILL ????????????????TINYINT?BIGINT :?????????????????????????????????????? 64 ??? ?????????????????????????? - 9223372036854775808 ??????? 9223372036854775807 ?????????? (?????????????????) ???? 0 ??? 18446744073709551615 (????????????? UNSIGNED ?????????????????????) ??????????????? Attribute ???? UNSIGNED ??? UNSIGNED ZEROFILL ??????????????? TINYINT?FLOAT[(M,D)] :????????????????????? ???????? INT ?????????????????????? ?????????????????? ?????????????? ???????????????? ?????????????????????????????????????????? ???????????????????? ???? FLOAT ?????????????????? 32 ??? ??????????????? -3.402823466E+38 ??????? -1.175494351E- 38, 0 ??? 1.175494351E-38 ??? 3.402823466E+38DOUBLE[(M,D)]?: ?????????????????????????????????? ???????????? FLOAT ????????????? 64 ??? ???????????????????? -1.7976931348623157E+308 ??? -2.2250738585072014E-308, 0 ??? 2.2250738585072014E-308 ??? 1.7976931348623157E+308DECIMAL[(M,D)]?: ?????????????????????????????????? ???????????? FLOAT ?????????????????? ???????????????????????????????????????? ????????? ????????????????????? FLOAT, DOUBLE ??? DECIMAL ????? ????????????? ??????????????????? ?????????????????????? (M,D) ??????????????? ???????????????? ??????? ????????????????????????????????? ????????????????????? ???? ?????????????? FLOAT(5,2) ?? ??????????? ?????????????????????????????????? 5 ???? ????????? 2 ???? ?????????????????? ?????? 12345.6789 ?????? ???????????????????????????????? ????? 12345.68 (???????????????????? ??????????????)DATE?: ???????????????????????????? ????????????? 1 ?????? ?.?. 1000 ??? 31 ??????? ?.?. 9999 ??????????????????? YYYY-MM-DDDATETIME?: ???????????????????????????? ??????? ??????????????????? 1 ?????? ?.?. 1000 ???? 00:00:00 ??????? 31 ??????? ?.?. 9999 ???? 23:59:59 ?????????????????? ?????????????????? (query) ????? ?????? YYYY-MM-DD HH:MM:SS?TIMESTAMP[(M)]?: ???????????????????????????? ?????????????? ???????????????????? YYYYMMDDHHMMSS ???? YMMDDHHMMSS ???? YYYYMMDD ???? YYMMDD ??????? ???????????? M ???? 14, 12, 8 ???? 6 ???????? ?????????????????????????? 1 ?????? ?.?. 1000 ?? ????????????? ?.?. 2037?TIME :??????????????????????????? ??????????????? -838:59:59 ??????? 838:59:59 ??????????? ????????????? HH:MM:SS YEAR[(2/4)] : ???????????????????????? ???????? YYYY ???? YY ????????????????? 2 ???? 4 (?????????? ???????????? 4 ????) ??????????????? 4 ???? ??????????????????? ?.?. 1901 ??? 2155 ??? ??????? 2 ???? ????????????? ?.?. 1970 ??? 2069 ????????? ???????????????????????? TIMESTAMP ??? YEAR ????????????????????? ??? ??????????????????????? ??????? ????????????? VARCHAR ???????????????? ??????????????????????? ????????... ???? ??????????? TIMESTAMP ??????????????????????????????????????????????? ??? ??????????????????? 1 ?????? ?.?. 1000 ??????????? ?.?. 2037 ??????????? ?????????????? VARCHAR ??????????????????????? ????????? YEAR ?????????????... ?????????????? 1 ????????????????? ?????????? ???????????????????? ?? ?.?. 1901 ??? 2155 ???????? (???? ?.?. 1970 ??? 2069 ?????? 2 ????) ?????????????? VARCHAR ???????????? 0000 ??? 9999 ??? ????????????????????????????????????? (??? ?????????????? ????????????????????????????? ????????????????????????? VARCHAR ??? ????? ?????????? ???? ??????????????????????????????? 3 ???? ??? 1 ??????? ???????? 4 ??????????? ??????? ??????? 12 ???????? ???? 12 ??????????????????? ??????????????????????????????????????????? 4 ??????????? ??????????????????????????????????? ???????????????????????????????????????????????)TINYBLOB?: ???????????????????????????? ?????? ???????????????, ??????????, ??????????????? ??????? ???????????????????????????????????????????????????? HTML ??? TINYBLOB ???? ???????????????????????????? 256 ????BLOB?: ???????????????????????????? ???????????? TINYBLOB ?????????????????????? 64KBMEDIUMBLOB :????????????????????????????? ???????????? TINYBLOB ???????????????? 16MBLONGBLOB :????????????????????????????? ???????????? TINYBLOB ???????????????? 4GB ????????? ???????????? BLOB ???? ????????????????????????????????????????????? BINARY ?????????????????????? ????????????????????????? ???????????????????????????????? ?????????????????? ????????????????????????????????????????????????? ????????????????? ???????? ??????????? ?????????????????????????????????????? ??????????????????????????????? ????????????? VARCHAR ???????SET?: ?????????????????????????????????????????????????????? 1 ???????????? ??? ??????????????? ?????? 64 ????????? SQL CommandStructured Query Language ???? SQL??????????????????????????????? (Database) ???????? Relational Database Management System (RDBMS) ?????Oracle,?MySQL,?Microsoft SQL Server, PostgreSQL, IBM DB2, Microsoft Access ???????????????? SQL command ???????????? ?????????????????????????????????????????Database SQL – Insert Query?????? (Syntax)SQL Insert into statement ???????????????????? table name, column name, valueINSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN);???????? INSERT INTO STUDENT VALUES ( ‘111’ , ’Micheal’ , ’Jackson’ , 60)Database SQL – Select Query???????????????????create database????????create table???? ?????????insert table???????????????????? ??????????????????????????????????????? ???? table ???????????????????????????????????????? ?????????????????? SQL Select statement ??????????????????????????? result set ?????????????????????????? ???? table ????????????? column ??? row?????? (Syntax)SQL Select statement ??????????????????? column name ??? table name ??????????????????????????????SELECT column1, column2, columnN FROM table_name;???????? SELECT ID, NAME FROM STUDENT ????SELECT * FROM STUDENT SQL Select statement ?????????????? Where condition ???????????????????? ?????????????????????????????????????????????????????????????????????????SELECT column1, column2, columnN FROM table_nameWHERE [condition]????????? condition ???????????????SQL Operator????? =, >, <, LIKE, NOT ????????????SQL Expression????????????????????????? table ??? ??????????????????????????? SELECT * FROM STUDENT WHERE ID = ‘111’ ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- assumption of logistic regression model
- reverse the array using array indexing python
- convert array to string array matlab
- cell array to array matlab
- add array to array js
- logistic regression assumption tests
- push array to array javascript
- assumption for correlation test
- add array to array javascript
- array to cell array matlab
- powershell array of array example
- append array to array numpy