HTML form using POST to get PHP passing data to MS Access

Question

Hi I have two pieces of code set up

<form action="Index2.php" method="POST">
    <p>Name:</p>
    <input type="text" name="name">

    <p>Last Name:</p>
    <input type="text" name="lname">

    <input type="submit" value="Submit">
</form>

and this PHP file named Index2.php

<?php

$connection = odbc_connect("Dashboard","","") or die ("Unable to Connect to the DB");

$name=$_POST['name'];
$last_name=$_POST['lname'];

$sql = "
    INSERT INTO tableone (Name, Last_Name)
    VALUES ('$name', '$last_name')
";

odbc_exec($connection, $sql);
?>

That I have tried in a separate file to make sure connects and pass the info to the database but when I run the form it does not pass the data to MS Access and shows me the PHP code on a blank page, am I missing some sort of escaping from PHP?

can you try this instead: ` $sql = " INSERT INTO tableone (Name, Last_Name) VALUES ('" . $name . "', '" . $last_name . "') ";` — I am Cavic, Sep 20 '18 at 05:17
Does any Php code get interpreted in your server environment? Something like ` — Progrock, Sep 20 '18 at 05:22
Check out [this post](https://stackoverflow.com/questions/5121495/php-code-is-not-being-executed-instead-code-shows-on-the-page) which talks about configuration issues. Sounds like your php code is not being processed. — mseifert, Sep 20 '18 at 05:25
I thought this most likely will be the problem, I will check it and try to solve the excecution of the php code on my environment — Edward Gavilán, Sep 21 '18 at 19:04
@IamCavic, I tried this sentece, althought it does not give me any error it does not get written into the Access DB. They query is right, I tried alone, I think the problem is with php and html, something do not clicked right there — Edward Gavilán, Sep 21 '18 at 19:25

score 1 · Answer 1 · edited Sep 27 '18 at 06:50

1

I have tried this and its working.

<?php
if(isset($_POST['submit]))
{
$name=$_POST['name'];
$last_name=$_POST['lname'];
$con=odbc_connect("abc","","");
$sql="INSERT INTO tableone(name,lastname) VALUES('$name','$last_name')";
if(odbc_exe($con,$sql))
{
    echo "<br>Data Added<br>Please wait ,Page is redirecting";  
    header("refresh:1;url=index.php");
}
else
{
    echo "Error";
}
}   
?>

edited Sep 27 '18 at 06:50

piet.t

11,718
21
43
52

answered Sep 20 '18 at 06:18

Prathamesh Doke

797
2
16
38

besides a typo on the second line this is not solving OP question. The question is why his code is not parsed but the raw php appears – Lelio Faieta Sep 20 '18 at 07:31
I tried this without the typo on line 2 (that´s ok) and apparently the php code is excecuted but the odbc sentece to MS Access never pass thru as it did not placed the data there – Edward Gavilán Sep 21 '18 at 19:22
NOTE: No message was displayed at all, not even raw php code this time, just blank page. – Edward Gavilán Sep 21 '18 at 19:33
Finally worked like this: Thank you all for the help! – Edward Gavilán Sep 21 '18 at 22:31

HTML form using POST to get PHP passing data to MS Access

1 Answers1