{"id":1416,"date":"2018-01-19T19:22:49","date_gmt":"2018-01-19T19:22:49","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/interfacing-with-ms-access-page-5\/"},"modified":"2018-01-19T19:24:46","modified_gmt":"2018-01-19T19:24:46","slug":"interfacing-with-ms-access-page-5","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/interfacing-with-ms-access-page-5\/","title":{"rendered":"Interfacing with MS Access Page 5"},"content":{"rendered":"
\n
\n
By Siddharth Venkatesan<\/div>\n
on July 30, 2000<\/div>\n<\/p><\/div>\n
\n
\nThe code on the prior page is pretty common place. Now we actually interface with the database.
\nWe can do this using the inherent ODBC functions within PHP and SQL. As the above
\nform says, the action is going to be DataAccess.php3. So copy and paste the code
\nbelow into the file DataAccess.php3.<\/b><\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>function\u00a0<\/span>HTML_Head<\/span>()\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"
\n
\u00a0\u00a0\u00a0\u00a0<HTML><HEAD>
\n
\u00a0\u00a0\u00a0\u00a0<TITLE>Processing\u00a0Form<\/TITLE>
\n
\u00a0\u00a0\u00a0\u00a0<\/HEAD>
\n
\u00a0\u00a0\u00a0\u00a0<BODY\u00a0BGCOLOR=\"#D5D5AB\">\"<\/span>;
\n
}<\/p>\n

function\u00a0<\/span>HTML_Foot<\/span>()\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"<\/body><\/html>\"<\/span>;
\n
}<\/p>\n

function\u00a0<\/span>Database_Entries<\/span>(<\/span>$msg<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>$msg<\/span>;
\n
}<\/p>\n

function\u00a0<\/span>Output_Entries<\/span>()\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Make\u00a0the\u00a0connection\u00a0to\u00a0the\u00a0database.\u00a0The\u00a0syntax\u00a0is\u00a0
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0odbc_connect(\u00a0'SYSTEM_DSN'\u00a0,\u00a0'USER',\u00a0'PASSWORD'\u00a0);
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$cnx\u00a0will\u00a0hold\u00a0the
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0pconnect\u00a0is\u00a0used\u00a0to\u00a0establish\u00a0a\u00a0persistent\u00a0database\u00a0
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0connection\u00a0to\u00a0the\u00a0Database\u00a0until\u00a0the\u00a0procedure\u00a0is\u00a0completed.
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$cnx\u00a0<\/span>=\u00a0<\/span>odbc_connect<\/span>(\u00a0<\/span>'WebTute'\u00a0<\/span>,\u00a0<\/span>'root'<\/span>,\u00a0<\/span>''\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0if\u00a0(!<\/span>$cnx<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>Error_handler<\/span>(\u00a0<\/span>\"Error\u00a0in\u00a0odbc_connect\"\u00a0<\/span>,\u00a0<\/span>$cnx\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0send\u00a0a\u00a0simple\u00a0odbc\u00a0query\u00a0.\u00a0returns\u00a0an\u00a0odbc\u00a0cursor
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$cur<\/span>=\u00a0<\/span>odbc_exec<\/span>(\u00a0<\/span>$cnx<\/span>,\u00a0<\/span>\"select\u00a0Index,FirstName,LastName,PhoneNumber\u00a0from\u00a0People\"\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0if\u00a0(!<\/span>$cur<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>Error_handler<\/span>(\u00a0<\/span>\"Error\u00a0in\u00a0odbc_exec(\u00a0no\u00a0cursor\u00a0returned\u00a0)\u00a0\"\u00a0<\/span>,\u00a0<\/span>$cnx\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"<table\u00a0border=1><tr><th>Index<\/th><th>First\u00a0Name<\/th>\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"<th>Last\u00a0Name<\/th><th>Phone\u00a0Number<\/th><\/tr>n\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$nbrow<\/span>=<\/span>0<\/span>;\u00a0\u00a0\u00a0<\/span>\/\/Local\u00a0variable\u00a0to\u00a0count\u00a0number\u00a0of\u00a0rows<\/p>\n

\u00a0\u00a0\u00a0\u00a0\/\/\u00a0fetch\u00a0the\u00a0succesive\u00a0result\u00a0rows
\n
\u00a0\u00a0\u00a0\u00a0<\/span>while(\u00a0<\/span>odbc_fetch_row<\/span>(\u00a0<\/span>$cur\u00a0<\/span>)\u00a0)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$nbrow<\/span>++;
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$Index<\/span>=\u00a0<\/span>odbc_result<\/span>(\u00a0<\/span>$cur<\/span>,\u00a0<\/span>1\u00a0<\/span>);\u00a0<\/span>\/\/\u00a0get\u00a0the\u00a0field\u00a0\"Index\"
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$FirstName<\/span>=\u00a0<\/span>odbc_result<\/span>(\u00a0<\/span>$cur<\/span>,\u00a0<\/span>2\u00a0<\/span>);\u00a0<\/span>\/\/\u00a0get\u00a0the\u00a0field\u00a0\"FirstName\"
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$LastName<\/span>=\u00a0<\/span>odbc_result<\/span>(\u00a0<\/span>$cur<\/span>,\u00a0<\/span>3\u00a0<\/span>);\u00a0<\/span>\/\/\u00a0get\u00a0the\u00a0field\u00a0\"LastName\"
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$PhoneNumber<\/span>=\u00a0<\/span>odbc_result<\/span>(\u00a0<\/span>$cur<\/span>,\u00a0<\/span>4\u00a0<\/span>);\u00a0<\/span>\/\/\u00a0get\u00a0the\u00a0field\u00a0\"PhoneNumber\"<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>echo\u00a0<\/span>\"<tr><td>$Index<\/td><td>$FirstName<\/td>\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"<td>$LastName<\/td><td>$PhoneNumber<\/td><\/tr>n\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"<tr><td\u00a0colspan=2>$nbrow\u00a0entries\u00a0<\/td><\/tr><\/table>\"<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/\/\u00a0close\u00a0the\u00a0connection.\u00a0important\u00a0if\u00a0persistent\u00a0connection\u00a0are\u00a0\"On\"
\n
\u00a0\u00a0\u00a0\u00a0<\/span>odbc_close<\/span>(\u00a0<\/span>$cnx<\/span>);
\n
}<\/p>\n

function\u00a0<\/span>Error_Handler<\/span>(\u00a0<\/span>$msg<\/span>,\u00a0<\/span>$cnx\u00a0<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"$msg\u00a0n\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>odbc_close<\/span>(\u00a0<\/span>$cnx<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0exit();
\n
}<\/p>\n

function\u00a0<\/span>Enter_New_Entry<\/span>(<\/span>$FirstName<\/span>,<\/span>$LastName<\/span>,<\/span>$PhoneNumber<\/span>)\u00a0{<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0First,\u00a0we\u00a0create\u00a0a\u00a0connection\u00a0to\u00a0our\u00a0ODBC\u00a0source.\u00a0This\u00a0is\u00a0done\u00a0by\u00a0creating
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0a\u00a0connection.\u00a0Once\u00a0this\u00a0is\u00a0done,\u00a0we\u00a0are\u00a0returned\u00a0an\u00a0ODBC\u00a0connection\u00a0number.
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0We\u00a0use\u00a0this\u00a0number\u00a0to\u00a0use\u00a0the\u00a0ODBC\u00a0functions\u00a0within\u00a0PHP.
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$cnx\u00a0<\/span>=\u00a0<\/span>odbc_connect<\/span>(\u00a0<\/span>'WebTute'\u00a0<\/span>,\u00a0<\/span>'root'<\/span>,\u00a0<\/span>''\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0if\u00a0(!<\/span>$cnx<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>Error_handler<\/span>(\u00a0<\/span>\"Error\u00a0in\u00a0odbc_connect\"\u00a0<\/span>,\u00a0<\/span>$cnx\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$SQL_Exec_String\u00a0<\/span>=\u00a0<\/span>\"Insert\u00a0Into\u00a0People\u00a0(FirstName,\u00a0LastName,\u00a0PhoneNumber)
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Values\u00a0('$FirstName',\u00a0'$LastName',\u00a0'$PhoneNumber')\"<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$cur<\/span>=\u00a0<\/span>odbc_exec<\/span>(\u00a0<\/span>$cnx<\/span>,\u00a0<\/span>$SQL_Exec_String\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0if\u00a0(!<\/span>$cur<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>Error_handler<\/span>(\u00a0<\/span>\"Error\u00a0in\u00a0odbc_exec(\u00a0no\u00a0cursor\u00a0returned\u00a0)\u00a0\"\u00a0<\/span>,\u00a0<\/span>$cnx\u00a0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>odbc_close<\/span>(\u00a0<\/span>$cnx<\/span>);
\n
}<\/p>\n

<\/span>$strOldEntries\u00a0<\/span>=\u00a0<\/span>\"Previous\u00a0Entries\u00a0in\u00a0database\"<\/span>;
\n
<\/span>$strNewEntries\u00a0<\/span>=\u00a0<\/span>\"Updated\u00a0version\u00a0of\u00a0databse\u00a0(after\u00a0entries)\"<\/span>;<\/p>\n

<\/span>HTML_Head<\/span>();
\n
<\/span>Database_Entries<\/span>(<\/span>$strOldEntries<\/span>);
\n
<\/span>Output_Entries<\/span>();
\n
<\/span>Enter_New_Entry<\/span>(<\/span>$FirstName<\/span>,<\/span>$LastName<\/span>,<\/span>$PhoneNumber<\/span>);
\n
<\/span>Database_Entries<\/span>(<\/span>$strNewEntries<\/span>);
\n
<\/span>Output_Entries<\/span>();
\n
<\/span>HTML_Foot<\/span>();<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nNow you should be ready to go! In this example, i havent done any deletion of records.
\nHowever, as you can see, if you modify the variable SQL_Exec_String,<\/b> you can delete
\nspecific records as well.<\/div>\n
\nI hope this has been of use to you.<\/div>\n
\n–Sid\n<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
| <\/div>\n
5<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Siddharth Venkatesan on July 30, 2000 The code on the prior page is pretty common place. Now we actually interface with the database. We can do this using the inherent ODBC functions within PHP and SQL. As the above form says, the action is going to be DataAccess.php3. So… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1416","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1416"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1416\/revisions"}],"predecessor-version":[{"id":3279,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1416\/revisions\/3279"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}