All Questions
Tagged with sql-server-2005 php
134
questions
0
votes
0
answers
507
views
Connecting to MS SQL Server 2005 using PHP 8.0 or PHP 7.4
I am rebuilding a service that is using MSSQL Server 2005 along with PHP 4.3.11. There is a maintenance issue that I will need to address, and I would prefer to not write obsolete code now only to ...
0
votes
1
answer
110
views
php ms sql server getting null response
While running php code getting null response .
here is my code
<?php
header('Access-Control-Allow-Origin: *');
header("Access-Control-Allow-Methods: GET,POST, OPTIONS");
header('Content-Type: ...
0
votes
3
answers
126
views
Summing DateDiff and output cascading for each row in variables(SQL-Server) (PHP)
it will be very difficult to explain this in words so I will attempt small example to explain you what i want:
for example i have this SQL-Server table
+-------+-------+------+
| TestID| Start | End ...
0
votes
0
answers
63
views
PHP 5.6, MSQL 2005
I am trying to connect PHP 5.6 to Microsoft SQL 2005, but it says
"ODBC Driver 11 for SQL Server does not support connections to SQL Server 2000 or earlier versions." Thank you very much for your ...
-2
votes
1
answer
76
views
Safe way to delete rows [closed]
I am writing code to delete a row based on ID from a SQL Server database. I want to make sure my code is safe from accidentally deleting everything or deleting something other than what it should. ...
0
votes
2
answers
256
views
Copying data from one row to another in the same table SQL
I'm having a hard time copying data from one row to another in the same table. Basically, I have a case where the column [I/O#] equals 'Client1' but I would like to make the [I/O#] column equal to '...
1
vote
1
answer
2k
views
How to Bulk insert with a dynamic value for a column
the situation is this:
I have 200 txt files with different names like 601776.txt each file's name is actually an ID_foo and it contains some data like this (2 columns):
04004 Albánchez
04006 Albox
...
0
votes
1
answer
213
views
PHP PDO fetchAll fails with latin characters
I faced a problem with reading the resaults of a select query which it brings back some strings that contains latin character. In my case i´m using the PDO function with ODBC driver on Windows to ...
2
votes
3
answers
94
views
Echo images using php according to a particular condition [duplicate]
I have this query :
$q4 = "SELECT TOP 5 b.BadgeName, b.BadgeImage FROM BadgeImageTable AS b
INNER JOIN employee_badge AS e
ON e.badge_id = b.BadgeID
WHERE e.employee_id = 2164
ORDER BY e.earned_on ...
-2
votes
1
answer
126
views
echo image according to a condition
I have an HTML tag here :
<span class="fa-stack fa-5x has-badge" >
<div class="badgesize">
<img src="badgeImages/1.png" alt="" >
</div>
</span> -->...
2
votes
1
answer
7k
views
Display an image stored as blob in SQL Server
I have a query to fetch info images :
$q4 = "SELECT TOP 3 b.BadgeName, b.BadgeImage FROM BadgeImageTable AS b
INNER JOIN employee_badge AS e
ON e.badge_id = b.BadgeID
WHERE e.employee_id = 2164
ORDER ...
2
votes
5
answers
125
views
Execute a SQL query/statement conditionally based on table data
First, take a look at this table, basically I need to UPDATE (+1) a ticket WHERE the Username equals to Jondoe AND Money is greater than 200.
Now, I know I can execute 3 queries, first to check if ...
1
vote
1
answer
49
views
PHP seems to add in backslashes when strings are concatenated
I am creating a query where I am passing in parameters and when the string query is concatenated, there are backslashes which are added and this makes the query not run worthy.
$searchQuery = "...
1
vote
1
answer
97
views
No output from SQL Server 2005 T-SQL and PDO when using SET
I am connecting to a SQL Server 2005 database using PDO and don't get output when running certain types of queries using PHP, but I do when running the queries directly in SQL Server Management Studio....
-4
votes
1
answer
368
views
Get data from SQL Server 2005 database and display in html table using php?
I've searched over the net for solutions, but yet nothing worked. I have a database (SQL Server 2005). What i want to do is make a php file that connects to the database, get data (e.g SELECT LoginID, ...