PHP copy table from one database to another
// Create a new MySQL database connection
if (!$con = new mysqli('localhost', $username, $password, $database)) {
die('An error occurred while connecting to the MySQL server!<br><br>' . $con->connect_error);
}
// Create an array of MySQL queries to run
$sql = array(
'DROP TABLE IF EXISTS `backup_db.backup_table`;',
'CREATE TABLE `backup_db.backup_table` SELECT * FROM `live_db.live_table`'
);
// Run the MySQL queries
if (sizeof($sql) > 0) {
foreach ($sql as $query) {
if (!$con->query($query)) {
die('A MySQL error has occurred!<br><br>' . $con->error);
}
}
}
$con->close();
Also in PHP:
- codeigniter insert get last id and increment by one value
- add seeder laravel
- back route laravel
- <?php trim($_POST["data"]); ?>
- composer laravel project
- calling folder and out into folder in php
- does array have key php
- error enable in php
- <?php if ( is_home()
- display image in php from folder
- call seeder in laravel
- create new file in folder php
- convert html to pdf php
- expression is not allowed as parameter
- age php datetime
- code cesar php
- debian install apache php
- encode base 64 php
- check if array key exists in array php
- disable laravel passport
- error log all php
- date and time function php
- carbon random future date
- dom javascript frontend