Data can't be inserted into Access database - Writing PHP

Training, Open Source
computer languages

Perl • PHP • Python • MySQL • Apache / Tomcat • Tcl • Ruby • Java • C and C++ • Linux • CSS

Data can't be inserted into Access database

Posted by Jo (Jo), 8 July 2008

Hi everyone, I'm currently doing a online personal information registration form and currently in need of some help. My form has the form and a confirmation page. After the user clicks submit on both pages, it would store the data into the database. However I'm not able to store it in the database. After clicking submit, it would insert blank data and in the browser, it would say all the variables are undefined. The connection to the database is ok as I'm able to read data from it.
This is the code I use to submit data into the database.

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
$_POST['username'] = $username;
$_POST['admin'] = $admin;
$_POST['gender'] = $gender;
$_POST['address'] = $address;
$_POST['hometel'] = $hometel;
$_POST['hp'] = $hp;
$_POST['email'] = $email;
$_POST['course'] = $course;
$_POST['year'] = $year;
$_POST['path'] = $path;
$_POST['title'] = $title;
$_POST['supervisor'] = $supervisor;

echo "Data has been submitted";

function Enter_New_Entry($username,$admin,$gender,$address,$phone,$hp,$email,$course,$year,$path,$title,$supervisor) {

if(!$cnx = odbc_connect( 'FYP' , 'root', '' ))die("error with connection");
$SQL_Exec_String = "Insert Into rank (username,admin,gender,address,hometel,hp,email,course,year,path,title,supervisor)
Values ('$username','$admin','$gender','$address','$phone','$hp','$email','$course','$year','$path','$title','$supervisor')";

$cur= odbc_exec( $cnx, $SQL_Exec_String );
if (!$cur) {
Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
}

odbc_close( $cnx);
}
Enter_New_Entry($username,$admin);
?>

</body>
</html>

Any advice would be helpful. Thank you.

Posted by admin (Graham Ellis), 9 July 2008

At a first glance, it looks as if your assignments are the wrong way round ...

$_POST[xxx] = $xxx;

should read

$xxx = $_POST[xxx];

i.e. copy the incoming form variables into local variables of the same name.

This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

Course Booking

Other Forum Posts

Data can't be inserted into Access database

Defensive OO Programing in PHP

ob_start() is inactive !!

Creatin fields in a table from an array

WHY CANT I PASS THE SIZE VARIABLE FROM Gorder.html

Array Push to skip first line

Retain the data on "Back Button " click of Browser

Saving image as base64

Using a redirect in a PHP mail form

reading image from mysql

PHP and Google Maps API

PHP - processing images as mySQL Blobs

How to grab the databse of other sites databse

Images from a database, Multiple images per page

Uploading images/other binaries to MySQL via PHP

php passing and assigning variables

php ignore html

I need to block users from creating an account...

date of the last added Link

xml and php problem

Security and safemode

Session question

Manipulation of pdf files thr php

PHP, Basic flat file shout box HELP

function to add HTML tags to text

preg_match to validate form

resize image before saving to mysql as blob

Sending mail with a order from a customer

any one help me to convert this code to php

Image and form upload

Inserting an image as a blob in PHP

Trouble with a Calendar Script

PHP and Regular Expressions

Regarding "last updated"

Uploading images to a website using PHP

Count links under a category

Simple Integration Method PHP trouble

Blob Images with Functions

Benchmarking code

Cusor postion in textcontrol with java script

Invalid argument supplied for foreach()

Seeking Freelance PHP/MySQL Coder

Character Encoding in PHP

URL variable passing proble:

Top ten downloads

premature end of script headers

String searching

HTTP_REFERER nothing there?

MySQL Upload Script

Writing RE in PHP 5

Extracting html form input elements

serve files from PHP

addslashes() & stripslashes() question

removing carriage returns/line feeds/line breaks

Looking for a freelance PHP/MySQL programmer

Quotes in Variable escaping Form Value

Notice: Undefined index: error in script

looking for ImageGif

Inserting data into a database

Telnet from PHP

how to make cursor work twice

Querying multiple table

using the correct tools?

PHP Website Hosting

Digging out embedded tags with preg_match_all()

Validate HTML offline on LAMP Dev Server

Splitting Strings

Assigning variables by value and reference

Concat and Declare variable in Oracleusing OCI

executing package not working

How to avoid Resource_ID Error ?

Oracle Package Bind Error

Resource Id Error

// indicating 'currentpage' state with PHP/CSS

Passing a URL variable

Warning: Cannot modify header information

open file, change content, save file

Does a particular URL exist?

outputing images from a php script,help.

Clearing history, cookies and cache files from PHP

Email Addresses for a particular company

Sendmail goes to-BUlk-folder

Wanted - include relative to include

Email Notification

Reading file contents

Looking 4 PHP function to load + display page.

Moved: Looking for a php professional

Using the header function

Help please! User Password  

ociplogon problem

Problem on user varification?

To Retrive clob datatype using oci funtions in php

How to Travese a xml string

regular expression help

PHP / MYSQL SEARCH ENGINE RANKINGS

Grab information from another Website

Regular Expression Problem

Trouble with MySQL command in script

Deleting a cookie

Objects, multithreaded web servers and persistance

summing a row in mysql

Random image in a web page via PHP?

Data truncation copying from file to mySQL table

My PHP tags aren't being interpretted

9 ways of sorting plus 2

TripleDES encryption

pack and unpack

PHP/SMTP Mail Problem

Webserver permissions and PHP

Help - input used to go to sendmail now to file

retrieving blobs with names

decoding entities in PHP

Which books to choose ?

public beta testing of PHP Editor

email with required fields

Arrays (?) and URLs

Using convert_uuencode to store images in MySQL DB

Help passing variables

php.ini under Mac OS X

hivalidation on submit

Valdiating Forms Using preg_match

Portability - questions for new programmers

PHP - GD - ImageMAP - Problems

Passing PHP Variables in a URL

is XSLT available in PHP?

Warning: Unknown():

Sending info to a new page

shopping list in PHP

math equation in php

php sql problem

History and background

Looking for a script in PHP

Html / PHP form into MySQL DB

Writing form field names to text file

Using a Form to write variables to a php page

Refreshing a page with PHP

Cloaked redirection

Redirect to another page

Script works online, but not locally??

Multi-dimensional arrays

Count query in MySQL

Resource id #3 - no data from simple queries

To use .gif, .png or .jpg?

Objects in PHP5

Spot the mistake??

create html table WITHOUT pear

create php table to input a  string Can you hel ?

Jazzing up PHP Emails!

addition of time

login script - tips/security

Moved: My root account is messed up - what can I do?

Cookies 101 with a twist

Adding spaces to a string

Uploading an image

Trying to refresh page

PHP & sendmail frustration

getdate () problem

program file extension .php4

Pulling data from a mySql table

Clearing/resetting a page

Code misses out when data has spaces

Quickie on preg_match

Link to site not working ??

php counter for web pages

really stupid question

select-option list

counting the number if params passed to function

Where is php.ini under Mac OSX

Deleting duplicates from an array

strip_tags stripping hyphen

Trouble pulling data using reg exp.

iffy if statement ?

math in php / mysql

Failing to write all data to file

deleting a file from within a php script

Sending PDF File to Browser via PHP

How long can a string be?

Warning stat failed for...

I need some input

DIRNAME (php 4.3.0)

User input and other checking

New PHP release

Which browser is being used?

Regular exressions in PHP

Searching a string for HTML tags

Using the back button in Netscape

Passing many SQL queries to one mysql_query

Removing last character of a string

Counting character groups in a string?

keyword searches

Retreiving a web page in PHP

PHP Form Processing Template

What is '&new'  ?

Making every page on a site into PHP

Session demo in a nutshell

Handling Comman Separated Variables in PHP

Incompatability in 4.1.2 over 4.0.x

Passing variables from page to page

Using booleans in PHP

Sending form variables to a text file

I cannot access MySQL from PHP

Passwords for MySQL; a conundrum??

PHP Independent of database - How?

Writing form variables to a file

WELL HOUSE CONSULTANTS LTD.: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho