Problems writing my first POST request

var jsonObject = JSON.stringify({
		 'renderedStaticPage': renderedStaticPage,
		 'newsTickerEnabled': (newsTickerEnabled ? 1 : 0)
	});  /* Here you was using json.stringify() it sould be JSON.stringify() */
	var messageText = 'ipAddress = ' + Apostrophe
		+ strings.excerpt(ipAddress) + Apostrophe
		+ CommaSpace + Apostrophe + 'jsonObject = '
		+ Apostrophe + jsonObject + Apostrophe;

	messages.print(functionName, messageText);

	$http({
		method: 'POST',
		url: ipAddress,

		headers : {
			'Content-Type': 'application/json; charset=UTF-8'
			//'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8'
		},
		data: jsonObject, /* removed JSON.stringify from because jsonObject is already in json format */
	}).success(function(data, status, headers, config) {
		swal('Data sent successfully.', '', 'info');
	}).error(function(data, status, headers, config) {
		swal('No connection possible!', 'URL: '
			+ messageText, 'error');
	});
};

Select allOpen in new window

SyntaxError: Unexpected token r in JSON at position 0
    at JSON.parse (<anonymous>)
    at fromJson (ionic.bundle.js:10063)
    at defaultHttpResponseTransform (ionic.bundle.js:18080)
    at ionic.bundle.js:18171
    at forEach (ionic.bundle.js:9168)
    at transformData (ionic.bundle.js:18170)
    at transformResponse (ionic.bundle.js:18926)
    at processQueue (ionic.bundle.js:23399)
    at ionic.bundle.js:23415
    at Scope.$eval (ionic.bundle.js:24678)

Select allOpen in new window

print_($POST); 

Select allOpen in new window

echo $query 

Select allOpen in new window

$json = file_get_contents("php://input");
$json = json_decode($json);

Select allOpen in new window

$http({
	url: ipAddress,
	data: {
          'renderedStaticPage': renderedStaticPage,
          'newsTickerEnabled': (newsTickerEnabled ? 1 : 0)
        },
	method: 'POST',
}).then(function(resp) {
	console.log(resp);
});

Select allOpen in new window

var data = {
  'renderedStaticPage': renderedStaticPage,
  'newsTickerEnabled': (newsTickerEnabled ? 1 : 0)
};
$http.post(ipAddress, data).then(function(resp) {
   console.log(resp);
});

Select allOpen in new window

<?php
ob_start();
var_dump($_POST);
error_log( ob_get_clean() );

Select allOpen in new window

$username = "<username>";
$password = "<password>";
$hostname = "localhost"; 

//$echo 'Current PHP version is ' . phpversion();
//header("Content-Type: application/json");
header("Access-Control-Allow-Origin: *");

// Create connection to the database
$dbhandle = MYSQLI_CONNECT($hostname, $username, $password)
	or die("Unable to connect to MySQL");

$selected = MYSQLI_SELECT_DB("test_apptest", $dbhandle)
	or die("Could not select examples");

MYSQLI_QUERY("SET NAMES 'utf8'");

Select allOpen in new window

XMLHttpRequest cannot load http://app.ivm.at/ServiceTest/addStartSite.php. Request header field Content-Type is not allowed by Access-Control-Allow-Headers in preflight response.

Select allOpen in new window

header("Access-Control-Allow-Headers: Content-Type");
//header("Access-Control-Allow-Origin: *");

Select allOpen in new window

XMLHttpRequest cannot load http://app.ivm.at/ServiceTest/addStartSite.php. Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'null' is therefore not allowed access.

Select allOpen in new window

	var ipAddress = database.createPostIPAddress(calls.START_SIDE)
		+ QuestionMark + 'username="ivmtest"&password="tegucigalpa33"';

	var renderedStaticPage = database.encode('<div name="test22"></div>');

	var messageText = 'ipAddress = ' + Apostrophe
		+ strings.excerpt(ipAddress) + Apostrophe + CommaSpace
		+ Apostrophe + 'renderedStaticPage = ' + Apostrophe
		+ strings.excerpt(renderedStaticPage) + Apostrophe + CommaSpace
		+ 'newsTickerEnabled = ' + strings.excerpt(newsTickerEnabled);

	messages.print(functionName, messageText);

	var data = {
		'renderedStaticPage': renderedStaticPage,
		'newsTickerEnabled': (newsTickerEnabled ? 1 : 0)
	};

	$http.post(ipAddress, data).then(swal('Daten wurden erfolgreich übermittelt.', '', 'info'),
		swal('Keine Verbindung möglich!', 'URL: ' + messageText, 'error'));

Select allOpen in new window

include('./general/connectDB.php');
include('./general/constants.php');

// OPEN A CONNECTION TO THE DATA BASE SERVER AND SELECT THE DB
$mysqli = new mysqli($hostname, $username, $password/*, $db_name*/);

[…]

$db_user = $_GET['username'];
$db_password = $_GET['password'];

Select allOpen in new window

MainDB.createPostIPAddress(eCall.START_SITE) returns with "http://app.ivm.at/ServiceTest/addStartSite.php"
messages.js:152 ivmDatabase.controller(DatabaseController.startSite2DB) ipAddress = 'http://app.ivm.at/Se … username="ivmtest"&password="tegucigalpa33"', 'renderedStaticPage = '%3Cdiv%20name%3D%22test22%22%3E%3C%2Fdiv%3E', newsTickerEnabled = 0

Select allOpen in new window

As we do not use AJAX at all, there are no issues with that.

$http.post(ipAddress, data).then(swal('Daten wurden erfolgreich übermittelt.', '', 'info'),
		swal('Keine Verbindung möglich!', 'URL: ' + messageText, 'error'));

Select allOpen in new window

although the POST part still fails to do so.

http://yourserver/service.php?username=Fred&password=Secret

Select allOpen in new window

<html>
    <head>
        <title>Backend POST test</title>

        <script src="./js/startSite2DB.js"></script>
    </head>

    <body>
        <div>
            <button type="button" onclick="startSite2DB();">Click Me!</button>
        </div>
    </body>
</html>

Select allOpen in new window

"use strict;"

var Apostrophe = "'";

function startSite2DB ($http) {
	var ipAddress = 'http://app.ivm.at/ServiceTest/addStartSite.php?'
		+ 'username=\'ivmtest\'&password=\'tegucigalpa33\'';

	var renderedStaticPage = '<div name="test22"></div>';

	var messageText = 'ipAddress = ' + Apostrophe
		+ ipAddress + Apostrophe + ', '
		+ 'renderedStaticPage = ' + Apostrophe
		+ renderedStaticPage + Apostrophe;

	console.log(messageText);

	/* var data = {
		'renderedStaticPage': renderedStaticPage,
	};

	var headers = {
		'Content-Type': 'application/x-www-form-urlencode'
	}; */

	window.open(ipAddress);
};

Select allOpen in new window

<?php
<?php

// ======================================================================
// File name	: addStartSite
// Author		: Juri Schreib
// Co-author	: Ahmet Ekrem Saban
// Date			: 2016-08-31
// Last revision: 2017-03-07
// ======================================================================
//include('./general/connectDB.php');
//include('./general/constants.php');

$username = "<username>";
$password = "<password>";
$hostname = "localhost"; 

// OPEN A CONNECTION TO THE DATA BASE SERVER AND SELECT THE DB
$mysqli = new mysqli($hostname, $username, $password);

//header('Access-Control-Allow-Origin: *');

// DID THE CONNECT/SELECT WORK OR FAIL?
if ($mysqli->connect_errno)
{
    $err
    = "CONNECT FAIL: "
    . $mysqli->connect_errno
    . ' '
    . $mysqli->connect_error
    ;
    trigger_error($err, E_USER_ERROR);
}
// SHOW WHAT THE DB CONNECTION OBJECT LOOKS LIKE
//var_dump($mysqli);

$got_username = $_GET['username'];
$got_password = $_GET['password'];

print "got_username = $got_username\n";	# Test line
print "got_password = $got_password\n";	# Test line
/* 
$renderedStaticPage = $_GET['renderedStaticPage'];
$newsTickerEnabled = $_GET['newsTickerEnabled'];

print "renderedStaticPage = $renderedStaticPage\n";	# Test line
print "newsTickerEnabled = $newsTickerEnabled\n";	# Test line

$query = "INSERT INTO StartSite (renderedStaticPage, newsTicker_enabled) VALUES ('"
		. $renderedStaticPage . "', " . $newsTickerEnabled . ")";

// Start query
$result = MYSQLI_QUERY($dbhandle, $query); */

?>

Select allOpen in new window

renderedStaticPage = '
'

Select allOpen in new window

if ($renderedStaticPage !== false && $newsTickerEnabled !== false) {

Select allOpen in new window

$result->message = $result->status ? 'success' : $mysqli->error ;

Select allOpen in new window

<?php

// SO THIS CAN BE CALLED FROM A DIFFERENT DOMAIN / PORT / PROTOCOL
header("Access-Control-Allow-Origin: *");
require_once('../db.config.php');

// Our result return
$result = new stdClass;
$result->status = false;
$result->message = 'Fail';

$mysqli = new mysqli($hostname, $username, $password/* , $database */);

// Get the input data safely
$renderedStaticPage = isset($_POST['renderedStaticPage'])
	? $mysqli->real_escape_string($_POST['renderedStaticPage'])
	: false;
$newsTickerEnabled = isset($_POST['newsTickerEnabled'])
	? $mysqli->real_escape_string($_POST['newsTickerEnabled'])
	: false;

// Only proceed if we got valid input
if ($renderedStaticPage !== false && $newsTickerEnabled !== false) {

    $query = <<< QUERY
INSERT INTO 
	StartSite (
		renderedStaticPage, 
		newsTicker_enabled
	 ) 
VALUES (
	'{$renderedStaticPage}',
	'{$newsTickerEnabled}'
)
QUERY;

    $result->status = $mysqli->query($query);
    $result->message = $result->status ? 'success' : $mysqli->error ;
}else {
    $result->message = 'Invalid parameters';
}

die(json_encode($result));
	
?>

Select allOpen in new window

ipAddress = "http://app.ivm.at/ServiceTest/addStartSite.php?renderedStaticPage='<div name="test22"></div>'&newsTickerEnabled=1"

Select allOpen in new window

INSERT INTO StartSite (renderedStaticPage, newsTicker_enabled) VALUES ('<div name="test99"></div>', 1);

Select allOpen in new window

http://app.ivm.at/ServiceTest/addStartSiteTest.php?renderedStaticPage=%27%3Cdiv%20name=%22test22%22%3E%3C/div%3E%27&newsTickerEnabled=1

Select allOpen in new window

{"status":null,"message":null}

Select allOpen in new window

<?php

require_once('./general/connectDB.php');

// Get the input data safely
$renderedStaticPage = $_POST['renderedStaticPage'];
	
$newsTickerEnabled = $_POST['newsTickerEnabled'];

// Only proceed if we got valid input
if ($renderedStaticPage !== false && $newsTickerEnabled !== false) {
	$query = "INSERT INTO StartSite (renderedStaticPage, newsTicker_enabled) 
VALUES ('" . $renderedStaticPage . "', " . $newsTickerEnabled . ")";

	$result = MYSQL_QUERY($query);
} else {
	$result = 'Invalid parameters';
}

die(json_encode($result));
	
?>

Select allOpen in new window

<!DOCTYPE html>
<html>
	<head>
		<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js'></script>
		<script>
			$(document).ready(function () {
				$('button').click(function () {
					$.post('http://app.ivm.at/ServiceTest/addStartSiteChristian.php',
					{
						renderedStaticPage: '<div name="test99"></div>',
						newsTickerEnabled: 1
					}, function (data, status) {
						alert('Data: ' + data + ', status: ' + status);
					});
				});
			});
		</script>
	</head>
	<body>
		<button>Click me!</button>
	</body>
</html>

Select allOpen in new window

I feed the $database parameter from the ./general/dbconstant.php file.

$mysqli = new mysqli($hostname, $username, $password/* , $database */);

Select allOpen in new window