本文整理汇总了PHP中mydb::getAll方法的典型用法代码示例。如果您正苦于以下问题：PHP mydb::getAll方法的具体用法？PHP mydb::getAll怎么用？PHP mydb::getAll使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mydb的用法示例。
在下文中一共展示了mydb::getAll方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: error
//Fehlerinstanz
$api = php_sapi_name();
$err = new error($api);
include_once "dblib.php";
include_once "pepper.php";
include_once "erplib.php";
$erpdb = new mydb($ERPhost, $ERPdbname, $ERPuser, $ERPpass, $ERPport, 'pgsql', $err, $debug);
$shopdb = new mydb($SHOPhost, $SHOPdbname, $SHOPuser, $SHOPpass, $SHOPport, 'mysql', $err, $debug);
$sql = "SELECT * FROM custom_variable_configs WHERE name = 'pepperkunde'";
$rs = $erpdb->getOne($sql);
if (isset($rs['id'])) {
$cvarid = $rs['id'];
} else {
exit;
}
$sql = "SELECT k_ID,Kunden_NR FROM kunde WHERE Kunden_NR != '0'";
$kunden = $shopdb->getAll($sql);
$sqlkdnr = "SELECT id FROM customer WHERE customernumber = '%s' ";
$sqldel = "DELETE FROM custom_variables WHERE config_id={$cvarid} AND trans_id=";
$sqlins = "INSERT INTO custom_variables (config_id,trans_id,text_value) VALUES ({$cvarid},%d,'%s')";
$i = 0;
if ($kunden) {
foreach ($kunden as $nr) {
$rs = $erpdb->getOne(sprintf($sqlkdnr, $nr['kunden_nr']));
if (isset($rs['id'])) {
echo $nr['k_id'] . " -> " . $nr['kunden_nr'] . "\n";
$rc = $erpdb->query($sqldel . $rs['id']);
$rc = $erpdb->query(sprintf($sqlins, $rs['id'], $nr['kunden_nr']));
}
}
}