{"id":1417,"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-4\/"},"modified":"2018-01-19T19:24:46","modified_gmt":"2018-01-19T19:24:46","slug":"interfacing-with-ms-access-page-4","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/interfacing-with-ms-access-page-4\/","title":{"rendered":"Interfacing with MS Access Page 4"},"content":{"rendered":"
\n
\n
By Siddharth Venkatesan<\/div>\n
on July 30, 2000<\/div>\n<\/p><\/div>\n
\n

Interfacing With Database<\/h2>\n
\nOk, now we can get down to the fun part, interfacing with a database!<\/div>\n
\nWe first create 2 php files. One to act as a form to get data from the user and
\nanother to actually process the command. I know there are more elegant ways of
\ndoing this. However, I was after a way which would be the easiest to understand.<\/div>\n
\nThe first PHP file is as follows. It is the form into which the user enters information.
\nYou should be able to copy and paste the code into you favourite editor. You can
\ncall this file whatever you want. I have called it FormInput.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_Form<\/span>()\u00a0{<\/p>\n

\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"
\n
\u00a0\u00a0\u00a0\u00a0<FORM\u00a0NAME\u00a0=\u00a0\"AccessInterface\"\u00a0METHOD=post\u00a0ACTION=\"DataAccess.php3\">
\n
\u00a0\u00a0\u00a0\u00a0Please\u00a0enter\u00a0the\u00a0details\u00a0you\u00a0wish\u00a0to\u00a0be\u00a0inserted\u00a0into\u00a0the\u00a0Access\u00a0Database.<br>
\n
\u00a0\u00a0\u00a0\u00a0First\u00a0Name:<input\u00a0name=\"FirstName\"\u00a0TYPE=\"text\"\u00a0SIZE=\"25\"><br>
\n
\u00a0\u00a0\u00a0\u00a0Last\u00a0Name:<input\u00a0name=\"LastName\"\u00a0TYPE=\"text\"\u00a0SIZE=\"25\"><br>
\n
\u00a0\u00a0\u00a0\u00a0Phone\u00a0Number:\u00a0<input\u00a0name=\"PhoneNumber\"\u00a0TYPE=\"text\"\u00a0SIZE=\"25\"><br>
\n
\u00a0\u00a0\u00a0\u00a0<INPUT\u00a0type=\"Submit\">
\n
\u00a0\u00a0\u00a0\u00a0<\/form>
\n
\u00a0\u00a0\u00a0\u00a0\"<\/span>;
\n
}<\/p>\n

function\u00a0<\/span>HTML_Existing<\/span>()\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"Existing\u00a0database\u00a0entries\"<\/span>;
\n
}<\/p>\n

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

<\/span>HTML_Head<\/span>();
\n
<\/span>HTML_Form<\/span>();
\n
<\/span>HTML_Existing<\/span>();
\n
<\/span>HTML_Foot<\/span>();<\/p>\n

<\/span>?><\/span>
\n<\/span>
\n<\/code><\/font><\/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<\/div>\n
| <\/div>\n
5<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Siddharth Venkatesan on July 30, 2000 Interfacing With Database Ok, now we can get down to the fun part, interfacing with a database! We first create 2 php files. One to act as a form to get data from the user and another to actually process the command. I… <\/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-1417","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1417","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=1417"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1417\/revisions"}],"predecessor-version":[{"id":3280,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1417\/revisions\/3280"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}