??? MySQL ?? ?? ??
? ??? ??? MySQL ??? ???? ???? ??? PHP ?? ??? ???? ????. ??? ??? ???? mysql_* ??? ??? ???? ??? ???? ???.
- SQL ??
- ?? ?? ??
- ?? ??? ????(XSS) ??
?? ??:
<?php
header('Content-type: text/html; charset=utf-8');
error_reporting(E_ALL | E_STRICT);
ini_set('display_errors', 1);
$config = [
'host' => '127.0.0.1',
'user' => 'my_user',
'pass' => 'my_pass',
'db' => 'my_database'
];
$connection = @mysql_connect($config['host'], $config['user'], $config['pass']);
if (!$connection) {
trigger_error('Unable to connect to database: ' . mysql_error(), E_USER_ERROR);
}
if (!mysql_select_db($config['db'])) {
trigger_error('Unable to select db: ' . mysql_error(), E_USER_ERROR);
}
if (!mysql_set_charset('utf8')) {
trigger_error('Unable to set charset for db connection: ' . mysql_error(), E_USER_ERROR);
}
$result = mysql_query(
'UPDATE tablename SET name = "' . mysql_real_escape_string($_POST['name']) . '" WHERE id = "' . mysql_real_escape_string($_POST['id']) . '"'
);
if ($result) {
echo htmlentities($_POST['name'], ENT_COMPAT, 'utf-8') . ' updated.';
} else {
trigger_error('Unable to update db: ' . mysql_error(), E_USER_ERROR);
}
?>
??:
- ? ??? mysql_connect()? ???? MySQL ??????? ???? mysql_select_db? ?? ??? ??????? ?????. ().
- mysql_set_charset() ??? ???? ?????. UTF-8 ??? ?? ?? ?????.
- SQL ???? ??? SQL ??? ???? ?? ?? ???? mysql_real_escape_string() ??? ???? ?????.
- ?? ??? ????, "$name? ?????????."?? ???? ?????. ????? ???? ? ?????. ??? ??? ??? ?????.
- ?? ?? ? ?? ???? ?? ?? ??? ??????. ???? ????? ? ??? ?????? ?? ????? PHP ?? ???? ???? ??? ? ? ????.
? ?? ??? ????? ???? ?? PHP ??????? ?? ??? ????? ?????? ? ???. . ??? ??? ??? ????? ?? MySQL ???????? PDO ??? ???? ?? ????.
? ??? PHP?? MySQLi ??? ???? MySQL ??????? ???? ?????? ??? ??????? ?? ?????. ??? ??? 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)
??? ??
8644
17
1787
16
1730
56
1582
29
1449
31
PHP?? ?? ? ??? ????? ?????????
Jun 20, 2025 am 01:03 AM
TOSECURELYHANDLEAUSTENCENDACTIONANDACTERIZINGINPHP, FORCUCTSESTEPS : 1. ALWAYSHASHPASSWORTHPASSWORD_HASH () ? VERVERIFYUSINGPANSWORD_VERIFY (), usePREPAREDSTATEMENTSTOPREVENTSQLINGERGED, andSTOREUSERSESSEATAIN $ _SESSIONSAFTERLOGIN.2.impleplempletrole ?? ACCESSC
?? 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
?? ?? (Windows, MacOS, Linux)? PHP? ????? ???????
Jun 20, 2025 am 01:02 AM
PHP ?? ??? ?? ???? ????. ??? ?? ?????. 1. Windows ???? XAMPP? ???? ???? ????? ???? ???? XAMPP? ?????? ???? PHP ?? ??? ????? ?? ??? PHP? ?? ? ? ????. 2. MACOS ???? ???? ?? PHP? ???? ?? ??? ???? Apache ??? ???? ?? ? ? ????. 3. Linux ??? (Ubuntu/Debian)? APT ??? ???? ???? ??? ?????? PHP ? Common Extensions? ???? ??? ??? ???? ??? ????? ??? ? ????.
PHP?? ??? ??? ???? ?? ??? ????? ??? ??????
Jun 22, 2025 am 01:00 AM
TovalidateUserInputInphp, useBuilt-invalidationFunctions likefilter_var () ? filter_input (), applyRegulArexPessionSforCustomFormatsSuchasUsUserPhonEnumbers, CheckDatatypesFornumericValuesLikeAgeArPrice, setLtrimtsAnspacetReopeTopeTopeTopePeTopePeTopePeTopeTopeTopeTlyout
session_destroy ()? ???? PHP? ??? ??? ??????
Jun 20, 2025 am 01:06 AM
PHP?? ??? ??? ????? ?? Session_Start ()? ???? ??? ??? ?? Session_Destroy ()? ???? ?? ?? ???? ???????. 1. ?? ?? _start ()? ???? ??? ?????? ??????. 2. ?? ?? ?? ???? ???? Session_Destroy ()? ?????. 3. ?? ????? ?? : ?? ??? ????? ???? $ _session ??; 4. ???, ???? ?? ??? ???? ???? ?? ??? ??????. 5. ????? ?? ? ???? ?????? ???? ???? ?? ??? ?? ????? ??? ??? ?? ???????. ????? ???? ?? ??? ??? ?? ???? ??? ?? ? ? ????.
php (serialize (), unserialize ())? ??? ??? ? ??????
Jun 22, 2025 am 01:03 AM
thephpfunctionserialize () andunserialize () areusedtoconvertcomplexDattoresintostorasandabackagain.1.serialize () c onvertsDatalikeCarraysorObjectSrayStringStringStrainingTainingTypeanDtuctureIncomation.2.
