Professional Hypertext Preprocessor, a widely used platform for dynamic web applications.

learn more… | top users | synonyms

0
votes
0answers
12 views

Error: “mod_fcgid: can't apply process slot for” makes my server unresponsive for a period of time

Following error keeps appearing in my PHP error_log mod_fcgid: can't apply process slot for So far I pinpointed this issue to following settings in httpd.conf FcgidMaxProcessesPerClass 8 ...
0
votes
0answers
21 views

MySQL count multiple values in one column by PHP [migrated]

This my data in Column interested (Education; Job) I use this code: $sql3="SELECT interested, COUNT(*) as Education FROM register GROUP BY interested"; if ($result3=mysqli_query($con,$sql3)) { ...
-2
votes
0answers
16 views

My login page is returning Unknown column 'sitlanic' in 'where clause'

My login page is returning: Unknown column 'sitlanic' in 'where clause' $uname = $_POST['name']; $pass=$_POST['b']; $sql="select*from names where username=$uname and password=$pass"; ...
0
votes
2answers
32 views

Spanish characters saved incorrect in Mysql

I have googled this already, but I couldn't find what's wrong in my situation. I have a wordpress site that has a lot of non-english users which type in words such as "español" it is printed ...
0
votes
0answers
15 views

Sum data from 3 tables(joining), but one of may no data then other tables data will show

I am making a stock group summary report for this I am making Sum data from 3 joining tables, but one of may no data then other tables data will show. I have 3 tables as: ac_stock_item, ...
0
votes
1answer
42 views

Copy table form MS-SQL server to MySQL, is it possible? [closed]

I have a procedure, say "proc1", inside a MS-SQL server. I would like to create a table (copy of proc1) inside a MySQL server. So far what I do is this: 1-Create a connection to MS-SQL Server 2- run ...
1
vote
0answers
18 views

implement geo / spatial / proximity search with php and mysql — what have you done successfully

For my website's users, I want to implement a worldwide geo / spatial / proximity search with php and mysql. I want to do this as simply and minimally as possible. What is the minimum data I should ...
-1
votes
0answers
26 views

update other column in mysql table from concat and substr values from first column and variables in php [closed]

I need a help regarding this. How to Update second and third column in MySQL table from substr and concat values from first column along with variables in php. My query is: mysql_query ('UPDATE ...
1
vote
0answers
30 views

Different types of users in one table, How to add data off different users

I have 5 type of users: Super Admin Coordinator Supervisor Student External Examiner All of them have some common attributes like ID, name, email etc. I have inserted them in one table user ...
-1
votes
0answers
20 views

How to fill data of PostgreSQL into combobox using PHP [migrated]

I want to fetch data from PostgreSQL into my popup box. In the popup window, two comboboxes are there and on these comboboxes I want to fetch data from SQL into comboboxes. Here is the code of popup ...
0
votes
2answers
24 views

Delete duplicate with same ID PHP/PDO/MYSQL

I'm new to databases and I need your help I'm working on a website and I have few problems. I'm using PDO. There is a user table, with unique ID, name and password. User enters his username and ...
1
vote
2answers
23 views

Fulltext searching on shared hosting - 2000 Entires with around 500 words each

I'm fairly new to db administration and would appreciate some help. I want to host a site which requires full text search on around 2000 items, each with around 500 words each. I need this to be ...
0
votes
0answers
30 views

Fetching data from 3 tables

Wanna fetch data from 3 tables by mysql query to display in feed. But stack. My query is "SELECT f.leaderId, f.followerId, c.ccId, c.ccTitle, c.ccCity, c.ccCountry, c.ccFlag, c.uId, ...
5
votes
1answer
19 views

Execute query cache on startup - Reasonable?

I have a rather database intensive application for a server which is intended to be turned off and on throughout the day. The issue comes at first use of the application after startup; it is slower ...
-1
votes
1answer
106 views

Grouping by each user's statuses or activity datetime

I’ve been trying to figure out in what best way I can implement a stream of activities, that groups a user’s activities that were done on a specific date where the time hh:mm:ss doesn’t differ much ...
3
votes
1answer
49 views

Creating a query to pull very specific information using four tables

I have four tables, with a structure like this: testData This table holds all test data for every user. Each row associates one response for a question, divided up by test. A user can have many ...
1
vote
0answers
21 views

How to upload a large file (above 15 MB) in MYSql database, using Codeigniter [closed]

How to upload a large file (above 15 MB) in MYSql database, using Codeigniter. When I try to upload a file of size 15MB, I get this error Fatal error: Allowed memory size of 67108864 bytes ...
2
votes
0answers
48 views

MySQL high performance difference between two similar databases

I'm currently upgrading from TecDoc 2015 Quarter 2 database to TecDoc 2015 Quarter 4 database. Q2 Database: 240,838,107 rows InnoDB utf8_general_ci 23.2 GiB Q4 Database: 265,508,380 rows ...
0
votes
0answers
17 views

Error on connecting to mysqli

I have a virtual server that I'm running MySQL Server on that and Operation System is Windows Server 2012. from my own System I mean home PC , easily I can connect remotely to MySQL Server without ...
1
vote
1answer
22 views

SELECT with equal chance between same IDs - MySQL

How can I SELECT data with equal chances for same IDs in MySQL (for php). For example, assume below data structure: id value 1 alfa 1 beta 1 gamma 2 hello 2 bye 3 sky I want ...
0
votes
0answers
41 views

SET FOREIGN_KEY_CHECKS=1; Commands out of sync; you can't run this command now

I am getting errors that I do not know how to solve using MySQL and php. The error is this... SET FOREIGN_KEY_CHECKS=1; Commands out of sync; you can't run this command now I am trying to run the ...
0
votes
2answers
17 views

Migrating Pure PHP Site with Associated Database To New Server

First, let me say I'm not a DBA or network admin, but have moved large scale CMS websites from host to host. But, I have never moved a pure php coded database driven website from one host to another. ...
1
vote
2answers
23 views

How to subtract an object from another in PHP/MySQL?

I am printing totalbooks with this code: $query ="select sum(copies) as totalbooks from booksdetail"; $result=mysqli_query($con, $query); while($row=mysqli_fetch_array($result)){ echo ...
0
votes
0answers
27 views

Auto Insert new entry's in different database

I have 2 websites with similar MySQL database and both on same server (Linux) When a user register on website A I want to copy the user data to website B database (adb.users to bdb.users). Is there a ...
0
votes
1answer
147 views

Load csv file to mysql using load data local infile

I need a simple way to load a csv file from my computer to the database (which is on a remote server). I'm trying to load the file using a php page that executes this code: $file = ...
0
votes
0answers
8 views

MySQL - Remote Connections - In what format are credentials sent across the internet

Situation I have 3 MySQL servers on 3 machines. Sometimes they have to interact with each other which requires a remote connection from one machine to the other, usually via a PHP PDO connection. ...
1
vote
1answer
33 views

Multiple increments in table

Let's say I have a table which stores different bills. There are multiple departments using this database and every department needs to use their own incremental numbering for the bills. I do not ...
0
votes
1answer
102 views

PhpMyAdmin Import Error-MySQL server has gone away/Unrecognized Keyword

So I've exported a MySQL database from PHPMyAdmin (which I access from within IIS Express on a Windows 8 machine) and I'm trying to import this database onto another machine, however on that machine I ...
1
vote
1answer
83 views

Challenging MySQL query, compare two records to find if they match or not

I have a large (88K rows) table that holds data in pairs. For a specific entity, there are 2 records, with UID's and then a load of additional data. I need to take each pair (pairs can be found by ...
1
vote
1answer
89 views

How does mysqldbcopy function

I have a database called LIVE and I want to create a scenario were I copy the LIVE database every night at 2:30 am. I want the copied database to be called REPORT. So every night I want the REPORT ...
0
votes
1answer
65 views

MySQL shows previously deleted data

We're running MySQL on Azure. We have three very small databases. The main database is POI and it hold 11 static records. During the day a few records may be added and deleted again within 1-2 hours. ...
0
votes
0answers
38 views

MySQL how do I select consecutive rows on table and back to start at end of table?

I have a little website (actually in dev stage) to manage race standings for a game. I have a table "race" with 19 rows representing 19 grand prix. I have made a page where I show 5 grand prix based ...
1
vote
2answers
83 views

How can I make an automatic copy of a MySQL database to another MySQL database on the same server?

I have two MySQL databases called LIVE and REPORTS on the same server. I want to copy the LIVE database and all its contents into the REPORTS database everyday at a specific time frame between 1 am ...
0
votes
1answer
50 views

Error code 1064 when trying to add anything manually

So i tried adding via php and i noticed i got a error , so i went into phpmyadmin and tried adding it manually by clicking the SQL in phpmyadmin and write in INSERT INTO `test`(`IDtest`, ...
0
votes
1answer
39 views

table design for display content

In my previous work station, I saw them have a table design across all website they have worked on displaying editor content like this: column|page_id| title |content_1|... |content_n| lang ...
0
votes
1answer
47 views

Update database table

I'm developing a website using PHP. I have a MySQL database and it has three columns called name, latitude and longitude. It is as follows. Name | latitude | longitude ---------------------------- ...
0
votes
0answers
66 views

Slow response from mysql and web application

We have a Mysql server and apache running on ubuntu via VMWare. Server has 2 CPU cores and 4GB allocated to it. On the server is a web app via php cake framework. One of our developers noticed we had ...
0
votes
0answers
36 views

SQL Schema - Messed up my schema and want to revert

I was playing around a bit with my database.table schema (keys) and I have now messed it up. This is the original schema: CREATE TABLE IF NOT EXISTS `xeon_stats_clicks` ( `id` int(11) unsigned NOT ...
0
votes
0answers
57 views

MySQL Match … Against query very slow

I work on a website running on Propel ORM and I have this query: if(isset($args["QueryText"]) && $args["QueryText"] != "") { $query = $query ->withColumn("(MATCH (Request.Subject, ...
0
votes
0answers
17 views

Sphinx result set error?

I'm getting below error when using sphinx search, selectmylikesfrom tableindex,tablert; ERROR 1064 (42000): INTERNAL ERROR: the column 'mylikes/mylikes' does not present in result set schema ...
1
vote
1answer
49 views

Entering multiple entries in SQL where the count increases by one

I do apologize for the uninspired title, I'm not sure how best to put it. Another person helped me massively in another question I posted regarding the structuring of data. The solution has left me ...
1
vote
0answers
82 views

PostgreSQL 9.4 - Allow access from PHP

I would like to configure PostgreSQL 9.4 to allow connections from database users with passwords from PHP on both the command line and through Apache on a CentOS 6.6 box. I installed PostgreSQL with ...
0
votes
1answer
214 views

MySQL search comma separated keywords

I have keywords column in my table and there are comma (,) separated values. example: hello, world I have search engine with same codes: $search = $_GET ['search']; $query = $db->prepare("SELECT ...
0
votes
0answers
23 views

How to get data from join only if all the services are available

I have created a service table that contains list of all services available with a vendor. For example suppose my vendor is a salon and it provides services like hair cut, massage, waxing, threading ...
0
votes
0answers
29 views

What is the fastest way to do a REGEXP find and Replace in MySQL database?

I have a table with 700,000 entries and I need to check each entry for 1,000,000 words and then replace the word if found from hello to #~hello~#. Words can occur multiple times in an entry and need ...
0
votes
0answers
12 views

Checking user right

Table's structure: id------username-----password------status 1---------derek--------123---------admin 2----------rob---------321---------worker I finished simple login page and its working. On the ...
0
votes
0answers
57 views

How to selecting data from two queries using union?

I have three tables. I am trying to taking the data with two times interval after then subtracting from first two second for every possible row and getting the ledger report. Solution is given by: ...
0
votes
1answer
61 views

Query distinct then select option then choose and query choosed as html result on page

Structure of database "diary": id------user_name-----day-----month------post 1--------erik-------- 3--------dec-------something 1--------erik---------3--------dec-------12345 ...
0
votes
1answer
54 views

Moving data from one table (a million records in it) data to another table which in remote location? (MySQL)

I want to move data from one table which have more than 2 million records in size into another table which is in a remote machine, and that moving should support Logging Restart Exception handling ...
0
votes
1answer
43 views

Select distinct then calculate a number

Structure of table: user-----headline----day----number 1 -----lotr -----1 ----- 2 1 -----lotr -----1 ----- 2 1 -----cpo -----2 ----- 2 1 -----cpo -----3 ----- 6 2 ...