Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE telegramSiteHelperManagers (
managerTelegramId int, managerName varchar(64), managerNowChat int, managerStatus int
);
<?php
$telegramId = 123;
$sth=$pdo->prepare("INSERT INTO telegramSiteHelperManagers (managerTelegramId, managerName, managerNowChat, managerStatus) VALUES (:managerTelegramId, :managerName, :managerNowChat, :managerStatus)");
$sth->execute(array(
":managerTelegramId"=>$telegramId,
":managerName"=>"Менеджер",
":managerNowChat"=>null,
":managerStatus"=>1
));
$stmt = $pdo->prepare('SELECT * FROM telegramSiteHelperManagers;');
$stmt->execute();
$rows = $stmt->fetch(PDO::FETCH_ASSOC);
print_r($rows);