PHP? SQL ?? ??
??? ?? ?? ?? ??? ??? SQL ??? ???? SQL ??? ?? ?? ???? ?????. ??? ?? ??? ?? ??? ??????.
$unsafe_variable = $_POST['user_input'];
mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')");
? ????? value'? ?? ??? ?? ???? ?? ??? ? ????. DROP TABLE ???;-- ?? ??? ???:
INSERT INTO `table` (`column`) VALUES('value'); DROP TABLE table;--')
?? ??
??? ??? ????? ???? ???? ????? SQL?? ???? ???? ?? ??????. SQL ????? ???? ???? ????. ?????? ??? ??? ??? ?? SQL ?? ???? ?? ???? ??? ???? ?????. ?????? ??? SQL ?? ?? ???? ????? ?? ??? ???? ???? ???? SQL ?? ??? ????? ?????.
Prepared ? ??
PDO
$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');
$stmt->execute([ 'name' => $name ]);
foreach ($stmt as $row) {
// Do something with $row
}
MySQLi for MySQL (PHP 8.2 )
$result = $db->execute_query('SELECT * FROM employees WHERE name = ?', [$name]);
while ($row = $result->fetch_assoc()) {
// Do something with $row
}
MySQLi for MySQL(?? PHP 8.1)
$stmt = $db->prepare('SELECT * FROM employees WHERE name = ?');
$stmt->bind_param('s', $name); // 's' specifies the variable type => 'string'
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
// Do something with $row
}
PDO ? MySQLi? ?? ?? ?? ??
PDO
????? PDO? ?????? ??? ?? ?????. MySQL? ?? ?????? ?????? ?? ??? ?? ????? ??? ?????.
$dbConnection->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
MySQLi
????? ??? ?????.
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); // error reporting
$dbConnection = new mysqli('127.0.0.1', 'username', 'password', 'test');
$dbConnection->set_charset('utf8mb4'); // charset
??? ? ??
??? ???? ?? ? ?????? ??? ?? ?? ???? ??????. ????? ?????? ??? ??? ??? ??? ?????. ?? ??? ??? ?? ??? ? ???? ?? SQL ???? ?? ?? ?? ?????. ??? ?? ???? ?? SQL ???? ??? ? ?? ?? ??? ??? ??? ? ????.
?? ??
??? ?? ?? ??? ???? ?? ???? ???? ????. ??? ?? ??? ?? ???? ?????? ??? ???? ???.
? ??? ??? ?? ??? PHP?? SQL ??? ??? ? ????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
??? ??
8637
17
1783
16
1728
56
1577
28
1442
31
PHP?? ?? ? ??? ????? ?????????
Jun 20, 2025 am 01:03 AM
TOSECURELYHANDLEAUSTENCENDACTIONANDACTERIZINGINPHP, FORCUCTSESTEPS : 1. ALWAYSHASHPASSWORTHPASSWORD_HASH () ? VERVERIFYUSINGPANSWORD_VERIFY (), usePREPAREDSTATEMENTSTOPREVENTSQLINGERGED, andSTOREUSERSESSEATAIN $ _SESSIONSAFTERLOGIN.2.impleplempletrole ?? ACCESSC
PHP?? ?? ???? ??? ??? ?? ? ? ???????
Jun 19, 2025 am 01:05 AM
PHP?? ?? ???? ???? ????? ??? ?? ??? ???? ?? ??? ??? ??? ???? ????. 1. finfo_file ()? ???? ?? ?? ??? ???? ???/jpeg? ?? ?? ?? ? ?????. 2. uniqid ()? ???? ??? ?? ??? ???? ? Web ?? ????? ??????. 3. php.ini ? html ??? ?? ?? ??? ???? ???? ??? 0755? ?????. 4. Clamav? ???? ???? ???? ??? ??????. ??? ??? ?? ???? ????? ???? ?? ??? ????? ???? ??? ? ??? ?????.
PHP?? == (??? ??)? === (??? ??)? ???? ??????
Jun 19, 2025 am 01:07 AM
PHP?? ==? ==? ?? ???? ?? ??? ??????. == ?? ??? ?? ?? ?????. ?? ??, 5 == "5"? true? ????, ?? ??? ???? ?? ?? ??? ????? ????? (? : 5 === "5"? false? ?????. ?? ?????? ===? ? ???? ?? ?????? == ?? ??? ??? ???? ?????.
php (, -, *, /, %)?? ?? ??? ??? ??????
Jun 19, 2025 pm 05:13 PM
PHP?? ?? ??? ??? ???? ??? ??? ????. 1. ?? ??? ?? ? ?? ??? ??? ???? ???? ??? ? ????. ??? ??? ???? ????? ????? ???? ????. 2. ?? ?? ?? - ??, ??? ???? ?? ??? ?????. 3. ?? ???? ??? ??? ???? ??? ??? ?????. 4. Division? / ??? ???? 0?? ??? ?? ????? ??? ?? ??? ?? ? ? ????. 5. ???? ??? ???? ?? ?? ? ?? ??? ???? ? ??? ? ???, ??? ?? ? ? ??? ??? ???? ?????. ? ???? ???? ???? ??? ??? ??? ???? ?? ??? ? ??????? ????.
PHP? NOSQL ?????? (? : MongoDB, Redis)? ??? ?? ??? ? ?????
Jun 19, 2025 am 01:07 AM
?, PHP? ?? ?? ?? ?????? ?? MongoDB ? Redis? ?? NOSQL ??????? ?? ??? ? ????. ?? MongoDBPHP ???? (PECL ?? Composer? ?? ??)? ???? ????? ????? ??? ?????? ? ???? ????? ??, ??, ?? ? ?? ??? ?????. ??, Predis ????? ?? Phpredis ??? ???? Redis? ???? ?? ? ?? ? ??? ???? ??? ????? Phpredis? ???? ?? Predis? ?? ??? ?????. ? ? ?? ??? ???? ? ????? ????.
?? PHP ?? ? ?? ??? ??? ?? ??? ??????
Jun 23, 2025 am 12:56 AM
tostaycurrentwithphpdevelopments ? bestpractices, followkeynewssources lifephp.netandphpweekly, adgytwithcommunitiesonforumsandconferences, readlingupdated andgrad indewfeatures, andreadorcontributetoopensourceproceprosts.first
PHP ? ???? ? ??? ? ??????
Jun 23, 2025 am 12:55 AM
phpbecamepupularforwebdevelopmentduetoiteofleneflening, whithhtml, wididepreadhostingsupport, andalargeecosystemincludingframeworkslikelaravelandcmsplatformsformslikewordpress.itexcelsinhandlingformsubmissions, managingussess, interptisussivers, ?? ???
PHP ???? ???? ???
Jun 25, 2025 am 01:00 AM
TOSETTHERIGHTTIMEZONEINPHP, usedate_default_timezone_set () functionattStartOfyourscriptwitHavalidInlifiersuchas'America/new_york'.1.edate_default_timezone_set () beforeanydate/timeFunctions.2
