PHP Conn - Revision history

Jlebeau81 at 14:22, 7 January 2026

2026-01-07T14:22:03Z

← Older revision		Revision as of 14:22, 7 January 2026
Line 4:		Line 4:
	$servername = "localhost"; // Server Name		$servername = "localhost"; // Server Name
	$username = "root"; //mysql username		$username = "root"; //mysql username
	$password = "password"; //Database Password		$password = "password"; //Database Password
	$dbname = "dbname"; //Database Name		$dbname = "dbname"; //Database Name

Jlebeau81 at 14:21, 7 January 2026

2026-01-07T14:21:09Z

← Older revision		Revision as of 14:21, 7 January 2026
Line 10:		Line 10:
	$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);		$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
	//set the PDO error mode to exception		//set the PDO error mode to exception

	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

Line 16:		Line 17:

	//set the resulting array to associative		//set the resulting array to associative
	$result = $stmt->fetchAll(PDO::FETCH_ASSOC);		$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

	echo "<ul>";		echo "<ul>";
	foreach ($result as $row) {		foreach ($result as $row) {
	echo "<li>Roll No: " . $row["Roll_No"] . " - Name: " . $row["Name"] . " \| City: " . $row["City"] . "</li>";		echo "<li>Roll No: " . $row["Roll_No"] . " - Name: " . $row["Name"] . " \|
			City: " . $row["City"] . "</li>";

	}		}
	echo "</ul>";		echo "</ul>";

	} catch(PDOException $e) {		} catch(PDOException $e) {
	echo "Error: " . $e->getMessage();		echo "Error: " . $e->getMessage();
	}		}

	$conn = null; // close connection		$conn = null; // close connection
	?>		?>

Jlebeau81: Created page with "//PHP PDO Connection to MySQL <$php $servername = "localhost"; // Server Name $username = "root"; //mysql username $password = "password"; //Database Password $dbname = "dbname"; //Database Name try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); //set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt =..."

2026-01-07T14:18:46Z

Created page with "//PHP PDO Connection to MySQL <$php $servername = "localhost"; // Server Name $username = "root"; //mysql username $password = "password"; //Database Password $dbname = "dbname"; //Database Name try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); //set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt =..."

New page

//PHP PDO Connection to MySQL

<$php
$servername = "localhost"; // Server Name
$username = "root"; //mysql username
$password = "password"; //Database Password
$dbname = "dbname"; //Database Name

try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
//set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $conn->prepare("SELECT Roll_No, Name, City FROM 'Student Details'");
$stmt->execute();

//set the resulting array to associative
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo "<ul>";
foreach ($result as $row) {
echo "<li>Roll No: " . $row["Roll_No"] . " - Name: " . $row["Name"] . " | City: " . $row["City"] . "</li>";

}
echo "</ul>";

} catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}

$conn = null; // close connection
?>