PHP wrong response with AJAX POST

Question

I have a problem with the response of PHP using AJAX POST.

My PHP code is this one:

$vadb_dsn = 'odbc:DSN=VerticaDSNunixodbc;Database=DB';
$vadb_options = array(PDO::ATTR_AUTOCOMMIT=>FALSE, PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION);
$vadb_user = 'dbadmin';
$vadb_pass = 'dbpwd';

$user=$_POST['user'];
$pwd=$_POST['pwd'];


# Connect to Database
try {
    $vadb = new PDO( $vadb_dsn, $vadb_user, $vadb_pass, $vadb_options );
}
catch ( PDOException $e ) {
    die( "Couldn't connect to DB" );
}

# Query to Database
$vsql = "SELECT user_name as 'user_name', password as 'password' from schema.table where user_name='".$user."' and password='".$pwd."';";

# Prepare Statement and Execute
$stmt = $vadb->prepare( $vsql );
$stmt->execute();

# Fetch Results
while( $row = $stmt->fetch(PDO::FETCH_ASSOC) ) {
    $result = $row['user_name'].";".$row['password'];
}

# Close Connection
$vadb = null;

# Output the result
echo $result

when I execute the POST, in this way:

var url = "example.php"; 
var user= $('#user').val();
var pwd= $('#pwd').val();

$.ajax({
   type: "POST",
   url: url,
   data: $("#formpost").serialize(), // serializes the form's elements.
   success: function(data)
   {
       alert(data); // show response from the php script.
   }
});

I get, as response from PHP file, instead of the query result, the code of PHP file itstelf. In other words, my webpage prompts an alert in wich the content is the php file code... any ideas on how to solve this and get the proper response?

Does the PHP script (unto itself) run the query when called directly? — Adam T, May 10 '16 at 13:30
have you tried [this](http://stackoverflow.com/questions/14918462/get-response-from-php-file-using-ajax) option? — Jitendra Tiwari, May 10 '16 at 13:32
yes, when called by shell, the php file responses correctly. — user1903898, May 10 '16 at 13:34
Are you sure you have PHP installed? What happens if you create a file called `index.php` and put in `` inside of it, then load it in the browser? — Alexander Kleinhans, May 10 '16 at 13:55
yes, php is installed. I tested expample.php by command line with the command: php example.php — user1903898, May 10 '16 at 14:02
Just because you tested it on the command line does not mean it's the same PHP instance that apache is using, FYI. Make sure it's working by loading an index.php file in your root directory. — Alexander Kleinhans, May 10 '16 at 16:29

Alexander Kleinhans · Answer 1 · 2016-05-10T13:40:01.973

0

Try adding <?php at the top of the PHP file. It looks like you're missing this in the PHP you pasted.

If you're getting php code itself, you're just getting the contents of the file. It looks like you're missing the pre-processor tag.

If that doesn't work, try changing the URL to '/example.php' instead of 'example.php'

edited May 10 '16 at 13:40

answered May 10 '16 at 13:29

Alexander Kleinhans

5,950
10
55
111

the – user1903898 May 10 '16 at 13:35
try adding a / before example.php to make it `/example.php` – Alexander Kleinhans May 10 '16 at 13:40
nope, same result... – user1903898 May 10 '16 at 13:51
Try doing `print_r` on the array called $result to ensure you are actually getting output you expected. – Adam T May 10 '16 at 16:27

score -1 · Accepted Answer · answered May 10 '16 at 15:10

-1

I solved reinstalling php on the server (Centos), so in this case, from shell:

yum install php

and that's all.

answered May 10 '16 at 15:10

user1903898

75
1
2
8

PHP wrong response with AJAX POST

2 Answers2