Instert into table when the table is empty?

Question

i have this code to update a value in the database, but this only works if there is already something in the database. is it possible to check if the database is empty first and if its empty INSTERT something into the databse, else just update it with this code.

 $name = $_POST['example'];
        if (isset($_POST['example'])) {
            $sql = 'UPDATE `table` SET `column` = "' . $name . '"';
            $stmt = $this->db->pdo->prepare($sql);
            $stmt->execute();
            return $stmt->rowCount();
        }

phpMyAdmin is s not a database. It is a tool. Which database are you using? — Dharman, Jan 13 '20 at 13:04
Does this answer your question? [Insert into a MySQL table or update if exists](https://stackoverflow.com/questions/4205181/insert-into-a-mysql-table-or-update-if-exists) — Dharman, Jan 13 '20 at 13:06
it seems that the solution you sent doesnt work for me, but thanks anyway — , Jan 13 '20 at 13:12

score 1 · Accepted Answer · answered Jan 13 '20 at 13:11

Try the below code. It's working for you.

<?php
    $name = $_POST['example'];
    if (isset($_POST['example'])) {
        $sql = 'SELECT COUNT(*) from `table` where `column` = "' . $name . '"';
        $stmt = $this->db->pdo->prepare($sql);
        $stmt->execute();

        if ($stmt->fetchColumn() > 0) {
            $sql = 'UPDATE `table` SET `column` = "' . $name . '"';                
        } else {
            $sql = 'INSERT INTO `table` (`column`) VALUES("' . $name . '")';
        }
        $stmt = $this->db->pdo->prepare($sql);
        $stmt->execute();
        return $stmt->rowCount();
    }        
?>

score 0 · Answer 2 · answered Jan 13 '20 at 13:43

Prepare stmt for prevent sql injection like:

<?php
    $name = $_POST['example'];
    if (isset($_POST['example'])) {
        $sql = 'SELECT COUNT(*) from `table` where `column` = ?';
        $stmt = $this->db->pdo->prepare($sql);
        $stmt->bind_param('s',$name);
        $stmt->execute();

        if ($stmt->fetchColumn() > 0) {
            $sql = 'UPDATE `table` SET `column` = ?';                
        } else {
            $sql = 'INSERT INTO `table` (`column`) VALUES(?)';
        }
        $stmt = $this->db->pdo->prepare($sql);
        $stmt->bind_param('s',$name);
        $stmt->execute();
        return $stmt->rowCount();
    }        
?>

Instert into table when the table is empty?

2 Answers2