PHP - Php On New Server No Longer Connects (mssql)

HI,

I've upgraded from PHP version 5.2 to PHP version 5.4 and are not able to load / find mssql extension ?

How do I use MSSQL in version 5.4 ??

Is MSSQL not supported in this version or am I (hopingly) missing something ???

Regards
Dieter

I'm having problems with enabling the sort functions of jqgrid.  I think I've narrowed the problem down to the way MSSQL is returning the data to the SQL query.

In an effort to troubleshoot, I've drastically simplified the problem.  The query I'm using is below.

Code: [Select]
SELECT * FROM dbo.test ORDER BY locationName
When I run the query directly in MSSQL Management Studio, the top 5 ID entries are 132, 1309, 1295, 1281, 1267.

When I run the corresponding code in PHP, the top 5 ID entries are 1266, 1267, 1268, 1269, 1270 - it seems to be ignoring my order by clause.  Is there something I need to do to force it to honor the ORDER BY locationName?

Code: [Select]
$kpiQuery = "SELECT * FROM dbo.test ORDER BY locationName";
$result = mssql_query($kpiQuery);
while($kpiRow = mssql_fetch_array($kpiResult)) {
echo $kpiRow[plDataID]."<br>";
}

Hi,

I have been working with inserting unicode characters into mssql database from a php application.

My php web application displays the chinese characters as i entered and retrieves from database properly. But when I take a look at the database the fields are populated with some other values other than the characters i inserted.

When i developed the same application in ASP.net the database has correct values inserted into it.

Here is my code in php:

Code: [Select]
<?php

// direct insert
$var = mssql_connect('RAL-DEV-SQL01','TestDBSa','TestDB$@');

$selected = mssql_select_db('TestDB', $var);


$myVar="&#26085;&#24120;&#29983;&#27963;";


$myChineseVar=$myVar;
echo $myChineseVar;


$query = "insert into TestChinese (TestName) values (N'{$myChineseVar}')"; 

$result = mssql_query($query,$var);

echo "Inserted<br>";
echo $query;


echo "<br>Result<br>";
$result2 = mssql_query("SELECT TOP 10 * FROM [TestChinese] order by SeqNum desc",$var);
while($nt=mssql_fetch_array($result2)){
echo "$nt[SeqNum] - "."$nt[TestName] -";

echo "<br>";

} 

mssql_close($var);

?>
Can someone help me with this problem

Thanks

Hi,

I have tried to merge two queries into one however a piece of code keeps coming up with an error:

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource.

It relates to this.  I cant see it doesn't work and I have tried around 10 different options but this is the nearest I can get.  Can anyone advise me what the problem is and why this no longer works please?

while($row = mysql_fetch_assoc($myQuery)) 


<?php

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

if( isSet($_GET['description'])) 
$description = $_GET['description'];


if(isSet($_GET['price'])) 
$price = explode('-',$_GET['price']);
$low = (int)$price[0];
$high = (int)$price[1];

($myQuery = "SELECT * FROM productfeed WHERE 1 . 
if(isset($description)) ' AND if description = '. $description;
if(isset($price)) ' AND if price = '. $price;
. ");

while($row = mysql_fetch_assoc($myQuery)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

$fulldescription = substr("$fulldescription", 0, 400);    

echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image' width=\"95%\" /></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
}

Hi, thanks in advance for any help here.  I have a PHP 'contact us' form on my website that recently stopped returning the information that gets entered into the form.  I don't know why it's no longer working and was hoping someone here could help.  It's worked for the last 4 years and only stopped working within the last week.  I still get the email, but none of the information is returned, only blanks.  Any ideas?

Here's the script I'm using:
Code: [Select]
<?php

      /*----------------------*/ 
      /*   URL of the site.   */
      /*----------------------*/
      $site_URL    =    "http://www.Website.com/";       
      
      /*----------------------*/ 
      /*   Name of the site.   */
      /*----------------------*/
      $site_Name    =    "Website.com";                   
      
      /*----------------------*/ 
      /*   ADMIN email id.   */
      /*----------------------*/
      $admin_from =    "webmaster@Website.com";
      
      /*----------------------*/ 
      /*   ADMIN email id to which comments are sent.   */
      /*----------------------*/
      $admin_email =    "info@Website.com";
      

   
   $name =     $_REQUEST["firstname"];
   $lastname = $_REQUEST["lastname"];
   $email =    $_REQUEST["email"];
   $zipcode =  $_REQUEST["zipcode"];
   $phone =    $_REQUEST["phone"];
   $message =  $_REQUEST["message"];

   $subject = "$site_Name has Received your Message";
        
   $sendmessage = "<font face='tahoma, verdana, arial, helvetica' size=2>New Comments Received...<br><br>";
   $sendmessage .= "<strong>Name:</strong> $name $lastname<br>";
   $sendmessage .= "<strong>Zipcode:</strong> $zipcode<br>";
   $sendmessage .= "<strong>Phone:</strong> $phone<br>";
   $sendmessage .= "<strong>Email:</strong> <a href='mailto:$email' style='color:#6095cc; text-decoration: none;'>$email</a><br>";
   $sendmessage .= "<strong>Message:</strong> $message<br>";
   
   $sendmessage .= "<br><a href='$site_URL' target=_blank>$site_Name</a></font>";
       
   $headers = "Content-Type: text/html; charset=iso-8859-1\n"; // Mime type
   $headers .="From: $site_Name Registration <$admin_from>\n";
   
   
   mail($admin_email, $subject, $sendmessage, $headers);
   
      
   $reply_msg = "<font face='tahoma, verdana, arial, helvetica' size=2>Thank you for your comments at $site_Name.  We will reply soon!<br>";
   $reply_msg .= "<br>- <a href='$site_URL' target=_blank>$site_Name</a></font>";
   
   $headers = "Content-Type: text/html; charset=iso-8859-1\n"; // Mime type
   $headers .="From: $site_Name<$admin_from>\n";
   
   // send an email to confirm the referer.
   mail($email, "$site_Name - Your comments have been received!", $reply_msg, $headers);
   
?>


<center>
  <font face='tahoma, verdana, arial, helvetica' color='#333333'>
  <h2>
    <?=$site_Name?>
  </h2>
  <p><font size="2" face="Arial, Helvetica, sans-serif"><strong>Please wait while your comments are being sent.</strong>.<br />
    If your page does not refresh automatically, <a href="<?=$site_URL?>">Click Here</a>.</font></p>
</center>
<script language="javascript">   
   window.location.href = "<?=$site_URL?>";
</script>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi every one,
i am trying to connect with a remote SQL server on window platform.
i have hostname, username, password and database name, but when i try t connect using mssql_connect($server,$username,$password)

i got this Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:

Thanks

Ok, I made some changes to my code (change in variable names only) and now it doesn't seem to work.

Here is the code.


<?php
if ($_REQUEST['postal'] != "" && $_REQUEST['lbs'] != "") {
$postal = $_REQUEST['postal'];
$lbs = $_REQUEST['lbs'];
$type = $_REQUEST['type'];
if ($type == "splist") {
$ztype = "cansp_zone" ;
$lbstype = "sp";
} else {
$ztype = "canmp_zone";
$lbstype = "mp";
}
$qP1 = "SELECT * FROM " . $dbprefix . "_canzones WHERE canzone_postal = '$postal'  "; $which = $handle_db2;
$rsP1 = mysql_query($qP1,$which);
if (mysql_num_rows($rsP1) > 0) {

$row1 = mysql_fetch_array($rsP1);

extract($row1);
$prov = trim($canzone_prov);
$zone = trim($canzone_zone);

$dzone = $ztype.$zone;
$dlbs = "can" . $lbstype . "_lbs";


$query = "SELECT $dzone FROM " . $dbprefix . "_can" . $type . " WHERE $dlbs = '$lbs'  "; $which = $handle_db2;
    $result = mysql_query ($query,$which);
    $row = mysql_fetch_array($result);
    $dzone = $row[0];

$qP3 = "SELECT * FROM settings WHERE storeid = '$dbprefix'  "; $which = $handle_db2;
$rsP3 = mysql_query($qP3,$which);
$row3 = mysql_fetch_array($rsP3);
extract($row3);
$taxsetting = trim($taxsetting);
$gst = trim($gst);
$pst = trim($pst);
$hst = trim($hst);
$cp_fuelcharge = trim($cp_fuelcharge);
$cp_markup = trim($cp_markup);

include("./inc/taxcalc.php");
include("./inc/markcalc.php");


./inc/markcalc.php is as follows:

<?php
if ($cp_markup != "") {
$cp_mark = ($dzone * ($cp_markup / 100));


When I output $cp_mark, it comes out as the same value as $cp_markup

Any ideas?

I've got some PHP code that accesses SQL on an Amazon cloud server. Other machines running Unix and Windows can perform accesses fine using the server name (IP for Windows, label for Unix), database name (string) and a password (string).  However, the same code FAILS on OSX (my Macbook Pro).

SQL managers on my MBP have no problem accessing it, since I've made the proper exceptions on the AWS firewall.  But PHP can't do any MS SQL reads of this database.

Is there something else I don't know?  Is there some other key information being exchanged that my MBP needs to send that I can't see?

TIA!!

Hello,   I am trying to run a report as per the below mssql query:  

$query = "SELECT tblWJCItem.AddedDescription, tblWJC.WJCPrefix, tblWJC.WJCNo, tblWJCItem.MaterialName, tblStockFamily.StockFamily, tblWJCItem.WeightToSend, tblWJC.DateCreated, tblWJC.WJCStatusID FROM tblWJC INNER JOIN tblCustomer ON tblWJC.CustomerID = tblCustomer.CustomerID INNER JOIN tblWJCStockStatus ON tblWJC.WJCStockStatusID = tblWJCStockStatus.WJCStockStatusID INNER JOIN tblStockStatus ON tblWJC.WJCID = tblStockStatus.WJCID LEFT OUTER JOIN tblWJCProductLine ON tblWJC.WJCID = tblWJCProductLine.WJCID
LEFT OUTER JOIN tblWJCStockItem ON tblWJCProductLine.WJCProductLineID = tblWJCStockItem.tblWJCStockItem INNER JOIN tblStockFamily ON tblWJCItem.ProductFamilyID = tblStockFamily.StockFamilyID WHERE tblCustomer.CustomerName = 'NAME' AND tblWJCStockStatus.WJCStockStatus <> 'Stock Usage Confirmed' ORDER BY tblWJC.WJCID";

Hi,
I knew the way to connect to mysql but i don't know how to connect mssql.
Is it the same?

here's an example for mysql.
please teach me the mssql.

$con = new mysqli(DB_HOST,DB_USER,DB_PASS,DB_NAME);

$sql = "SELECT COUNT(*) FROM numbers";
$result = $con->query($sql);
$r = $result->fetch_row();



thanks

$query = "SELECT
Table1.*,
Table2.A,
Table2.B,
Table2.C,
Table2.D,
Table2.E
FROM Table1
INNER JOIN
Table2 ON Table1.A = Table2.A

Issue is that there are multiple matches for some instances, like so:

Table1.A value = 1777 (only once since it is a UniqueID)
Table2.A value = 1777 (3 records with this ID value)

So I will get 3 records returned since Table1.A matches 3 records in Table2.A. I want to merge the 3 records in Table2 into 1 record and then match that with Table1 where the UniqueID is the same. Make sense?

Hi all,   I am trying to do a query on a database that takes a variable from a html drop down box. I've tried so many different forums and can't find the answers.    HTML PAGE:       <html>

I am using PHP with ODBC to connect to an existing MSSQL database to query for some names.  When I query a name that has an apostrophe in it, I get an error.

Example typing O'Malley as the name:

Quote

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'malley'., SQL state 37000 in SQLExecDirect



I have used addslashes to the string but get the same result:

Code: [Select]
$string = addslashes($_POST['string']);

$connect = odbc_connect("$mssql_name", "$mssql_user", "$mssql_pass");

$query_mssql = "SELECT pr.NameFirst, pr.NameLast, pr.NameMiddle, pr.Birthdate, p.Barcode, p.OrganizationID
FROM PatronRegistration pr
JOIN Patrons p ON (pr.PatronID = p.PatronID)
WHERE pr.NameLast = '$string'";

$result = odbc_exec($connect, $query_mssql);

Any ideas?