yPHPzŗēĖ„æā ..
291:nobody³ń
09/02/22 21:55:09 3nGhqmkB
2.phpĶAČŗĢŹčÅ·
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
while ($bUpdatePending) {
try {
$oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
}
catch (PDOException $e) {
// Update failed. Wait a while before trying again in the next loop
sleep(15);
}
}
?>
292:nobody³ń
09/02/22 21:57:20 3nGhqmkB
1.phpĘ2.phpĢį¢ĶAsleep(10)Ŗ é©AČ¢©Ę¢¤¾ÆÅ·B
»źČOĶSƶŷB
SQLiteĶgUNVÉAŹĢgUNVš¶³¹ę¤Ę·éĘ
1bąŅ½øÉudatabase@is@lockedvÉČéĢÅA
EGCg->gCAĘ¢¤š©ŖÅ©Č¢Ę¢ÆÜ¹ńB
±źŖC}C`yµČ¢ÅåĢ|Cg¾Ęv¢Ü·ŖA
»ĢĢ«ūÉĀ¢ÄĢæāÅ·B
Čŗ©fbhbNÉČĮĵܤĢÅ·
293:nobody³ń
09/02/22 21:57:20
¦H[vąÉgUNVH
294:nobody³ń
09/02/22 21:57:55 3nGhqmkB
>>293
¾ĮÄgCµČ¢Ę¢ÆČ¢ķƾ©ēB
Čń©ŌįĮÄéH
295:nobody³ń
09/02/22 22:01:33
įOŖ¶·é|CgĶAbegin©exec©²×½H
296:nobody³ń
09/02/22 22:03:13 3nGhqmkB
>>295
įOͶµČ¢Éå
ø[[[ĮĘĄsĢÜÜÉČĮÄA
ÅćÉĶ^CAEgÉČéń¾Éå
PHPĢftHg^CAEgŖUOb¾©ē
60bÅ^CAEgÉČéÉå
297:nobody³ń
09/02/22 22:04:43
>>296
آآA
įOÉČēČ©Į½ēAfalseŖŻč³źéŵ太B
įOšcatchµÄĢÄÄ龯ŵ太B
298:nobody³ń
09/02/22 22:06:21
beginTransactionÅI[gR~bg[hŖItÉČéB
execÉøs·éB
ą¤źxAbeginTransactionš©ÆéŖAłÉbegin³źÄéĢÅįO¶
ÅAܽ[vB
beginš[vĢOÉo·©catchµ½Ę«É[obNµÄݽēǤ©Ė
299:nobody³ń
09/02/22 22:13:32
EC-CUBEĢJX^}CYÅ1000ÄĄ¢H
æČŻÉ1NA5lS
300:nobody³ń
09/02/22 22:15:02 3nGhqmkB
>>297
»µ½ēAcatchĢÅA
įOšprint·éę¤Éü¢µÄ
ą¤źńµÄŻéę
301:nobody³ń
09/02/22 22:15:38 3nGhqmkB
>>299
źl½č200~µ©ąē¦Č¢¶įń
302:nobody³ń
09/02/22 22:17:17 3nGhqmkB
įOšā«·éę¤ÉR[hšü¢µÄŻÜµ½B
źŌŗĢʱėÉ
catch (PDOException $e) {
print( $e->getMessage());
}
ĮÄüź½¾ÆÅ·ÆĒB
»µ½ēAČŗĢę¤ÉČčܵ½B
303:nobody³ń
09/02/22 22:19:02 3nGhqmkB
PD
Fatal error: Maximum execution time of 60 seconds exceeded in
C:\1.php on line 21
i³Į«ĘƶŹj
--------------------------------------------------------
QD
SQLSTATE[HY000]:
General error: 5
database is locked
There is already an active transaction
There is already an active transaction
There is already an active transaction
Fatal error: Maximum execution time of 60
seconds exceeded in C:\2.php on line 28
--------------------------------------------------------
QDÉĀ¢ÄA¢ÜÜÅoĢȩĮ½
įOŖ|[g³źéę¤ÉČčܵ½B
304:nobody³ń
09/02/22 22:22:34 3nGhqmkB
>>298
exec ĮÄI[gR~bg[hŖONÅČ¢Ęg¦Č¢ĢÅ·©H
൩µÄA
$sql="UPDATE tb1 SET value = value + 1 WHERE id = '1'";
$sth = $dbh->prepare($sql);//vyA[hXe[gg
$sth->execute();//GNXL
[g
Ę©ĮÄāźĪOKH
305:nobody³ń
09/02/22 22:26:36
»¤¶įČÄAbeginĻŻČĢÉbegin·éČĮıĘB
1.phpÅįOŖoȢųĄ[v·éĢĶØ©µ¢©ē`FbNµÄŻ
306:nobody³ń
09/02/22 22:29:18 3nGhqmkB
>>305
biginš[vĢOÉoµ½ēӔȢĢÅĶH
¾ĮÄgCÅ«ČČéµB
307:nobody³ń
09/02/22 22:31:48
>>306
ė[éĪĮ·źĪ¢¢¶įń
>>298³ńŖ³šÅµå
308:nobody³ń
09/02/22 22:34:36 3nGhqmkB
Ęč ¦øķÆķ©ńČČĮÄ«½ĢÅA
ü¢ĻŻĢR[hšüßÄĶčÜ·B
309:nobody³ń
09/02/22 22:35:58 3nGhqmkB
PD
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
while ($bUpdatePending) {
try {
$oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
sleep(10);
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
sleep(1);
}
catch (PDOException $e) {
print( $e->getMessage());
$oDbCxn->rollback();
}
}
?>
310:nobody³ń
09/02/22 22:46:19
1.php¤Ķ[v³¹éĘAeXgÉČēń©ēA
ĄsĢsleep¾ÆÅ¢¢±ĘɵÄA[vOµ½ūŖę³°B
»ź©ēAbNČOĢįOĢą³Ą[vµæį¤ķÆÅEEE
ÜAeXg¾©ē¢¢ÆĒB
311:nobody³ń
09/02/22 22:47:07
įOŖ©ĮÄČ¢ĢÅĶH
312:nobody³ń
09/02/22 22:48:00
gUNVąöµ¢
313:nobody³ń
09/02/22 23:08:50 3nGhqmkB
>>310
»µ½ē[vĶøµÄŻę¤©ČH
314:nobody³ń
09/02/22 23:17:01 3nGhqmkB
ęl¦½ēA[obNµėAĘ©¢¤AhoCXͳӔ¾Č
¾ĮÄdatabase@is@lockedĮÄ¢¤G[ŖoÄ¢éķÆ¾©ēA
gUNVšQbgÅ«Ä¢Č¢ķÆ¾©ēA
»ą»ą[obNČń©µČ¢ķÆÅB
315:nobody³ń
09/02/22 23:19:21 3nGhqmkB
\[XR[hšüϵ½ĢÅA
3.phpĘSDĘ¢¤±Ęɵܵ½B
RD
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
try {
$oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
sleep(10);
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
sleep(1);
}
catch (PDOException $e) {
print( $e->getMessage());
$oDbCxn->rollback();
}
?>
316:nobody³ń
09/02/22 23:20:11
>>315
OęuæāvĮĢĽlH
317:nobody³ń
09/02/22 23:20:13 3nGhqmkB
SD
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
while ($bUpdatePending) {
try {
$oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
}
catch (PDOException $e) {
// Update failed. Wait a while before trying again in the next loop
print( $e->getMessage());
$oDbCxn->rollback();
}
}
?>
318:nobody³ń
09/02/22 23:22:14 3nGhqmkB
RD@|@SD
Ę¢¤ŌÅĄs·é¬źÅ·
RD@|PObŅĀ
SD@|ҽȢŷ®ÉĄs
319:nobody³ń
09/02/22 23:22:53 3nGhqmkB
Ą±Ź
RD@G[³µ
JEgAbvͬ÷µÄ¢é
SD
SQLSTATE[HY000]: General error: 5 database is locked
JEgAbvͬ÷µÄ¢é
320:nobody³ń
09/02/22 23:36:10 3nGhqmkB
źH
൩µÄA®¬H
¬÷µÄ¢éHH
321:nobody³ń
09/02/22 23:38:30
>>314
Čń©Øį¢µÄČ¢©¢H
322:nobody³ń
09/02/23 00:01:27 DYtiHKsN
±źÅ¤Ü¢Į½
VD@|@WD
VD@wait@POseconds
WD@wait@O
VD
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
while ($bUpdatePending) {
try {
$oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
sleep(10);
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
}
catch (PDOException $e) {
sleep(3);
$oDbCxn->rollback();
}
}
?>
323:nobody³ń
09/02/23 00:02:02 DYtiHKsN
WD
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
while ($bUpdatePending) {
try {
$oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
}
catch (PDOException $e) {
sleep(3);
$oDbCxn->rollback();
}
}
?>
324:nobody³ń
09/02/23 00:03:11 DYtiHKsN
ÅąAWDĢÅćĢŁ¤ĢA
sleep(3);
$oDbCxn->rollback();
±źČń¾ÆĒA¹Į©sleepšüź½ĢÉA
sleepµÄ¢éꤷŖ©ēźČ¢B
VDĢĄsŖIķéĘA¦ĄÉ
ŌÆ¢źøÉAWDĢĄsąI¹µÄ¢éB
ČńžH
3bŅĮÄ©ē[obNµÄéń¶įȢ̩H
325:nobody³ń
09/02/23 00:03:49 DYtiHKsN
ĘAgUNVšQbgµÄ¢Č¢ĢÉA
[obN·éĘ¢¤Ó”Ŗķ©ēńB
¢Į½¢Ē±ÉßĮÄ¢éĘ¢¤Ģ¾H
326:nobody³ń
09/02/23 00:16:50
database is lockedĶgUNV©ĢÅĶČA
»ĢĢUPDATE¶ÉεÄĢG[Å éB
ČĢÅAgUNV©ĢĶJn³źÄ¢éĢÅA
źUė[éĪĮÅgUNVšüßÄgUNVšJnµÄ¢éB
327:nobody³ń
09/02/23 00:17:43
źUė[éĪĮÅgUNVšüßÄgUNVšJnµÄ¢éB
źUė[éĪĮÅgUNVšĀ¶ÄAüßÄgUNVšJnµÄ¢éB
328:nobody³ń
09/02/23 00:19:44 DYtiHKsN
>>326-327
ČéŁĒĖ[
ę¤āķ©ĮÄ«½ķ
@«½ķ
@@«½ķ
329:nobody³ń
09/02/23 00:22:06 DYtiHKsN
āĮĻ ź¾ČB
SQLiteĢSĀĢbN̤æA
·®ÉbNšl¾Å«éĢšA
¾¦IɩȢƾ߾ČB
$oDbCxn->beginTransaction();
Ŗ±źŖ_ĮıĘB
ČŗČēAŖ¾ĘAftHgĢbNŖIš³źéB
SQLiteÉØÆéAftHgĢbNĘĶAdefferd@lockÅ éB
±ź¾Ęx·é©ēASĀĢšgUNVÅͳݽ¢A
ČĒĘ¢¤źÉĶsü«B
330:nobody³ń
09/02/23 00:29:36
busy_timeoutĢŻčš·éń¶į¾ßČĢ©H
331:nobody³ń
09/02/23 00:45:25 DYtiHKsN
>>330
āĮ½±Ę éH
332:nobody³ń
09/02/23 00:58:26 DYtiHKsN
ą¤źĀĢOB
SQLiteĶNFSĘ¢¤t@CVXešgĮÄ¢é}VÅĄs·éĘ
ŌĮ±ķźéēµ¢B
NFSĘĶØąÉUNIXÅgķźét@CVXeēµ¢B
ĮÉfreeBSDÅęgķźéēµ¢B
©ŖŖŲčÄ¢é^T[o[ĶfreeBSDČĢÅA
ŠåĮʵÄSQLiteĶg¦Č¢ń¶įČ¢©H
333:nobody³ń
09/02/23 01:02:31
NFSgĮÄé^T[oČńÄČ¢©ēĄSµėw
334:nobody³ń
09/02/23 01:02:40
URLŲŻø(jp.php.net)
qg
NFSp[eBVÉ}Eg³ź½SQLitef[^x[Xš·é±Ę ͧ³źÜ¹ńB
bNÉÖµÄNFS͵¢āčŖ éĢÅA f[^x[XšSI[v·é±Ę³¦Å«Č¢Ā\«Ŗ čÜ·B
Ü ½A¬÷µ½źÅąAbNÉÖ·é®ģĶ\ŖÅ«Č¢Źš¶ŽĀ \«Ŗ čÜ·B
¾ĮijB±Įæ²×éĢŖę¶įČ¢H
335:nobody³ń
09/02/23 01:02:48 DYtiHKsN
SQLiteÉĶA
deferred,
immediate,
exclusive
Ę¢¤RĀĢķŽĢbNŖ éŖA
Ēźšg¤×«©HĘ¢¤ĢĶAl¦ČÄ¢¢ĢH
$dbh->beginTransaction();
±źšg¤ĘA©®IÉAftHgĢAbNŖ
Iš³źéBSQLiteÉØÆéftHgĢbNĘĶ
deferred@bNÅ éB
ąµāsūĄČĒĢĄšµ½¢źA
exclusiveɵȢĘ_ČĢÅĶČ¢©H
ܽAimmediateĮÄAČń̽ßÉ éń¾H
¢Āg¤ń¾H
336:nobody³ń
09/02/23 01:03:21 DYtiHKsN
>>333
ę©Į½
337:nobody³ń
09/02/23 01:07:02
bNĘgUNVĢį¢š×µÄ«½Ł¤Ŗ¢¢ń¶įČ¢©ČH
338:nobody³ń
09/02/23 01:07:46
“໤v¤
339:nobody³ń
09/02/23 01:29:03
±¢ĀO¢½LeB¾ė
ŹńµÜµ½Ę©sqliteÖAÅ
éŁĒ«ńŽ
340:nobody³ń
09/02/23 01:29:11
WikiĘCMSĮÄǤį¤Ģ
341:nobody³ń
09/02/23 01:36:09
>>316šX[µÄé_Åmč
342:nobody³ń
09/02/23 01:38:00
>>340
WikiąCMSĢźķ¾ę
WikiŖ¼ĢCMSĘį¤ĢĶAsĮč½ÉęéTCg\zšåĢʵ½\¬ÉČĮÄ¢é
Ā©PHPÖWČ¢¶įń
343:nobody³ń
09/02/23 02:23:27 DYtiHKsN
൩µÄwhile¢ēČ¢ń¶įČ¢©H
sleepµÄrollback¾ÆÅ¢¢ń¶įČ¢©H
344:nobody³ń
09/02/23 03:33:25
±¢ĀvOĀĢūĘ}`¾Į½
½ŚŲŻø(techĀ:284-Ō)
345:nobody³ń
09/02/23 03:44:00
hę̽}ļČĒÅAļ”š·©źé±ĘŖ čÜ·B
Ģļ”ĶLxÅŗLĢĘØčÅ·B
EAjAGQAÆlAAj\
EAXgbvÓÜ
EŗDAHtnAChCxgQĮ
µ©µA±źš¾¤ĘAØ»ēŠ©źÄµÜ¢Ü·BBB
Čńľ¦Īę¢Ģŵ天H
xŻĢśĶ½šµÄéHĘ·©źÄąAŗDCuĢÅOüÅ
TCEšąĮÄAµńÅ¢éČńľ¦Ü¹ńB
346:nobody³ń
09/02/23 04:39:47 cBNbBaFX
$a = "aaa"
if(preg_match("/^[0-9]+$/",$a) == true){
echo "ok";
}else{
echo "dame";
}
ÅdameÉČĮÄźéĢÉ(if(preg_match("/^[0-9]+$/",$a)Åą¢Æ½)A
if(preg_match("/^[0-9]+$/",$a) !== false){
echo "ok";
}else{
echo "dame";
}
¾Ę$aš½ÉµÄąSokÉČéEE
ČńÅ
347:nobody³ń
09/02/23 04:40:33 cBNbBaFX
Ø$a = "aaa";
348:nobody³ń
09/02/23 04:52:33
>>346
URLŲŻø(jp.php.net)
349:nobody³ń
09/02/23 05:29:48 DYtiHKsN
<?php
try {
$oDbCxn = new PDO('sqlite:test1');
$oDbCxn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
die("Error connecting to DB");
}
$bUpdatePending = true;
while ($bUpdatePending) {
try {
$oDbCxn->query("BEGIN EXCLUSIVE TRANSACTION");
// $oDbCxn->beginTransaction();
$oDbCxn->exec("UPDATE tb1 SET value = value + 1 WHERE id = '1'");
$oDbCxn->commit();
$bUpdatePending = false; // Exit the loop now the update has been done
}
catch (PDOException $e) {
print $e->getMessage();
$oDbCxn->rollback();
}
}
?>
350:nobody³ń
09/02/23 05:30:39 DYtiHKsN
>>349
Ąs·éĘAČńÅG[ÉČéĢH
PHP5 + PDO + SQLite3
----------------------------------
database structure
id | name| value
1 | value| 5
-------------------------------
database name = test1
table name= tb1
351:nobody³ń
09/02/23 05:33:14 DYtiHKsN
gUNVšX^[g·éĢÉA
$oDbCxn->query("BEGIN EXCLUSIVE TRANSACTION");
Ķ_ÅA
$oDbCxn->beginTransaction();
ČēĒ¢AĘ¢¤ĢĶØ©µ¢B
ČŗG[ÉČéĢH
352:nobody³ń
09/02/23 06:48:25 c878IibK
³¦Äŗ³¢B
test.txt Ę¢¤utf-8Ģt@CŖ ĮÄɶʩphpĢĻĘ©Ŗ¢Ä čÜ·B
±źšsjisĢtest.phpÅĒŻŻ\¦³¹½¢ĢÅ·Ŗincude¾Ę¶»ÆµÜ·B
Ǥ·źĪ\¦Å«Ü·©H
353:nobody³ń
09/02/23 06:59:44
<meta http-equiv="Content-Type" content="text/html; charset=Shift-JIS" />
šf¢Äāé
354:nobody³ń
09/02/23 07:08:52
>>353
»ĢmÆÅńµę¤Ęv¦éČńÄf¼É“S·éę
355:nobody³ń
09/02/23 07:20:40 cBNbBaFX
>>348
©ŖČčɲ×įܵ½
mb_eregÅĶ !== false ŢƽĢÅA»źąźÉä×ÄŻ½ē
ŌčlĢʱŖA
mb_ereg
³K\»ÉźvµČ¢©A G[š¶µ½źÉ FALSE šŌµÜ·B
preg_match
preg_match() ĶAG[Ŗ¶µ½źÉFALSEšŌµÜ·B
ŵ½B
preg_matchͳK\»ÉźvµČ¢Ę«ĶfalsešŌµÄźČ¢ĢÅA
!== falseŖX[³ź½Ę¢¤±ĘÅę¢Ģŵ天H
”ÜÅS!== falseÅÅ«éĘvĮÄÄ»źÅāĮĽĢÅĻXŖåĻÅ·Ŗ
preg_matchĢĘ«Ķ==Ę©½ąĀÆČ¢o[WÅāĮÄØ«Ü·
čŖĘ¤²“¢Üµ½
356:nobody³ń
09/02/23 07:29:25
>>352
t¾UTF-8Ģū
¼ūg¢½¢ČēĻ·©Æé×µ
357:nobody³ń
09/02/23 16:02:31
OS linux
PHP ver 5.2.5
Ag@ĘÉȵ
<?
//------------------------------------------------
//ybgĀŪ
//------------------------------------------------
function GetPet_F($int)
{
$res = "";
if($int=="0") $res = "sĀ";
else $res = "Ā\";
return $res;
}
print GetPet_F(0);
?>
Čć\[XR[hÅsyntax error, unexpected $endoéńÅ·Ŗ½Ŗ“öČńŵ天EEE
358:357
09/02/23 16:02:51 yJ3BEx4Z
IDo·ĢYź
359:nobody³ń
09/02/23 16:12:39
źA¬oµÄéH
360:nobody³ń
09/02/23 16:31:29
>>352
eval(mb_convert_encoding(file_get_contents('test.txt'), 'Shift-JIS', 'UTF-8'));
>>357
\¶ÉŌį¢ĶČ¢©ē
XNvgĢGR[fBOŖ mbstring.script_encoding ĘĮÄČ¢ńŵå¤
361:nobody³ń
09/02/23 16:37:17 yJ3BEx4Z
Ā\Ģ\²¢½ēG[oČ©Į½Å·EEE
ČńČ̾ė¤
362:nobody³ń
09/02/23 16:46:30
>>357
“öĶAShift JisĢ5Cāč¾ĖB
\ĢShift JisĢR[hŖ94 5C
TCĶobNXbV
iShift Jis¾Ę¥)ČĢÅA
PHPĢp[TŖAIķčĢ_uNH[e[Vš¶ńĘFƵĵܤB
ŹA¶ńŖĀ¶ēźÄ¢Č¢Ę»f³źÄAG[ÉČéB
363:nobody³ń
09/02/23 17:31:12
”SJISÅXNvgāĀČńÄ¢ńĢH
bĶĻķéŖ
echo '<table `'.
'`````````'.
'`````````'.
'`````````'.
'`````````';
ųp¬ÅvOĢ\[XR[h©½ē±¤ČĮĽ
ܶČֵğEEEorz
ĘAƶvĢÅechoÅJavaScriptĘ©f«oµÄéĢąāßÄź
NGĶܾ¹é
dÅvO·éĘ«ĶŁ©ĢlÉķ©čā·¢R[hɵľ³¢
±źÜ¶ÅØč¢
364:nobody³ń
09/02/23 17:59:46
--enable-zend-multibytetÆÄmbstring.script_encodingšŻč·čį
Shift-JIS¾ė¤Ŗ½Å±¤Ŗ»¢ĀĢ©R¾
GkXÉsÆNY
365:nobody³ń
09/02/23 21:03:10 cBNbBaFX
ܽæā³¹Ä¢½¾«Ü·
$aa = "AA";
$bb = "bb";
$sql = "SELECT * FROM v001upfile WHERE :AA = :BB";
$result = executeQuery($sql);
$result->bindParam(":AA",$aa,PDO::PARAM_STR);
$result->bindParam(":BB",$bb,PDO::PARAM_STR);
$result->execute();
$row = $result->fetchAll();
$rows = count($row);
Ģę¤É·éĘAwhereÉY·éf[^ŖČA$rowsą0ÉČĮĵܢܷB¢ė¢ėµÄ¢éĘA
$sql = "SELECT * FROM v001upfile WHERE AA = :BB";
Ę·éĘf[^Ŗ¾ēźÜµ½B
Ǥāēwhere :AAĢbindĢp[^APDO::PARAM_STR
ÅA'AA'ƳźÄµÜĮÄ¢é©ēHA¾ßĢę¤ČCŖ·éĢÅ·ŖA
šō čܵ½ēę뵨˪¢µÜ·
366:nobody³ń
09/02/23 21:21:42
>>365
»źŹŚ¾A“ąYń¾
WHERE $AA = ?©A ? = ?ɵ½ę
SELECTÅbindValueĘbindParamĶgķČ¢ūŖ¢¢ĮÄ
O[Oę¶Ŗ¾ĮĽ
367:nobody³ń
09/02/23 21:33:37
PDO::PARAM_STMT
368:nobody³ń
09/02/23 21:36:22
J¼ÉPARAM_STRg¤Čę
Az©
369:nobody³ń
09/02/23 22:03:46 ikSisMyc
yOS¼zCentOS 5.0
yPHPĢo[Wzphp5.2
yAg\tgEFAzJavaScript Smarty
yæāąez
[UŖOCɬ÷µ½Ę«ÉZbVÉlšZbgµÄ
Éy[WÉANZXµÄ«½ÉSmartyÅlŖ é©mFµÄś»
įF
{{if $smarty.session.foo == 'bar'}}
init(); //±źĶJScriptĢÖ
{{/if}}
šµ½¢ńÅ·ÆĒAuEUšI¹·éĘZbVÜÅjü³źÄµÜ¢Ü·B
²³öØč¢¢½µÜ·B
370:nobody³ń
09/02/23 22:06:30 cBNbBaFX
>>366
sql¶É¼ŚĻüźéū@ŵܵ½Būܵ½B
čŖĘ¤²“¢Üµ½
>>367,368
āĮÄŻ½ĢÅ·ŖA½ĘµÄĶ356ĘŁŚÆ¶Åµ½
}j
AĢp[^źĢąĢš¢ė¢ėć¦ÄāĮÄŻ½ĢÅ·Ŗ
Ǥą¤Ü¢«Ü¹ńŵ½B
371:nobody³ń
09/02/23 22:12:39
>>369
ZbVĶuEUšI¹·éĘjü³źéąĢÅ·
p±µ½¢ČēNbL[šg¤Ę¢¢ę
372:nobody³ń
09/02/23 22:28:00
>>370
»Ģ¢ė¢ė©¦ÄāĮÄŻ½AĢɳšŖüĮÄČ¢ķÆ¾ČB
rbgaĶĘĮ½Ģ©BÜA¢¢āBhNZ
373:nobody³ń
09/02/23 22:55:40 DYtiHKsN
ČŗEXCLUSIVEĶgUNVJn¼ćÉ
W[it@Cšģ¬µČ¢Ģ©H
374:nobody³ń
09/02/23 22:59:36
Az©
375:369
09/02/23 23:03:42
>>371
PHPSESSIDšNbL[Éi[·édlƨᢵÄܵ½B
čŖĘ¤²“¢Üµ½B
376:nobody³ń
09/02/24 00:24:39 r/vu3Jnx
@@@@@@@@@ æQ
@@@@@@@@@ @qqq@R
@@@@@@@@@@q½@@}
@@ æQQQæ@ |@@ |
@@ | m@@@@@ R !@@ !
@@/@@@@@ |@@/
@ |@@@@( __)@ ~^ RRÜÅAzĪ©č
@c¤@@@|¾|@@^
/@QQ@ Rm@/
(QQQj@@@/
377:nobody³ń
09/02/24 07:08:35
pdoÅ}ÉinsertÅ«ČČĮ½EE
G[ȵŽąČIķĮÄéĢÉĢSĢinsert¾ÆÅ«Ä¢Č¢EE
ÅVX\¦XbhĢõŽXźbčĢj
[XØÜ©¹Xg„IvVš\¦ÉĀŌµ2ch
5367śOÉXV/104 KB
S:undef