vlad275
Новичок
Сейчас пытаюсь вызвать хранимую процедуру из PHP. Получаю ошибку Как получить данные?
Сейчас пытаюсь вызвать хранимую процедуру из PHP. Получаю ошибку
Как получить данные?
Хранимая процедура рекорд сет возвращает:
Сейчас пытаюсь вызвать хранимую процедуру из PHP. Получаю ошибку
Как получить данные?
Код:
<?php
//ini_set('display_errors',1);
error_reporting(E_ALL ^E_NOTICE);
mysql_connect("localhost", "16261_dba", "vova33");
mysql_select_db("variantdialog_99k_db1");
// $query = "SELECT * FROM tCandidates";
$query = "CALL pSelect2()";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo $row["intID"]."<br />";
echo $row["varcharStatus"]."<br />";
echo $row["timestampUpdate"]."<br />";
echo $row["dateProlongation"]."<br />";
echo $row["timestampInsert"]."<br />";
echo $row["intBirthday"]."<br />";
echo $row["intBirthmonth"]."<br />";
echo $row["intBirthyear"]."<br />";
echo $row["varcharName"]."<br />";
echo $row["varcharSecondname"]."<br />";
echo $row["varcharFamilyname"]."<br />";
echo $row["varcharSpousefullname"]."<br />";
echo $row["varcharButler"]."<br />";
echo $row["varcharGardener"]."<br />";
echo $row["varcharNanny"]."<br />";
echo $row["varcharGoverness"]."<br />";
echo $row["varcharCook"]."<br />";
echo $row["varcharHousemaid"]."<br />";
echo $row["varcharLogopedist"]."<br />";
echo $row["varcharTutor"]."<br />";
echo $row["varcharNurse"]."<br />";
echo $row["varcharDriver"]."<br />";
echo $row["varcharCouple"]."<br />";
echo $row["varcharOther "]."<br />";
echo $row["varcharPassportSeries"]."<br />";
echo $row["varcharPassportWhenWho"]."<br />";
echo $row["varcharNationality"]."<br />";
echo $row["varcharPassportExternal"]."<br />";
echo $row["varcharMarriage"]."<br />";
echo $row["intChildren"]."<br />";
echo $row["varcharEducationPedagogicalMiddle"]."<br />";
echo $row["varcharEducationPedagogicalHigherIncomplete"]."<br />";
echo $row["varcharEducationPedagogicalHigher"]."<br />";
echo $row["varcharEducationMedicalMiddle"]."<br />";
echo $row["varcharEducationMedicalHigherIncomplete"]."<br />";
echo $row["varcharEducationMedicalHigher"]."<br />";
echo $row["varcharEducationOther"]."<br />";
echo $row["varcharGraduatedWhatWhen"]."<br />";
echo $row["varcharMethods"]."<br />";
echo $row["varcharLanguageEnglish"]."<br />";
echo $row["varcharLanguageFrench"]."<br />";
echo $row["varcharLanguageGerman"]."<br />";
echo $row["varcharLanguageSpanish"]."<br />";
echo $row["varcharLanguageOther"]."<br />";
echo $row["varcharWorkExperience"]."<br />";
echo $row["varcharWorkTheLast"]."<br />";
echo $row["varcharWorkExperienceInFamily"]."<br />";
echo $row["varcharWorkReferences"]."<br />";
echo $row["intPreferenceMinAge"]."<br />";
echo $row["intPreferenceMaxAge"]."<br />";
echo $row["varcharDrivingExperience"]."<br />";
echo $row["varcharAllergy"]."<br />";
echo $row["varcharPets"]."<br />";
echo $row["varcharHobby"]."<br />";
echo $row["varcharResidence"]."<br />";
echo $row["varcharResidenceOfSpouse"]."<br />";
echo $row["varcharRegistration"]."<br />";
echo $row["varcharWorkType"]."<br />";
echo $row["dateWorkStart"]."<br />";
echo $row["intSalary"]."<br />";
echo $row["varcharSupplements"]."<br />";
echo $row["varcharPicture"]."<br />";
}
mysql_free_result($result);
?>