How do I intergrate a XML config into PHP

Question

0.00/5 (No votes)

See more:

Dear reader,

I am trying to read a XML file (made by an application via c#) into PHP.

Whatever I try it won't work

What I have tried:

This is the code;

PHP

<?php 

error_reporting(E_ALL);
ini_set('display_errors', 1);

$myXMLData = $_GET["C:\ProgramData\DS\Config.xml"];
$xml=simplexml_load_string($myXMLData);


$connectionInfo = array( "Database"=> $xml->DatabaseConnection[0]->InitialCatalog, "UID"=> $xml->DatabaseConnection[0]->UserID, "PWD"=>$$xml->DatabaseConnection[0]->Password);
$conn = sqlsrv_connect( $xml->DatabaseConnection[0]->DataSource, $connectionInfo);

if( $conn ) {
     echo "Connection established. <br/><br/>
	 
	
	 ";
}else{
     echo "Connection could not be established.<br /><br>";
     die( print_r( sqlsrv_errors(), true));
	 print_r(PDO::getAvailableDrivers());
} 

?>

This is the erorr code;

Notice: Undefined index: C:\ProgramData\DS\Config.xml in B:\_Websites\testpage.php on line 68

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 72

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 72

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 72

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 72

Notice: Undefined variable: in B:\_Websites\testpage.php on line 72

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 72

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 72

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 73

Notice: Trying to get property of non-object in B:\_Websites\testpage.php on line 73
Connection could not be established.

Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -1 [code] => -1 [2] => Invalid option was passed to sqlsrv_connect. [message] => Invalid option was passed to sqlsrv_connect. ) )

Posted 7-Jul-19 22:39pm

Robin Uters

Add a Solution

Comments

Anurag Gandhi 10-Jul-19 11:54am

What is the structure of your xml file. Please post your xml file.
It seems DatabaseConnection is not an array but you are trying to read it as array.

Robin Uters 19-Jul-19 2:43am

Hi Anurag,

Herewith the XML code

Config:

$xmldata = simplexml_load_file("C:\ProgramData\ARAS\EasyVisitor\Config\Config.xml") or die("Failed to load");
$XML_SQL_DataSource = $xmldata->DatabaseConnection[0]["DataSource"];
$XML_SQL_InitialCatalog = $xmldata->DatabaseConnection[0]["InitialCatalog"];
$XML_SQL_UserID = $xmldata->DatabaseConnection[0]["UserID"];
$XML_SQL_Password = $xmldata->DatabaseConnection[0]["Password"];

XML Code:
Hide Copy Code

<?xml version="1.0" encoding="utf-8"?><Config><DatabaseConnection DataSource="SQLSERVER" InitialCatalog="SQLDATABASE" UserID="SQLUSER" Password="SQLPASSWORD" /></Config>

PHP Code:
Hide Copy Code

<?php error_reporting(E_ALL);ini_set('display_errors', 1);$connectionInfo = array( "Database"=>$XML_SQL_InitialCatalog, "UID"=>$XML_SQL_UserID, "PWD"=>$XML_SQL_Password);$conn = sqlsrv_connect( $XML_SQL_DataSource, $connectionInfo);if( $conn ) {     echo "Connection established. <br/><br/>	 	 SQL Server: 	$XML_SQL_DataSource <br>	 SQL Database: 	$XML_SQL_InitialCatalog <br>	 SQL Username: 	$XML_SQL_UserID <br>	 SQL Password: 	".md5($XML_SQL_Password)." (For Secure password is encrypted.)<br> 	 ";}else{     echo "Connection could not be established.<br /><br>";     die( print_r( sqlsrv_errors(), true));	 print_r(PDO::getAvailableDrivers());}  ?>

Current Error code:
Connection could not be established.

Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -33 [code] => -33 [2] => Invalid value type for option Database was specified. String type was expected. [message] => Invalid value type for option Database was specified. String type was expected. ) )

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)