phpjoy Posted August 9, 2011 Share Posted August 9, 2011 Hi, I am trying to access the SQL Server 2005 with PHP. For that I have activated IIS 7 on the windows small business server, for PHP. Now I have the following code for local web hosting : ===================================== <head> <meta http-equiv="refresh" content="2";url="index.php";> <title>Trial 1</title> </head> <h1> :: B List :: </h1> <?php $now = time(); echo $now; $link = mssql_connect("SRVR name", "local host \ user name", "password"); if (!$link) { die('ERROR: Could not connect'); } mssql_select_db('database name', $link); $query = mssql_query('SELECT B_No, FROM dbo.B_LIST WHERE B_No = 000011', $link); if (!$query) { die('MSSQL error'); } $row = mssql_fetch_row ($query); echo $row; ?> <body> </body> </html> ========================================= In this I am just trying to print one row from the database on the webpage Correct me if I am wrong, as I am coding PHP for the first time with online help. When I try to access the webpage on the explorer I only get the title and the page if refreshed every 2 seconds , and the time is displayed. Nothing is available from database. Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/244310-accessing-mssql-with-php/ Share on other sites More sharing options...
Muddy_Funster Posted August 9, 2011 Share Posted August 9, 2011 echo $row; This won't work. $row is an array of values that represents the row of data retrieved from the database. You would need to address it as an array to echo the contents(echo $row['fieldNameFromDatabase'], or use print_r($row) to pull the raw contents of the array onto the screen. Quote Link to comment https://forums.phpfreaks.com/topic/244310-accessing-mssql-with-php/#findComment-1254864 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.