I’m confused and obviously missing something really fundamental here…

 

I would appreciate it if you could glance at my code for the above. Basically I’m trying to write information to the database now I have managed to resolve the connection issue.

 

It’s the “Data Capture section that’s causing issues. I keep getting an error telling me there’s an “Unexpected $” on a line that’s actually outside even the HTML tag.

 

 

 

 

Michael Mason

Business Support Services

Arras® People

 

Tel: 01706 342310

Mobile: 07793 782287

Fax: 01706 642754

The Project Management Recruitment Specialists

Member of the Recruitment Employment Confederation (00052055)

The views expressed in this mail are entirely those of the sender, and do not necessarily represent the views or position of Arras Services Ltd. The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in relation to the contents of this information is strictly prohibited and may be unlawful. Neither the sender nor the represented institution is liable for the correct and complete transmission of the contents of this e-mail, or for its timely receipt.

 

<<image001.jpg>>

<<image002.gif>>

<?php

/* MySQL Connection Variables */
        $host="localhost";
        $user="arras_WebMaster";
        $password="qwerty";
        $dbase="arras_Members";

/* MySQL Connection String */
        $Connection=mysql_connect ("$host", "$user", "$password")
        or die ('I cannot connect to the database because: ' . mysql_error());
        mysql_select_db ("$dbase");

        echo "database status: alive";
        
/* User Registration Form */
        echo "<form action = '??????????.php' method='POST'>";
        echo "<pre>UserID: \t\t<input type = 'text' name = 'TXT_UserID'></pre>";
        echo "<br>";
        echo "<pre>Password: \t \t<input type = 'text' name = 
'TXT_UserPassword'></pre>";
        echo "<br>";
        echo "<pre>a little about me: \t<input type = 'text' name = 
'TXT_Comments'></pre>";
        echo "<br>";
        echo "<pre>more about me: \t<input type = 'text' name = 
'TXT_FurtherComments'></pre>";
        echo "<br>";
        echo "<pre>\t\t\t<input type='submit' value='Submit Details'<pre>";
        echo "</form>";

/* Data Capture */
        $NewUserID=$_POST['TXT_UserID'];
        $NewUserPassword=$_POST['TXT_UserPassword'];
        $NewUserComments=$_POST['TXT_Comments'];
        $NewUserFurtherComments=$_POST['TXT_FurtherComments'];
        $sql = "INSERT INTO RegisteredMembers 
(TXT_UserID,TXT_UserPassword,TXT_Comments,TXT_FurtherComments)
        
VALUES('$NewUserID','$NewUserPassword','$NewUserComments','$NewUserFurtherComments');

?>
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to