สอบถาม Insert 2 ตาราง PKของตารางที่1 เป็น FK ตารางที่2 ค่ะ
Code (PHP) <?php
$host="localhost";
$username="root";
$password="1234";
$db="bmc on web";
$tb="`user`, `company`";
$connect=mysql_connect( $host,$username,$password) or die ("ติดต่อฐานข้อมูลไม่ได้");
mysql_select_db($db) or die("เลือกฐานข้อมูลไม่ได้");
$sql="select * from $tb";
$dbquery=mysql_db_query($db,$sql);
$result= mysql_fetch_array($dbquery);
mysql_query ("INSERT INTO user (Email, Username, Password, Name) values ('$Email','$Username','$Password','$Name')") ;
mysql_query ("INSERT INTO company (Name_c, Detail) values ('$Name_c','$Detail')") ;
mysql_close($connect);
?>
Tag PHP, MySQL
Date :
2016-03-28 15:32:46By :
NefiliView :
3467Reply :
2
ผิดตั้งแต่ ตรงนี้แล้วครับ
Date :
2016-03-28 16:45:16By :
mee079
ทำไมไม่ใช้ user id (auto increment) เป็น pk ล่ะCode (PHP) // create users table
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('username')->unique();
$table->string('password');
$table->boolean('password_changed')->default(false);
$table->string('display');
$table->rememberToken();
$table->timestamps();
$table->softDeletes();
});
// create roles table
Schema::create('roles', function (Blueprint $table) {
$table->increments('id');
$table->string('name')->unique();
$table->string('description');
$table->timestamps();
$table->softDeletes();
});
// add role_id to users table
Schema::table('users', function (Blueprint $table) {
$table->integer('role_id')->unsigned()->after('display');
$table->foreign('role_id')->references('id')
->on('roles')->onDelete('cascade');
});
Code (PHP) // seed data
$array = [
['role' => 'Administrator', 'users' => [
['username' => 'admin', 'password' => 'admin', 'display' => 'Administrator'],
]]
];
// Loop through each user above and create the record for them in the database
foreach ($array as $users) {
$obj_role = App\Role::where('name', $users['role'])->first();
foreach ($users['users'] as $user) {
$obj_role->users()->save(new App\User($user));
}
}
Date :
2016-03-28 16:51:01By :
ห้ามตอบเกินวันละ 2 กระทู้
Server 04
Load balance : Server 04
