Category : database

I’ve got two databases in the same server & i’ll define them to be database_nevada & database_zurich with a table name users holding exact same column names in each databases: -database_nevada.users -database_zurich.users I’ve created this trigger on database_nevada.users where every inserts to database_nevada.users table would insert the same row to database_zurich.users as well : This ..

Read more

Is it possible to just set a placeholder as table in a selection and then bind the table name with MySQLi prepared statements? I have 3 tables. Each would have the same function if it isn’t possible to code it with variables. My failed attempt: $data_table would be something like "blogposts". function functionname(mysqli $connection, $data_table) ..

Read more