OC Coding Style: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
fixed some syntax errors at ends of SQL-Strings
Keine Bearbeitungszusammenfassung |
(fixed some syntax errors at ends of SQL-Strings) |
||
| (10 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt) | |||
| Zeile 11: | Zeile 11: | ||
== PHP == | == PHP == | ||
All | All contributed or modified code sections must fully comply to the [http://www.php-fig.org/psr/psr-2/ PSR-2] standard (which includes [http://www.php-fig.org/psr/psr-1/ PSR-1]), with these exceptions: | ||
* When referencing identifiers (e.g. class and function names) that are defined in non-PSR-2-compliant source code files, | * When referencing identifiers (e.g. class and function names) that are defined in non-PSR-2-compliant source code files, their names need not be PSR-2 compliant. | ||
* When writing | * When writing standalone scripts like those in the 'local', 'util' and 'util2' directories, they need not to comply to the PSR-1 "Side Effects" rule. | ||
Only <code><?php</code> and <code><?=</code> open tags must be used. <code><?</code> (short open tags) must not be used. | Only <code><?php</code> and <code><?=</code> open tags must be used. <code><?</code> (short open tags) must not be used. | ||
| Zeile 28: | Zeile 28: | ||
"SELECT `cache_id`, `wp_oc` | "SELECT `cache_id`, `wp_oc` | ||
FROM `caches` | FROM `caches` | ||
JOIN `cache_logs` ON `cache_logs`.` | JOIN `cache_logs` ON `cache_logs`.`cache_id` = `caches`.`cache_id` | ||
WHERE `caches`.`status` IN ('&1', '&2')" | WHERE `caches`.`status` IN ('&1', '&2')", | ||
$status1, | $status1, | ||
$status2 | $status2 | ||
); | ); | ||
Note that the | Note that the opening " is on a tab position, while the following lines start one column to the right. | ||
If lines get too long, the parameters are moved to the next line(s) and indented to the next | If lines get too long, the parameters are moved to the next line(s) and indented to the next indent column (which is ''three'' chars right of the preceding line's keyword): | ||
$result = sql( | $result = sql( | ||
| Zeile 43: | Zeile 43: | ||
`caches`.`type` AS `cache_type`, | `caches`.`type` AS `cache_type`, | ||
`cache_logs`.`date` AS `log_date`, | `cache_logs`.`date` AS `log_date`, | ||
`cache_logs`.`type` AS `log_type` | `cache_logs`.`type` AS `log_type` | ||
FROM `caches` | FROM `caches` | ||
JOIN `cache_logs` | JOIN `cache_logs` | ||
ON `cache_logs`.` | ON `cache_logs`.`cache_id` = `caches`.`cache_id` | ||
AND `cache_logs`.`type` = '&1' | AND `cache_logs`.`type` = '&1' | ||
WHERE | WHERE | ||
`caches`.`status` = '& | `caches`.`status` = '&2' | ||
AND `cache_logs`.`user_id` = '& | AND `cache_logs`.`user_id` = '&3'", | ||
$cacheStatus | $logType, | ||
$cacheStatus, | |||
$userId | $userId | ||
); | ); | ||
[[Kategorie:Entwicklung|Coding Style]] | |||
[[Kategorie:English pages]] | |||