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

learn more… | top users | synonyms

0
votes
1answer
27 views

Planning on building a big web service. What kind of developers do I need? [on hold]

I'm a designer. I'm looking for web/mobile developers to help me build a similar platform like Airbnb or Yelp, but I don't know a lot about backend or on what technologies these two sites are built ...
0
votes
1answer
39 views

1 million strings and exact match search

I need to chose the best solution (software and algorithm) to solve my problem. I need to store up to million strings and data associated with them. Strings are search queries and data is cached ...
-1
votes
0answers
30 views

Split in and out for attendance machine system

I am using PHP and MySQL to create an attendance system. I have this table: +----+----+------------+-------+-------+-------+-------+-------+--------+ | id | pd | date | in1 | out1 | in2 | ...
0
votes
2answers
67 views

MySQL - prevent OS cache for query

On high load production server I have many sql selects which are unique or re-use will be in hours. I use SQL_NO_CACHE but this queries are still cached with OS cache. Server have 64G ram and used ram ...
0
votes
2answers
135 views

MYSQL Master-Slave replication not working with PHP

My data gets replicated from the master database when I do it manually but when it gets inserted from PHP into the master database it doesn't get replicated to the slave database. My Master database ...
0
votes
1answer
10 views

PHP/MongoDB: Unset all fields in a document

I want to use PHP to remove documents from a MongoDB collection, but it's a capped collection (and it's stuck that way until I can get more memory), which means I can't remove documents. I have to do ...
0
votes
0answers
26 views

Previously inserted rows disappear at call of PHP script

I am developing a server-side portion of a sport manager application using MySQL (5.1.67), with InnoDB as storage engine, and PHP (5.3.3). When I try to execute a script containing any kind of query ...
0
votes
3answers
984 views

Deleting Data From Multiple Tables

Suppose,I've a table called UNIVERSITY containing universities name: universityID universityNAME isACTIVE 7 GNDU 1 6 PU 1 5 ...
1
vote
1answer
55 views

Reviewing relational database tables

I am building a database, but I am a little bit confused with my table relationships. I wish someone could help review my table relationships below for me and tell me where I am going wrong. I have ...
0
votes
1answer
32 views

Quickly etablishing if a remote MySQL connection is valid using PHP

I have a hosted website (Namecheap Pro shared hosting) that connects to a remote MySQL database using a read-only user privilege. This remote DB is updated by a separate system. The website works ...
0
votes
1answer
162 views

I need advice on these queries

could you help me optimize these queries? here are queries, please note that you see something like OR 1=1 OR those are values I pass via php and may change. query#1: SELECT posts.status, ...
0
votes
1answer
101 views

Automobile database logic

I am building a web based quoting system for a local automobile dealership. I think I have figured out the logic for the databases but I want to get a second opinion before I start just to make sure ...
0
votes
1answer
15 views

How does a tagging article database look like?

I have a article website and each article has some tags. How should be my database structure? This is my article table (article): article_id (key) | article_content | article_title | ...
1
vote
2answers
109 views

MYSQL joining 3 tables with left join

I have these tables: pupils: (id_pupil, name, surname, email, user, pass, level, class) incidents: (id_incidents, date, time, type_incident, comments, id_pupil, id_user, subject, id_trimester) ...
0
votes
1answer
35 views

Searching through ~1M slow

I've never had a database with this many rows, so I can new to keeping the search time to a minimum. I have a database table with 1.5M rows. The primary key is an auto-increment id. Then there is ...
0
votes
2answers
70 views

JOIN on variable number of columns

I have the two tables courses AND something_about_courses: courses course_code course_session course_type something_about_courses course_code course_session some_description To ensure that I ...
0
votes
2answers
171 views

database structure - complicated requirements

I have a project to build a website but it's complicated and I'm having trouble figuring out what the best way to build the database would be to handle these particular requirements. The site is for ...
0
votes
0answers
27 views

Should I separate my preferences table?

I have a hobby site where users can find other hobbyists of similar interest. Each user can set a series of preferences that get saved into user_prefs. Right now there are 4 types of preferences, an ...
0
votes
1answer
35 views

How to query group for increase or decrease in value

In MySQl I have a table positions and I would like to find out if position of certain app for certain feed in a certain country type has been increasing/decreasing and by how much from the last ...
0
votes
1answer
17 views

Can I Create a Database and Tables in One SQL Command From PHP? [closed]

I tried separating the CREATE DATABASE and CREATE TABLES commands into different mysqli_query statements. The Database gets created but I get an error with: $create_tables = "CREATE TABLE ...
0
votes
1answer
44 views

Duplicate Entry Error with PHP When Trying UPDATE

I am checking if a record exists, creating a new record if it does not already exist, and updating otherwise. The SQL works fine in PHPMyAdmin but not through the PHP page. $check_for_id = ...
0
votes
2answers
51 views

JOIN on three tables is not working

I have these three tables, user, categories and files In users, table I have a column user_id And I have this query that shows all Categories. SELECT `categories`.`category_id`, ...
0
votes
1answer
24 views

MySQL/PHP Returning Blank Error Message [closed]

I am using the following code to delete a record. It works fine, but MySQL always returns a blank error message. PHP returns "Error: " instead of "1 Record Dropped". $eventid = ...
0
votes
0answers
21 views

Creating a registration page with PHP and PDO [migrated]

I need to create a registration page using PHP and PDO, and encrypt the password before storing it on the database table using md5 (adding 2 salts to the password). How can I write the script for ...
0
votes
1answer
83 views

Update table from calculated temporary table

I have two tables, one containing a set of user ID's, vote direction (-1 or 1) and ID of the object they voted on (casted votes table). In the other table, the object id, upvotes, downvotes and ...
0
votes
1answer
66 views

Inserting data into multiple tables

For my system, students are required to create a user account by completing a registration form (personal, contact and course details; also username and password). I need to collect registration data ...
1
vote
1answer
306 views

Calculating the median value in a MySQL table with CodeIgniter

This is my model file in codeigniter. I need to calculate the median for this variable: budget_breakdown.breakdown_grants. How can I do this calculation? function reports_details1() { ...
0
votes
2answers
38 views

Using a join to return multiple values of the same column?

I have two tables user Rank In the Rank table, I saved rank_id and supervisor_id. In the Rank table, I stored the rank name. The rank_id and supervisor_id are foreign keys from the Rank table. ...
0
votes
1answer
46 views

configure client ibm_db2 for php

I am installing a RHEL server with nginx and php that can connect to a db2 database, download and install the "IBM Data Server Client" package, also install the pecl library through: pecl install ...
0
votes
1answer
40 views

Implementing Permissions Database structure on a PHP site to restrict the Access in Multiple levels

I am working on a PHP site that shows the business of a Vehicle Showroom company in which we have 3 users as, Admin(Owner) = Here Admin Have all Access by default(View,Edit,Delete to all) Super ...
0
votes
0answers
411 views

MySQL is running but not working [closed]

In an attempt to tune MySQL to make it work with a recent installation of Drupal I had to modify the MySQL settings on my server. After modifying the configuration file for MySQL (/etc/my.cnf) MySQL ...
3
votes
1answer
72 views

Percona MySQL 5.5 Unique key is duplicated

I'm totally out from ideas, so maybe somebody else could answer my question. We have a MySQL 5.5 server from Percona with high traffic. The application is in PHP and writes always to master. We have ...
0
votes
1answer
721 views

MySQL PDO Cannot assign requested address

Can someone help me with this error? [08-Apr-2013 17:44:08 Europe/Berlin] PHP Warning: PDO::__construct(): [2002] Cannot assign requested address (trying to connect via tcp://****:3306) in ...
0
votes
0answers
67 views

Having trouble configuring phpPgAdmin with PostgreSQL 9.3 on CentOS 6

Trying to hook up phpPgAdmin on my virtual box and having some issues with pg_hba.conf. I added the IP I SSH through, connecting through a VPN, in IPv4 and changed all the methods to md5. I then go to ...
0
votes
2answers
4k views

Insert data in current table and update another table MySQL

I'm having problem with inserting in purchase table and updating facility table. Let's say, user made a purchase with product_id and product_quantity. When user hit submit, I want to insert ...
2
votes
2answers
164 views

Repeated values in group_concat

I have two tables, first the table food and Second is Activity: INSERT INTO food (`id`, `foodName`) VALUES (1, 'food1'), (2, 'food2'), (3, 'food3'), (4, 'food4'), (5, ...
1
vote
0answers
46 views

Question on MySQL insert race condition

I'm using MySQL 5.1, PHP 5.3 and the table is MyISAM. Here's the DTD of this very fake table: CREATE TABLE `temp1` ( `value` varchar(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 This ...
-2
votes
1answer
48 views

Can I install MySql and Oracle 10g both Databases in same machine? [closed]

I have MySql Installed in my windows 7 machine and PHP on IIS. Now i need Oracle 10g anyway.I'm having king of dilemma to install Oracle 10g. If i can do so please suggest necessary steps and ...
0
votes
0answers
34 views

Optimization mysql very slowly [duplicate]

Hello I have a server in kimsufi 2gb RAM and 500gb storage but the query with php mysql is very slowly I have change innodb buffer pool size to 500M but i have error too many connections, i add max ...
0
votes
0answers
23 views

Multiple client tables or large overall table

I've recently taken over a project linking to a large MySQL DB that was originally designed many years ago and need some help. Currently the DB has 5 tables per client that store their users ...
-1
votes
1answer
34 views

Server down after PDO connection

I don't know is this off-topic for this site but I have site that run on PHP and MySQL. And I want to change my MySQL connection to PDO. This is my connection file that I include in every file at the ...
0
votes
1answer
33 views

How to install TokuDB on MAMP

I'm by no means a DB admin. Just a hobbyist actually, and more of a programmer than a database person. I have MAMP 3.05, PHP 5.5.10, Mac OSX 10.9.3. I have a big suite of PHP applications and a ...
0
votes
0answers
21 views

Garbage DB Objects Cleansing

How do I find in use db objects from all application pages is there any tool or trick I can use, just like we do search in Visual studio for an object in entire solution
1
vote
2answers
83 views

Checking if an Username is already in use

I am writing some scripts for my website, and I am currently focussing on checking if a username is already in use. I have tried writing a SELECT script where the datafield is selected and checks if ...
0
votes
0answers
17 views

Checking for records in lookup table before deleting

In my MySQL database, I have products table, a locations table and a lookup table (called location_products) where the ID of the product and ID of the location are stored. I am creating a transaction ...
1
vote
3answers
74 views

Mysql to Oracle communication

I have a website running with php and mysql on Centos(Amazon instance). The newly brought ERP(to be integrated with existing system) uses Oracle as db(located on a separate Windows Server). The orders ...
0
votes
0answers
16 views

Generate report from visitor counter

I have a visitor counter, the table looks like this: id | country_code | datetime | Browser | ... --------------------------------------------------------- 1 | FR | ...
0
votes
0answers
33 views

Low performance oci_execute

I work with a PHP application that connects to an Oracle database. Sometimes, the PHP executes a large query from a large database the page loads for ages (more than 200s). But I've seen something ...
1
vote
2answers
103 views

Disk write in iotop when doing mysql “Copy to tmp table”

I have just moved servers from a two-server configuration with the application and database server running separately to a one-server LAMP stack. Unfortunately the issue that I have encountered on ...
1
vote
2answers
378 views

multiple connections on MySQL database with no users on httpd

My database seems to have many open connections despite having no users on httpd. mysql> SHOW PROCESSLIST; ...