回答編集履歴
2
2
test
CHANGED
|
@@ -19,3 +19,7 @@
|
|
|
19
19
|
```
|
|
20
20
|
|
|
21
21
|
※項目名を指定する先頭のあたり
|
|
22
|
+
|
|
23
|
+
--- 追記 ---
|
|
24
|
+
|
|
25
|
+
※上記は他の方も指摘されているようにダブルクオーテーションを使うとこですね。
|
1
1
test
CHANGED
|
@@ -7,3 +7,15 @@
|
|
|
7
7
|
```
|
|
8
8
|
|
|
9
9
|
ダブルクオーテーションが足りませんね。
|
|
10
|
+
|
|
11
|
+
--- 追記 ---
|
|
12
|
+
|
|
13
|
+
あとこのへんとか
|
|
14
|
+
|
|
15
|
+
```php
|
|
16
|
+
|
|
17
|
+
$sto=$db->prepare('INSERT INTO test(sno int auto_increment,day,hour,min,tag,place,meal,eaten,q101,q102,q103,q104,q105,q106,q107,q108,q109,q201,q202,q203,q204,q205,q206,q207,q208,q209,q210,q211,q212,q213,q214,q215,q301,q302,q303,q304,q305,q306,q307,q308,q309,q310,q311,q312,q313,q314,q315,q316,q317,q318,q319,q320,q321,q401,q402,q403,q404,q405,q406,q407,q408,q409,q410,q411,q412,q413,q414,q415,q416,q417,q418,q419,q420,q421,q422,q423,q424,q425,q426,q427,q428,q429,q430,q431,q432,q433,q434,q435,q436,q437,q438,q439,q501,q502,q503,q504,q505,q506,q507,q508,q509,q510,q511,q512,q513,q514,q515,q550,q551,q552,q553,q554,q555,q556,q557,q558,q601,q602,q603,q604,q605,q606,q651,q652,q653,q661,q662,q663,q664,q665,q666,q701,q702,q703,q704,q705,q706,q707,q708,q709,q710,q711,q712,q713,q714,q715,q716,q717,q718,q801,q802,q803,q804,q805,q806,q807,q808,q809,q810,q811,q812,q850,q851,q852,q901,q902,q903,q904,q905,q906,q907,q908,q909,q910,q911,q912,calorie,protein,lipid,carbohydrate,calcium,iron,zinc,magnesium,folic_acid,vitamin_a,vitamin_d,vitamin_e,vitamin_k,vitamin_b1,vitamin_b2,vitamin_c,dietary_fiber,age)values($day,$hour,$min,$tag,$place,$meal,$eaten,$q101,$q102,$q103,$q104,$q105,$q106,$q107,$q108,$q109,$q201,$q202,$q203,$q204,$q205,$q206,$q207,$q208,$q209,$q210,$q211,$q212,$q213,$q214,$q215,$q301,$q302,$q303,$q304,$q305,$q306,$q307,$q308,$q309,$q310,$q311,$q312,$q313,$q314,$q315,$q316,$q317,$q318,$q319,$q320,$q321,$q401,$q402,$q403,$q404,$q405,$q406,$q407,$q408,$q409,$q410,$q411,$q412,$q413,$q414,$q415,$q416,$q417,$q418,$q419,$q420,$q421,$q422,$q423,$q424,$q425,$q426,$q427,$q428,$q429,$q430,$q431,$q432,$q433,$q434,$q435,$q436,$q437,$q438,$q439,$q501,$q502,$q503,$q504,$q505,$q506,$q507,$q508,$q509,$q510,$q511,$q512,$q513,$q514,$q515,$q550,$q551,$q552,$q553,$q554,$q555,$q556,$q557,$q558,$q601,$q602,$q603,$q604,$q605,$q606,$q651,$q652,$q653,$q661,$q662,$q663,$q664,$q665,$q666,$q701,$q702,$q703,$q704,$q705,$q706,$q707,$q708,$q709,$q710,$q711,$q712,$q713,$q714,$q715,$q716,$q717,$q718,$q801,$q802,$q803,$q804,$q805,$q806,$q807,$q808,$q809,$q810,$q811,$q812,$q850,$q851,$q852,$q901,$q902,$q903,$q904,$q905,$q906,$q907,$q908,$q909,$q910,$q911,$q912,$calorie,$protein,$lipid,$carbohydrate,$calcium,$iron,$zinc,$magnesium,$folic_acid,$vitamin_a,$vitamin_d,$vitamin_e,$vitamin_k,$vitamin_b1,$vitamin_b2,$vitamin_c,$dietary_fiber,$age)');
|
|
18
|
+
|
|
19
|
+
```
|
|
20
|
+
|
|
21
|
+
※項目名を指定する先頭のあたり
|