php

I have a PHP search script which queries a MySQL database. Currently, when no results are displayed the script shows and error. How can I make it…

I want to only display 5 results from my database with my PHP search script. How can I do this? My PHP code is: <?php…

What is the correct code to compare username and experience using OR? $regex = new MongoRegex("/".$name."*/i"); $regex2 = new…

I wrote an application on VB6/Access for a retail shop almost 8 yrs ago. They are still using it, and now they are asking for changes/upgrade and…

hello i'v built a search, using MySQL, PHP and jQuery, this is the search query using Prepared Statement.. $sql = "SELECT singer_name FROM singers…

Could $user_input in the following code be chosen to make the MySQL query not behave as expected? <? $regexp = mysql_real_escape_string(…

I am using Mongodb Java driver for my Java client application. it needs to connect to mongodb server running remotely. I am concerned that someone…

Is it preferred to create tables in mysql using a third party application (phpmyadmin, TOAD, etc...) instead of php? The end result is the same, I…

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

Im building an application and Im having a bizarre issue where sometimes an sql statement will work and the very next call the exact same sql…

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

I'm going to create a php web application using mysql for a business in the future and I want to know what sort of server specs do I need? I will be…

I have the following string: SEDCVBNT S800BG09 7GFHFGD6H 324235346 RHGF7U S8-00BG/09 7687678 and the following regex:…

assuming that php is running in web mode via cgi / mod_php / etc... is it safe to assume that $_SERVER['REMOTE_ADDR'] will exist, and further more,…

I have a database table with a datetime column. Everything works fine if a make an Insert using the current date : INSERT INTO table VALUES…

The import breaks in both phpmyadmin and bigdump. The backup is created using a php script I found online: <?php set_time_limit(0);…

I have a PHP Script with the following code: $sql = "UPDATE tbl_p2e_place SET `listingName` = $listing_name, `listingDescription` =…

How to make the new rows to be 1, 2, 3 and the old to be .. the last ones, i mean to reverse the auto increment not to begin with the first added…

I'm getting tired of looking around for a close enough example, time for some quick help! Here is my code: preg_match_all(…

The problem is that deployment MySQL DB is on Linus, ma development MySQL DB on Windows. DB is InnoDB. So arose the problem with case-sensitive…