PHP Se SQL Server Database Kaise Connect Karein? — Step-by-Step Guide
PHP Se SQL Server Database Kaise Connect Karein? — Step-by-Step Guide
Introduction
Aaj ke zamaane me web aur mobile applications banane ke liye backend databases ka use hota hai. SQL Server (Microsoft SQL Server) ek popular relational database management system hai jo enterprise level applications me bahut use hota hai.
Is article me hum seekhenge ki PHP se SQL Server database kaise connect karein, taaki hum apni applications ke liye dynamic data store aur retrieve kar sakein.
SQL Server Aur PHP Integration Ka Overview
PHP me SQL Server se connect karne ke liye Microsoft ne official SQLSRV driver provide kiya hai. Ye driver Windows ya Linux dono pe install kiya ja sakta hai.
Is driver ki madad se hum SQL Server database me queries run kar sakte hain, data fetch kar sakte hain, aur APIs bana sakte hain jo frontend apps (jaise Android) use kar sakti hain.
Step 1: SQL Server Connection Setup in PHP
Sabse pehle hume apne PHP script me SQL Server se connection establish karna hota hai.
$username,
"PWD" => $password,
"Database" => $dbname
);
$conn = sqlsrv_connect($serverName, $connectionInfo);
if (!$conn) {
// Connection failed
$response = array(
'status' => false,
'message' => "Connection failed: " . print_r(sqlsrv_errors(), true)
);
echo json_encode($response);
exit();
} else {
// Connection success
$response = array(
'status' => true,
'message' => "Connected to SQL Server database successfully!"
);
echo json_encode($response);
}
?>
]]>
Notes:
\\double backslash SQL Server instance name ke liye zaroori hai.sqlsrv_connectfunction Microsoft SQL Server driver se aata hai.- Agar connection fail ho to
sqlsrv_errors()se error details milengi. - Response JSON format me diya gaya hai taaki frontend ya apps easily parse kar sakein.
Step 2: SQL Queries Run Karna
Connection ke baad aap queries run kar sakte hain jaise SELECT, INSERT, UPDATE, DELETE.
Example: SQL Server se data fetch karna
]]>
Is code me:
sqlsrv_queryse query run karte hain.sqlsrv_fetch_arrayse result ko associative array me fetch karte hain.- JSON format me data return karte hain, jo frontend ke liye friendly hota hai.
Step 3: PHP API Banaye Jo Android App Use Kar Sake
Aap apni queries ko PHP API ke form me bana ke Android app, web app, ya kisi bhi frontend me use kar sakte hain.
Example: User list dene wali API
$username, "PWD" => $password, "Database" => $dbname);
$conn = sqlsrv_connect($serverName, $connectionInfo);
if (!$conn) {
echo json_encode(['status' => false, 'message' => 'Connection failed', 'error' => sqlsrv_errors()]);
exit();
}
$sql = "SELECT id, username, email FROM users";
$stmt = sqlsrv_query($conn, $sql);
if ($stmt === false) {
echo json_encode(['status' => false, 'message' => 'Query failed', 'error' => sqlsrv_errors()]);
exit();
}
$data = array();
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
$data[] = $row;
}
echo json_encode(['status' => true, 'data' => $data]);
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>
]]>
Important Tips
- SQL Server ke liye PHP driver install karna zaroori hai.
- Connection info me instance name aur IP/hostname sahi dena chahiye.
- Error handling hamesha karein taaki debugging aasaan ho.
- API response hamesha JSON format me bhejna best practice hai.
- Security ke liye aap stored procedures ya parameterized queries use karein SQL Injection se bachne ke liye.
Conclusion
Is article me aapne seekha:
- PHP me SQL Server se connection kaise banaye
- Basic queries kaise run karein
- Simple JSON API kaise banayein jo mobile app ya web app use kar sake
Agar aap apni Android app ke liye backend PHP API banate hain to ye steps follow karke aap apne SQL Server data ko app me easily use kar sakte hain.
About the Author
Rehan Khan, Software Developer, Blogger
Website: earnwithrehan86147.blogspot.com
Comments
Post a Comment