PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE pacients( `id` INT NOT NULL, `name` VARCHAR(255), `age` INT, `phone` VARCHAR(14) ); CREATE TABLE doctors( `id` INT NOT NULL, `name` VARCHAR(255), `phone` VARCHAR(14), `special` VARCHAR(255) ); CREATE TABLE records( `id` INT, `doctor_id` VARCHAR(255), `pacient_id` VARCHAR(255), `date` DATETIME ); INSERT INTO doctors VALUES (1, 'kekes', '71231231212', 'surgeon'); INSERT INTO doctors VALUES (2, 'arno', '71231231215', 'beautician'); INSERT INTO doctors VALUES ('urno', '71231231211', 'proctologist'); INSERT INTO doctors VALUES ('deros', '71231231216', 'gynecologist'); SELECT * FROM doctors; INSERT INTO pacients VALUES ('pacient1',18,'51231231216'); INSERT INTO pacients VALUES ('pacient2',15,'51231231213'); INSERT INTO pacients VALUES ('pacient3',25,'51231231212'); INSERT INTO pacients VALUES ('pacient4',29,'51231231211'); SELECT * FROM pacients
Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; // Select using Laravel $version = $db::select($db::raw("SELECT VERSION() as version;")); function appointment($doctor) { $doc = $db::table('doctors')->where('id',$doctor)->first(); // print_r($doctor); // $record = $db::table('records')->insert([ // 'id' => 1, // 'doctor_id' => $doc['id'], // 'pacient_id' => $pac['id'], // 'date' => Carbon::now() // ]); // print_r($record); } appointment('1');
Show:  
Copy Clear