All Questions
Tagged with php sql-server
25 questions
1
vote
1
answer
121
views
Delete records in different tables
I need to delete the records where UserIndex = 1 and ItemNumber = 5202 in all three tables, all in a single query. I am using SQL 2008 R2.
Table UserInfo1
UserIndex
Itemnumber
ItemCount
1
5202
99
1
...
0
votes
0
answers
194
views
How to join these two tables without Foreign Key? [duplicate]
I want to generate monthly report and the total in a year based on position(jawatan) that has been applied.
Table 1 : tpermohonan (mohon_id pemohon_id mohon_tarikh mohon_online)
mohon_id
pemohon_id
...
- 1
2
votes
1
answer
681
views
How to PIVOT data from MSSQL query and Fetch to PHP view
I have a MSSQL 2005 Database with query content like this :
nopas
code
name
order
00115301
D031
ADAM
1
00130015
D031
ADAM
2
00149998
D026
JAMES
1
00149970
D028
FIKI
1
00142641
D028
FIKI
2
00127700
...
- 21
2
votes
1
answer
178
views
Using PHP form to insert geometry from WKT and SRID into SQL Server 2017
I have a PHP 7.3 form that asks the user for a Name, a WKT and an SRID. I would like to upload the WKT and SRID to SQL Server 2017 so that it creates a geometric object in Upload_WKT_Test using ...
- 121
0
votes
1
answer
61
views
Count up numbers from a specific column [closed]
Hi there was wondering if someone could help me out, and can give me a little code example.
i have a table named "projecten", and columns named "pstatus and pafgifte" these columns have numbers only.
...
0
votes
1
answer
68
views
Azure database - unable to locate in my Azure account
I have an Azure account where a developer that used to work with me has set up an MSSQL database on an Ubuntu VM.
The PHP (CodeIgniter) system I am working on logs in (so database queries work ...
- 135
0
votes
3
answers
1k
views
How Can I clone a database in Microsoft SQL server using PHP?
I am creating a portal where user can create the b2c or b2b store itself, so I need to clone the sample database to perform the task. It's not looking simple to clone the database in MSSQL. Please ...
2
votes
0
answers
2k
views
SQL Server stored procedure not throwing certain kind of error
I noticed an issue in my app recently where an database insert that occurred in a stored procedure was failing, but no exception was getting thrown. The insert failed because a column that doesn't ...
- 151
2
votes
2
answers
2k
views
How do I use 'N' in my prepared SELECT statement
I'm connecting to an SQL Server 2008 database using pdo and the ODBC Driver 13 for SQL Server.
I'm trying to run the following query which searches the database for Chinese characters:
SELECT TOP (...
- 21
8
votes
2
answers
1k
views
How to create recurrent weekdays as columns in a pivot?
I am newcomer to programming and databases and I would be grateful for some help on the following scenario.
I use PHP with SQL Server. I am building an employee attendance system and I would like to ...
- 95
0
votes
1
answer
1k
views
Cannot connect PHP to SQL Server in no way
I installed SQL Server and it shows enabled in phpinfo(). But when setting up joomla on database config page when I choose SQL Server and try to connect the following error comes up
Could not ...
1
vote
3
answers
1k
views
What happens if a delete query times out SQL Server for php?
Technology
I am using the mssql extension to php (on linux) to send queries to SQL Server.
The Setup.
I have a table that builds up disposable data rather quickly. It took me longer than expected ...
- 343
1
vote
0
answers
2k
views
SQL state S1000 in SQLConnect (but not all the time)
I have a CentOS6 webserver and a database server (MS SQL Server 2012). When I use the website everything is going fine except that once an hour or so I get a can't connect error in my php code. I ...
- 11
0
votes
2
answers
106
views
Ideal configuration and structure for single db + single table + 20 million static records
I've spent the last few weeks trying to learn SQL the best I can and after doing research and reading many articles, specifically (This SO Thread), I have ran out of luck and was hoping to get some ...
- 103
1
vote
3
answers
237
views
SQL trigger when a row is updated question
My problem is as follows.
I an creating a MySQL database for a company that whenever a row is updated on the DB i want to have a trigger that calls a cURL request to transfer the updated information ...
- 135