質問編集履歴
2
タイトルの変更
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
|
|
1
|
+
インサートを行いたいが値が入らない
|
test
CHANGED
|
File without changes
|
1
追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -80,6 +80,46 @@
|
|
|
80
80
|
|
|
81
81
|
```
|
|
82
82
|
|
|
83
|
+
###テーブル構造
|
|
84
|
+
|
|
85
|
+
```php
|
|
86
|
+
|
|
87
|
+
public function createCtJmetaTable()
|
|
88
|
+
|
|
89
|
+
{
|
|
90
|
+
|
|
91
|
+
$sql = "CREATE TABLE IF NOT EXISTS `ct_meta` ("
|
|
92
|
+
|
|
93
|
+
."`id` int(10) unsigned NOT NULL AUTO_INCREMENT,"
|
|
94
|
+
|
|
95
|
+
."`job_id` bigint(20) unsigned NOT NULL,"
|
|
96
|
+
|
|
97
|
+
."`item_id` bigint(20) unsigned NOT NULL,"
|
|
98
|
+
|
|
99
|
+
."`value` longtext COLLATE utf8_unicode_ci NOT NULL,"
|
|
100
|
+
|
|
101
|
+
."`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',"
|
|
102
|
+
|
|
103
|
+
."`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',"
|
|
104
|
+
|
|
105
|
+
."PRIMARY KEY (`id`),"
|
|
106
|
+
|
|
107
|
+
."KEY `jmeta_job_id_foreign` (`job_id`),"
|
|
108
|
+
|
|
109
|
+
."KEY `jmeta_jitem_id_foreign` (`item_id`),"
|
|
110
|
+
|
|
111
|
+
."CONSTRAINT `jmeta_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `ct_jobs` (`id`)"
|
|
112
|
+
|
|
113
|
+
.") ENGINE=InnoDB AUTO_INCREMENT=3102665 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
|
|
114
|
+
|
|
115
|
+
$stmt = self::$_pdo->prepare($sql);
|
|
116
|
+
|
|
117
|
+
$stmt -> execute();
|
|
118
|
+
|
|
119
|
+
}
|
|
120
|
+
|
|
121
|
+
```
|
|
122
|
+
|
|
83
123
|
###やりたいこと
|
|
84
124
|
|
|
85
125
|
DBにデータを保存することですが、データが入っているもののみを保存しようとしています。
|