Need help on PHP coding to update the MySQL Workbench database…
Question Answered step-by-step Need help on PHP coding to update the MySQL Workbench database… Need help on PHP coding to update the MySQL Workbench database data. I got below error when submit html file:SQL Statement Error: CALL InsertNewArtist (‘Anderson’, ‘Guy’, ‘United States’, ‘1906’,’1998′)Then got error as blow after executing php file:SQL Statement Error: CALL InsertNewArtist (”, ”, ”, ”,”)What’s the issue here and how to fix it? Thank you for your explanation! The View Ridge Gallery ARTIST Table
“; echo “
New Artist Added:
| Last Name: | ” . $LastName . “ |
| First Name: | ” . $FirstName . “ |
| Artist Nationality: | ” . $Nationality . “ |
| DateOfBirth: | ” . $DateOfBirth . “ |
| DateDeceased: | ” . $DateDeceased . “ |
“; // Table headers echo “
| LastName | FirstName | Nationality | DateOfBirth | DateDeceased |
|---|---|---|---|---|
| ” . $RecordSetRow[‘ArtistLastName’] . “ | ” . $RecordSetRow[‘ArtistFirstName’] . “ | ” . $RecordSetRow[‘Nationality’] . “ | ” . $RecordSetRow[‘DateOfBirth’] . “ | ” . $RecordSetRow[‘DateDeceased’] . “ |
“; // Close connection odbc_close($Conn);?>