get post meta for all id [closed]
I want to get all brands from DB. It should work like get_post_meta( get_the_id(), ‘make’, true); but without id. It should contain an array with all brands. Which command I should use?
Tag: database
password_verify() function always return false issue [closed]
this is my login.inc.php file where the login happens $sql = ‘SELECT * FROM users_back WHERE uidUsers =? OR emailUsers = ?’; $stmt = $pdo->prepare($sql); $stmt->execute([$…
Unknown column in foreign key definition
I’m trying to add a new table to an already existing database but it keeps giving me an error “Unknown column ‘product_id’ in foreign key definition”. CREATE TABLE product_review ( …
JSON object or JSON string? Which is better to store in database? [closed]
I’m little confused that if I wanna store json objects and arrays in db than which way is better. I can either directly store them as they are or I can first convert it to string with method JSON….
How can I store the direction of a bus route in mysql database?
I have 3 table: Route, Bus_stop, Route-Bus_stop Route: id, weekday, weekend Bus_stop: id, name Route-Bus_stop: primary key(order, time), foreign key: idRoute, idBus_stop Insert into Route(id,…
Merge multiple tables into one row in a new table
UPDATE the_main_table SET item_Name = ( SELECT item_Name FROM 1d_high_today WHERE 1d_high_today.osrs_id = the_main_table.osrs_id ); UPDATE the_main_table SET D_high = ( SELECT D_high FROM …
PHP Beginner – How to fix fatal errors : Uncaught TypeError: mysqli_query(): [closed]
Please help with errors that are found like this: Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in D:xampphtdocsphpdasarpertemuan10…
Creating ERD Diagram From Case Study
i am trying to create an ERD diagram for a crowdfunding service. I am not sure if i took Entities right and relationships between them. The task is create Rules(Sentences for relationship) and Find …
Diffrence between sum of two products > 0
I want to select the sum of T_No where Transactions are equal to R and subtract it by T_No where Transactions are equal to D and the answer of this should greater than zero for a CustomerID which …
How do I get multiple rows from django database?
Hello I am trying to create an employee attendance program and I want to make it so that the employees can see the total hours they worked. This is the code that creating the problem: elif ‘checkName’ …