PHP - What Is Needed For Php 5.3.3 On Linux To Connect To Mssql Microsoft Sql Server?

I have a stored procedure on MSSQL that returns a list of results.  This works fine.  The results that are returned may or may not be allowed to be seen by the end user.  So, if 10 results are returned, maybe 7 of them are allowed to be viewed by the end user.  There is a PHP SESSION variable that contains a bunch of codes that is compared to a variable returned from the search result. When these match, the result can be seen by the user.

So, I am using a php if statement that echos the result based on the result of the if statement.  That works fine.  What does not work  is the found count for the array.  For example, if 10 are found, it returns 10, but the if statement removes 3 making 7 of the results viewable. 

So, is there a way to iterate through an array result set in PHP and remove results based on an if statement creating a new array?

Hope this is not too confusing! 

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=352526.0

Hi,

Happy Christmas

I got a error in my php file only when am running in linux server

$handle = fopen("bak\\".'db-backup-'."$date_time".'.sql','w+');
fwrite($handle,$return);


I am trying to write the content in the bak folder, but it fails, its showing the following error.

Warning:  fopen(bak\db-backup-25-12-2010-06-53.sql) [function.fopen]: failed to open stream: Permission denied in /home/cmstouch/public_html/cmstouch_demo/touchPanel/global.php on line 404

Warning:  fwrite(): supplied argument is not a valid stream resource in /home/cmstouch/public_html/cmstouch_demo/touchPanel/global.php on line 405


Thanks

Hello,

I'm trying to have my index.php to open/run another test.php file.
I'm having my own server that I play with, that I run Ubuntu on.

So the index.php are located at /var/www/ directory, but I want to run a file that are located at /testing/test.php

The final test.php is file for showing pictures, and I don't want to out all the pictures under the /var/www/ location.  It's alot  of photos.
I don't know much about php but I have been trying this:

<?php
header("Location: /var/www/testing/test.php");
    //These below are desperat old tries.
//header("Location: ./testing/test.php");
//header("Location: ../testing/test.php");
//$handle = fopen("/privat/Web_pictures/test.php", "r");
//"/testing/test.php"
// header("Location: ./test.php");   //This one actually works, but I'm still in the wrong folder (/var/www/)
echo "test "; // NN4 requires that we output something...
exit();
?>

Thankful for help!   

Hi,

Well I have been working on Php for quite sometime but creating Word Docs is something I am totally new to. I googled about this and found different methods of creating word documents via php. The most promising one that I found involves writing HTML code and inside header, save it as a *.doc file (I know thats not exactly a Word File but what else can be done). Like this,

Code: [Select]
header("Content-type: application/vnd.ms-word");
header("Content-Disposition: attachment; Filename=Report.doc");

The whole word document came out perfectly fine, but there was one little problem (later on turned out to be the BIGGEST one) was placing images in the document. All the images were saved on a secure server so like we do in HTML, I used the following line of code,

<img src="https://somewebaddress/users.png" />

The word document appeared to be fine for me, but when that document was sent to the client, client was unable to view the images. Now, I guess you all know what my question would be, and that is, is there a way we could somehow make this work. I even tried downloading all the images to disk and giving their path, still in the end, the document only needs to be sent to the client and images do not appear.

Please help me in this regards, Thanks in advance to all

P.S. Please see the following sample (mini) code of the real thing, real document is a bit toooooooo big and kind of confidential 

Code: [Select]
<?php
header("Content-type: application/vnd.ms-word");
header("Content-Disposition: attachment; Filename=Report.doc");
?>

<html>
<head>
<title>TCS Monthly Report $month $year</title>
</head>
<body>

<b><h3>&nbsp;&nbsp;&nbsp;&nbsp;Monthly Operational User Statistics</h3></b>
<br>

    The red line is users logged in over the month. The green area is users recently logged in (last few days).<br>

    <br><img src="https://somewebaddress/users.png" />

</body>
</html>

hi all

First of all

My client have dot net server on windows OS. They want to display some pages which are created by php. Is there any possibility to display like this.

And

How can i connect sql server using php on remote to retrieve data.

Can any one tell me how can i do this.

Thanks in advance

I am using this:

$tags = @get_meta_tags($http["domain"]);

Is there any way to tell if that function can not connect to the server for reasons such as server being down, or an invalid URL?

Hi guys   I'll try keep this simple   I have been given access to a betting xml feed which requires my IP to be whitelisted.   I have whitelisted my home IP and it works fine.   I have whitelisted an IP on server 1 (linux, cpanel), this works fine   I have whitelisted an IP on server 2 (linux, cpanel), this doesn't work and I get:     "simplexml_load_file failed to open stream: http request failed!"   The IP is definitely whitelisted but I think it is something to do with the server. What could be blocking this? allow_url_fopen and allow_url_include are both on by the way   Many thanks Sam

I've been working on this for 8 hours and still cannot get sqlsrv_connect to work. Thank you, Microsoft. My connection strings work for Access DBs and MySQL - but I can't get this to work.

For servername, I've tried:
$serverName = "MYSERVER";
$serverName = "(MYSERVER\MYINSTANCE)";
$serverName = "'MYSERVER\MYINSTANCE'";
$serverName = "(MYSERVER)";

Setup:
PHP Compiler = MSVC9 (Visual C++ 2008)
C:\Program Files (x86)\PHP\v5.3\php.ini
extension_dir C:\Program Files (x86)\PHP\v5.3\ext\
php_sqlsrv_53_nts_vc9.dll in the extension library.

And I'm getting an error from sqlsrv_errors, so it looks like the DLL is working. Pulling my hair out here.

Any ideas?

Code: [Select]
$serverName = "MYSERVER\MYINSTANCE";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"$dbname");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if($conn) {
echo "Connection established.\n";
} else {
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}

sqlsrv_close( $conn);


Connection could not be established. Array ( => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53].  => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. ) [1] => Array ( => HYT00  => HYT00 [1] => 0  => 0 [2] => [SQL Server Native Client 10.0]Login timeout expired  => [SQL Server Native Client 10.0]Login timeout expired ) [2] => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

I have a script that is trying to connect from one server to another and it doesn't seem to let it.
Could someone help me please
Code: [Select]
Can't connect to MySQL server on 'example.com' (4)

Is there a way for me to connect to a directory on a NAS server running a windows share from PHP.
I can connect from the command line using mount, but I want the connect within my PHP script.
Can this be done & if so how?

Hi friends...
I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working.
I google it and found some solutions but not successsful yet.
Can anyone give me detailed guide (step by step) that how i can connect PHP with Sql Server 2005???
Thanks in advance...

My code is: <?php
echo system("openssl s_client -crlf -connect pop3.live.com:995");
?>


This connects fine. However, I don't know how to log in now. If I'm connecting from the terminal I then type "user annie" followed by "pass idontlikesand". I don't know how to pipe this in using php.

Any ideas?

Hi,

When i am trying to run one script on my web server, i get following error

Cannot connect to the database using the info you provided
Access denied for user 'My_Username'@'localhost' (using password: NO)

I filled all info like Host(localhost) Database name(created in cpanel) Username(created in cpanel) Password(i kept blank dont know where to find this)


You help will highly appreciate

Thanks,
Ravindra

well good moring dear folks - hope you are all right and everythings is fine across the atlantic

today i have a  question regarding server-paths - and the absolute and relative in a linux-[opensuse 11.4] lampp-system
well i just installed something in to my Lampp on openSuse  11.4

while setting up  this application - (it is a joomla 1.7.3 ) i wonder how i name the paths


   public $unicodeslugs = '0';
   public $feed_limit = '10';
   public $log_path = 'D:\\Xammp\\xampp\\htdocs\\pre1/logs';
   public $tmp_path = 'D:\\Xammp\\xampp\\htdocs\\pre1/tmp';
   public $lifetime = '15';
   public $session_handler = 'database';



what cou you thinks how shoud i name the paths
well you see above this was a windows box where the pahts originally were taken from

love to hear from you