PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE your_table ( id INT AUTO_INCREMENT, firstname VARCHAR(100), lastname VARCHAR(100), PRIMARY KEY (id) ); INSERT INTO your_table(id, firstname, lastname) VALUES (1, 'Chad', 'One'), (4, 'Ned', 'Two'), (5, 'Dave', 'Three'), (14, 'Newt', 'Four'), (18, 'Bill', 'Five'), (21, 'Norton', 'Six'), (25, 'Alan', 'Seven'); CREATE TABLE table2 ( id INT AUTO_INCREMENT, firstname VARCHAR(100), lastname VARCHAR(100), PRIMARY KEY (id) );
Copy Clear
Copy Format Clear
<?php // $mysqli is already declared as a working database connection by this sandbox $foreignKeyResult = $mysqli->query("SELECT * FROM your_table"); while ($row = mysqli_fetch_assoc($result)) { $sql = "INSERT INTO table2 (NULL, '" . $row['first_name'] . "', '" . $row['first_name'] . "')"; $result = mysqli_query($mysqli, $sql); } echo mysqli_num_rows($foreignKeyResult);
Show:  
Copy Clear