# General Database (Oracle, SQL Server, etc) **URL:** https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=1 [Latest](https://www.phphelp.com/latest.md) · [Categories](https://www.phphelp.com/categories.md) **Page:** 2 --- ## [what is the correct way to do a sql server Update statement with PHP variables ](https://www.phphelp.com/t/what-is-the-correct-way-to-do-a-sql-server-update-statement-with-php-variables/26075)
**Author:** [@kat35601](https://www.phphelp.com/u/kat35601)\ **Replies:** 2\ **Last updated:** [October 10, 2017, 2:09pm UTC](https://www.phphelp.com/t/what-is-the-correct-way-to-do-a-sql-server-update-statement-with-php-variables/26075 "2017-10-10T14:09:46Z")
I am getting Order number, Order Status, and assignment number from a file that I download and I need to take this information and update a sql server table but I really don’t know how to do that. In my code you will see… --- ## [PHP - SQL Server Bulk Insert](https://www.phphelp.com/t/php-sql-server-bulk-insert/26049)
**Author:** [@gabeconc](https://www.phphelp.com/u/gabeconc)\ **Replies:** 0\ **Last updated:** [September 10, 2017, 10:06pm UTC](https://www.phphelp.com/t/php-sql-server-bulk-insert/26049 "2017-09-10T22:06:30Z")
Hi, I need to import a CSV (or Excel) file into a SQL Server table. For testing purposes, I have following SQL Code code: SQL CODE \>\>\>\>\>\>\>\>\>\>\>\>\>\>\>\>\>\>\>\> BULK INSERT TEST\_TABLE FROM ‘\\SERVER1\\public\\Purcha… --- ## [query and fetch](https://www.phphelp.com/t/query-and-fetch/26045)
**Author:** [@vinnyboy](https://www.phphelp.com/u/vinnyboy)\ **Replies:** 0\ **Last updated:** [September 9, 2017, 2:56am UTC](https://www.phphelp.com/t/query-and-fetch/26045 "2017-09-09T02:56:23Z")
I have used this code for the last 4 years with no problem, after my provider upgraded to php 7 it has stopped working. I replaced all mysql references with mysqli and I am now able to connect with the database but the … --- ## [ON DUPLICATE KEY on many rows](https://www.phphelp.com/t/on-duplicate-key-on-many-rows/25933)
**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [July 14, 2017, 5:51pm UTC](https://www.phphelp.com/t/on-duplicate-key-on-many-rows/25933 "2017-07-14T17:51:11Z")
Im making the user able to sort his own data. Lets say I have multiple animals in each row, with its own Uniqe Id. Then I let the user sort the animals with a number from 1 to x. So to do this I have to update multiple … --- ## [MS IIS PHP connection to MS SQL Server help](https://www.phphelp.com/t/ms-iis-php-connection-to-ms-sql-server-help/25874)
**Author:** [@dstran](https://www.phphelp.com/u/dstran)\ **Replies:** 0\ **Last updated:** [May 8, 2017, 3:55pm UTC](https://www.phphelp.com/t/ms-iis-php-connection-to-ms-sql-server-help/25874 "2017-05-08T15:55:48Z")
Windows 2012 R2 64 bit MS IIS 8.5, PHP 7.1.1 on one server MS SQL 2012 on a different server Can’t connect to DB downloaded SQLSRV4.0, extracted and placed in php/ext dir added to php.ini \[PHP\_SQLSRV\_71\_NTS\] exte… --- ## [How PHP Libraries To Send HTTP Requests ](https://www.phphelp.com/t/how-php-libraries-to-send-http-requests/25827)
**Author:** [@davissteve](https://www.phphelp.com/u/davissteve)\ **Replies:** 2\ **Last updated:** [April 12, 2017, 11:12pm UTC](https://www.phphelp.com/t/how-php-libraries-to-send-http-requests/25827 "2017-04-12T23:12:43Z")
I am fresher in PHP and I want to how can I send Request PHP Libraries To HTTP. I found a post about that topic but thier technique not working \[:::LINK REMOVED:::\] can any one sugeest mehow can I send PHP Libraries ToHT… --- ## [PHP health checks](https://www.phphelp.com/t/php-health-checks/25828)
**Author:** [@tippet5x](https://www.phphelp.com/u/tippet5x)\ **Replies:** 0\ **Last updated:** [April 11, 2017, 5:41pm UTC](https://www.phphelp.com/t/php-health-checks/25828 "2017-04-11T17:41:56Z")
my current script worked fine until the dba change to windows auth using my computernames$ can someone help convert the below use windows auth? thanks \ **Author:** [@mac041586](https://www.phphelp.com/u/mac041586)\ **Replies:** 1\ **Last updated:** [October 23, 2016, 8:00am UTC](https://www.phphelp.com/t/mysqli-db-search-engine-problems/25538 "2016-10-23T08:00:06Z") I have been trying to get this and many others like it to work. the issue is when I submit for the search I go to a blank page… I have worked out all the kinks other than this one and it has been reoccuring regardless of… --- ## [Database](https://www.phphelp.com/t/database/25019)
**Author:** [@davidmartin0](https://www.phphelp.com/u/davidmartin0)\ **Replies:** 2\ **Last updated:** [March 25, 2016, 4:41pm UTC](https://www.phphelp.com/t/database/25019 "2016-03-25T16:41:30Z")
In Windows Explorer, when I double click on a dbf file (of form .dbf), instead of opening the file in VFP, I get a message “.fxp is not an object file”. e.g. clicking on T\_DCLNT.DBF, gives message “t\_dclnt.fxp is not a… --- ## [Converting from php\_mssql.dll to php\_sqlsvr.dll](https://www.phphelp.com/t/converting-from-php-mssql-dll-to-php-sqlsvr-dll/24903)
**Author:** [@Mych](https://www.phphelp.com/u/Mych)\ **Replies:** 5\ **Last updated:** [February 3, 2016, 5:20pm UTC](https://www.phphelp.com/t/converting-from-php-mssql-dll-to-php-sqlsvr-dll/24903 "2016-02-03T17:20:06Z")
I have acquire an existing project which has had to move servers. The new server was installed with a later version of PHP and as such this version does not support php\_mssql so I have had to use php\_sqlsvr. I’ve conver… --- ## [inserting data into DB from .sql file uisng php](https://www.phphelp.com/t/inserting-data-into-db-from-sql-file-uisng-php/24305)
**Author:** [@wilson382](https://www.phphelp.com/u/wilson382)\ **Replies:** 5\ **Last updated:** [June 8, 2015, 5:00pm UTC](https://www.phphelp.com/t/inserting-data-into-db-from-sql-file-uisng-php/24305 "2015-06-08T17:00:19Z")
Hello Guys, In my website, everytime i delete a user, i backup their whole profile and related data into a sql file. a sql backup for a given user will look like this \[code\]USE database\_name; //tell which database to … --- ## [login works fine on desktop but stops working on mobile](https://www.phphelp.com/t/login-works-fine-on-desktop-but-stops-working-on-mobile/24301)
**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [June 7, 2015, 9:02pm UTC](https://www.phphelp.com/t/login-works-fine-on-desktop-but-stops-working-on-mobile/24301 "2015-06-07T21:02:36Z")
on desktop you can sign in and it will take you to your account details with everything listed correctly. on mobile it will say you logged in successfully but it’ll take you to the account page as if it were a welcome gu… --- ## [PHP code for populating an html table stopped working when web site moved.](https://www.phphelp.com/t/php-code-for-populating-an-html-table-stopped-working-when-web-site-moved/24251)
**Author:** [@tadcock1158](https://www.phphelp.com/u/tadcock1158)\ **Replies:** 4\ **Last updated:** [May 12, 2015, 5:37pm UTC](https://www.phphelp.com/t/php-code-for-populating-an-html-table-stopped-working-when-web-site-moved/24251 "2015-05-12T17:37:10Z")
I have a php site that was running fine on Windows Server 2008 in IIS. That server is being decommissioned and I was given a Windows Server 2012 R2 Server running IIS 8.5. The site is working fine except for an html ta… --- ## [Pulling crypt passwords from MySQL](https://www.phphelp.com/t/pulling-crypt-passwords-from-mysql/24199)
**Author:** [@r-man](https://www.phphelp.com/u/r-man)\ **Replies:** 2\ **Last updated:** [April 25, 2015, 1:52am UTC](https://www.phphelp.com/t/pulling-crypt-passwords-from-mysql/24199 "2015-04-25T01:52:48Z")
I am trying to get crypt passwords out of a database for a members log in. A person will type in their name and password and if it is recognized in the database table then it will let them in to other areas of the web se… --- ## [Data from MySQL into an PHP dropdown box](https://www.phphelp.com/t/data-from-mysql-into-an-php-dropdown-box/24189)
**Author:** [@r-man](https://www.phphelp.com/u/r-man)\ **Replies:** 2\ **Last updated:** [April 17, 2015, 5:35pm UTC](https://www.phphelp.com/t/data-from-mysql-into-an-php-dropdown-box/24189 "2015-04-17T17:35:17Z")
I am having trouble getting all data from MySQL database table into a drop-down form. I have a table in a database that has four columns like this this example: Products table: Salesman id – which is a foreign key Pr… --- ## [Geting data for a chart](https://www.phphelp.com/t/geting-data-for-a-chart/24180)
**Author:** [@r-man](https://www.phphelp.com/u/r-man)\ **Replies:** 6\ **Last updated:** [April 16, 2015, 1:59am UTC](https://www.phphelp.com/t/geting-data-for-a-chart/24180 "2015-04-16T01:59:11Z")
I am kind of new to MySQL and databases and I am having trouble getting the right information out of a database for a chart I am using. I have a database with three tables. The tables look like this: Salesmen Table: Sa… --- ## [Using PHP to get data from SQL Server](https://www.phphelp.com/t/using-php-to-get-data-from-sql-server/24010)
**Author:** [@JohnM](https://www.phphelp.com/u/JohnM)\ **Replies:** 33\ **Last updated:** [February 19, 2015, 8:28pm UTC](https://www.phphelp.com/t/using-php-to-get-data-from-sql-server/24010 "2015-02-19T20:28:38Z")
Hello I am a desktop computer database programmer. I have not done any web programming. I need to convert an Access application that uses data from SQL Server. I would like to use HTML to make the app. Can I use PHP… --- ## [relation "apps" does not exist in heroku when trying to create a table](https://www.phphelp.com/t/relation-apps-does-not-exist-in-heroku-when-trying-to-create-a-table/22093)
**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 2\ **Last updated:** [January 30, 2015, 11:34am UTC](https://www.phphelp.com/t/relation-apps-does-not-exist-in-heroku-when-trying-to-create-a-table/22093 "2015-01-30T11:34:47Z")
This is the query \[php\]$sql = “CREATE TABLE IF NOT EXISTS apps ( id int(11) unsigned NOT NULL auto\_increment, name varchar(100) NOT NULL default ‘’, description varchar(5000) NOT NULL default ‘’, link varchar(200) N… --- ## [Unexpected Math Result](https://www.phphelp.com/t/unexpected-math-result/23526)
**Author:** [@cadamhill](https://www.phphelp.com/u/cadamhill)\ **Replies:** 2\ **Last updated:** [January 22, 2015, 11:16am UTC](https://www.phphelp.com/t/unexpected-math-result/23526 "2015-01-22T11:16:16Z")
The below code is supposed to yield a calculation of kWh onto an invoice. it does produce a result and in the correct place. I am able to change parameters and watch the values change, so I know its in the right locati… --- ## [MOVED: Conversion of a database model from Vertabelo to Propel's schema.xml](https://www.phphelp.com/t/moved-conversion-of-a-database-model-from-vertabelo-to-propels-schema-xml/23877)
**Author:** [@astonecipher](https://www.phphelp.com/u/astonecipher)\ **Replies:** 0\ **Last updated:** [January 10, 2015, 6:30pm UTC](https://www.phphelp.com/t/moved-conversion-of-a-database-model-from-vertabelo-to-propels-schema-xml/23877 "2015-01-10T18:30:35Z")
This topic has been moved to The Occasional Tutorial. \[iurl\]http://www.phphelp.com/forum/index.php?topic=24369.0\[/iurl\] --- ## [Deleting records from mySQL](https://www.phphelp.com/t/deleting-records-from-mysql/19703)
**Author:** [@cracker](https://www.phphelp.com/u/cracker)\ **Replies:** 3\ **Last updated:** [November 19, 2014, 12:50pm UTC](https://www.phphelp.com/t/deleting-records-from-mysql/19703 "2014-11-19T12:50:51Z")
My project has users log in and create orders. They create their own Order Numbers. What I need to do is have them be able to delete their own orders. Eg. User #1 may create an Order #101, and User #2 also has an Order … --- ## [PHP, utf8 and MySql headache](https://www.phphelp.com/t/php-utf8-and-mysql-headache/23418)
**Author:** [@Rodders101](https://www.phphelp.com/u/Rodders101)\ **Replies:** 2\ **Last updated:** [October 5, 2014, 10:42am UTC](https://www.phphelp.com/t/php-utf8-and-mysql-headache/23418 "2014-10-05T10:42:52Z")
Hi all, I am hoping someone can provide me with some assistance are a very frustrating problem. I am a beginner with php and modified a Chat script (taken from here: http://www.sanwebe.com/2013/04/creating-shout-box-fac… --- ## [Need Help Deciding Best Practicce](https://www.phphelp.com/t/need-help-deciding-best-practicce/23338)
**Author:** [@jmastrom](https://www.phphelp.com/u/jmastrom)\ **Replies:** 1\ **Last updated:** [September 16, 2014, 9:13pm UTC](https://www.phphelp.com/t/need-help-deciding-best-practicce/23338 "2014-09-16T21:13:22Z")
Howdy, I need help deciding the best practice/efficiency on how to present data from tow tables, and when to make the calls. Table “cruises” references table “itineraries” to present the itinerary of the cruise. On the… --- ## [PDO FETCH OBJ Return False](https://www.phphelp.com/t/pdo-fetch-obj-return-false/23279)
**Author:** [@tompasto](https://www.phphelp.com/u/tompasto)\ **Replies:** 1\ **Last updated:** [August 31, 2014, 1:32am UTC](https://www.phphelp.com/t/pdo-fetch-obj-return-false/23279 "2014-08-31T01:32:35Z")
Hello, I did a update of my php server version and now one of my PDO query doesn’t work anymore (it was working for more than a year). It return Boleen false. I’m connected to a Mssql server. My connection is correct… --- ## [Help converting mysql to mysqli](https://www.phphelp.com/t/help-converting-mysql-to-mysqli/23234)
**Author:** [@McMahonNetwork](https://www.phphelp.com/u/McMahonNetwork)\ **Replies:** 8\ **Last updated:** [August 16, 2014, 11:40pm UTC](https://www.phphelp.com/t/help-converting-mysql-to-mysqli/23234 "2014-08-16T23:40:38Z")
I have a script that runs everyday using a cron job but I can’t figure out why the database won’t update. This script is from 2005, I haven’t scripted since then so learning mysqli has been difficult. I would appreciat… --- ## [UPDATE and CAST data](https://www.phphelp.com/t/update-and-cast-data/22527)
**Author:** [@dave1950](https://www.phphelp.com/u/dave1950)\ **Replies:** 1\ **Last updated:** [April 19, 2014, 5:18pm UTC](https://www.phphelp.com/t/update-and-cast-data/22527 "2014-04-19T17:18:36Z")
I need to UPDATE and CAST data from two columns with Type int into a single column with Type varchar. The new field is FullDocNo (varchar) with data being cast, concatenated, and copied from DocNo (int) and SequenceNo … --- ## [SELECT query is returning duplicates records](https://www.phphelp.com/t/select-query-is-returning-duplicates-records/22416)
**Author:** [@wilson382](https://www.phphelp.com/u/wilson382)\ **Replies:** 12\ **Last updated:** [March 29, 2014, 2:31am UTC](https://www.phphelp.com/t/select-query-is-returning-duplicates-records/22416 "2014-03-29T02:31:07Z")
Hello Friends, I have this query, which select fields from 2 tables SELECT D.debtor\_id,D.fname,D.lname,M.lastDate,M.WeeksDue FROM debtor\_information D,debtor\_money M WHERE D.creditor\_id='457456' AND M.creditor\_id='4574… --- ## [php not actually running queries? Simple search, store results, update](https://www.phphelp.com/t/php-not-actually-running-queries-simple-search-store-results-update/22010)
**Author:** [@KevinS](https://www.phphelp.com/u/KevinS)\ **Replies:** 2\ **Last updated:** [February 1, 2014, 2:12pm UTC](https://www.phphelp.com/t/php-not-actually-running-queries-simple-search-store-results-update/22010 "2014-02-01T14:12:30Z")
Trying to simply add 10k to the player balance on a minecraft server that uses a 2 tables for currency: 1 that contains the username and id. 2. contains the amount and id. They are linked together via the id, so I have t… --- ## [Simple Search/return data/use data query](https://www.phphelp.com/t/simple-search-return-data-use-data-query/22009)
**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [January 31, 2014, 7:00pm UTC](https://www.phphelp.com/t/simple-search-return-data-use-data-query/22009 "2014-01-31T19:00:23Z")
Trying to simply add 10k to the player balance on a minecraft server that uses a 2 tables for currency: 1 that contains the username and 2. contains the amount and id. They are linked together via the id, so I have to se… --- ## [MySQL Replication using phpMyAdmin.](https://www.phphelp.com/t/mysql-replication-using-phpmyadmin/21489)
**Author:** [@bradjtrammell](https://www.phphelp.com/u/bradjtrammell)\ **Replies:** 5\ **Last updated:** [November 8, 2013, 3:09pm UTC](https://www.phphelp.com/t/mysql-replication-using-phpmyadmin/21489 "2013-11-08T15:09:31Z")
Now I’ve tried this a few different times, a few times with fresh installs of mysql and phpmyadmin, and a few times with databases with existing data, and each time I seem to get the same error. So I have two MySQL data… [Previous page](https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md) [Next page](https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=2)