CATALOG WHERE catalogId=??™???.$catalogId.?????™???);
$r = oci_execute($stmt);
$nrows = oci_fetch_all($stmt, $result);
if($nrows==0){
$objResponse-
>addAssign(???validationMessage???,???innerHTML???,???Catalog
Id is Valid???);
$objResponse-
>addAssign(???submitForm???,???disabled???,false);
$objResponse->addAssign(???journal???,???value???,??????);
$objResponse->addAssign(???publisher???,???value???,??????);
$objResponse->addAssign(???edition???,???value???,??????);
$objResponse->addAssign(???title???,???value???,??????);
$objResponse->addAssign(???author???,"value???,??????);
}
if($nrows>0){
$objResponse-
>addAssign(???validationMessage???,???innerHTML???,???Catalog
Id is not Valid???);
$catalogId=$result[???CATALOGID??™][0];
$journal=$result[???JOURNAL??™][0];
$publisher=$result[???PUBLISHER??™][0];
$edition=$result[???EDITION??™][0];
$title=$result[???TITLE??™][0];
$author=$result[???AUTHOR??™][0];
$objResponse->addAssign(???journal???,???value???,$journal);
$objResponse-
>addAssign(???publisher???,???value???,$publisher);
$objResponse->addAssign(???edition???,???value???,$edition);
$objResponse->addAssign(???title???,???value???,$title);
$objResponse->addAssign(???author???,???value???,$author);
$objResponse-
>addAssign(???submitForm???,???disabled???,true);
}
return $objResponse->getXML();
}
174 8 Ajax with PHP-Xajax
function updateCatalog($formValues){
$catalogId=trim($formValues[???catalogId??™]);
$journal=trim($formValues[???journal??™]);
$publisher=trim($formValues[???publisher??™]);
$edition=trim($formValues[???edition??™]);
$title=trim($formValues[???title??™]);
$author=trim($formValues[???author??™]);
$username=??™OE??™;
$password=??™password??™;
$db=??™(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)??™;
$connection = oci_connect($username, $password, $db);
$sql = ???INSERT INTO OE.
Pages:
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161