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 user1 (serialNumber int, partID int);
INSERT INTO user1 (serialNumber, partID) VALUES (1, 2);
SELECT * FROM user1
<?php
$pSer = 1;
$uName = "user1";
$pID = 2;
$query = "SELECT serialNumber FROM `:userName` WHERE serialNumber = :serNum AND partID = :pID;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->bindParam(":serNum", $pSer);
$stmt->bindParam(":userName", $uName);
$stmt->bindParam(":pID", $pID);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
var_dump($row);