Professional Hypertext Preprocessor, a widely used platform for dynamic web applications.
0
votes
0answers
23 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
1answer
28 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
13 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 | ...
0
votes
1answer
33 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
0answers
25 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
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
30 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
0answers
28 views
PHP MySQL: Taking Long time to Insert Record in Table when using Mozilla Browser [closed]
Scenario : I am trying to Execute Page which has code to Insert a Record in My SQL Table.
Issue : When I am calling this Page from IE/Safari it works well but when I do the same from Mozilla/Chrome ...
0
votes
1answer
33 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
1answer
23 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
61 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 ...
0
votes
2answers
36 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
35 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 ...
3
votes
1answer
69 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
0answers
17 views
Insert XML remote data into MYSQL [migrated]
I have this code i am using to insert data into a mysql database.
<?php
$xmlDoc = new DOMDocument();
$xmlDoc->load(".....url");
$mysql_hostname = "localhost";
$mysql_user = "root";
...
0
votes
0answers
53 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 ...
1
vote
0answers
44 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
44 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
22 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 ...
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
73 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 ...
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
0answers
16 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 ...
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
25 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 ...
0
votes
1answer
39 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
22 views
Upgrading MySql 5.1 to MySql 5.5
I followed a tutorial to update My MySql 5.1 to 5.5 (actually i wanted to upgrade to 5.6, but the tutorial mentioned that i should upgrade to 5.5 first and then to 5.6).
However, after removing ...
1
vote
1answer
48 views
Concurrency Issues when multiple users uses Portal (MySQL and PHP)
We have set up a portal using Yii Framework in Apache, PHP and MySQL. In the portal, there is a feature to export the data in dbf format, the extract takes around 7 minutes, but in those 7 minutes no ...
1
vote
2answers
38 views
Keywords - column or separate table
I am building a website on MySQL with php, and I have 400+ products in a table. I have three columns with comma separated values, each has 1-3 values separated by commas in each row.
I was wondering ...
1
vote
1answer
609 views
Aborted connection (Got an error reading communication packets) MySQL on Amazon RDS
I'm getting the following warning in MySQL:
Aborted connection (Got an error reading communication packets)
I'm using Amazon RDS for MySQL hosting. Both MyISAM and InnoDB storage engines are ...
2
votes
1answer
39 views
Peer review database design for various reports
I'm currently trying to redesign a poorly thought out database for a peer review system that we use internally at my workplace. Employees can log on and submit a review about another employee who ...
0
votes
1answer
66 views
desing the database for survey app with various types of answers
I have to create a survey app for which answers should be stored in the database. I created an html form containing some questions (about 30) with various types of answers (check boxes, radio buttons, ...
0
votes
2answers
50 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`, ...
1
vote
3answers
71 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
Database design and Technology [closed]
Can someone point me in the right direction for this scenario as I am designing a website:
Its a portal where people can save customer details in the cloud. Now i want my main website to allow them ...
0
votes
0answers
151 views
how to append or update JSON datatype value in postgreSQL
hey guys i'm using PHP's codeigniter to create my application and postgreSQL as database and i have to update some value in database.
So, let's say we have table structure like this:-
CREATE TABLE ...
0
votes
0answers
21 views
Intermittent Connection Speeds SQL Server 2008
We are having issues with a PHP-based application connecting to an SQL Server database on a separate server. It uses a single PHP page to establish the connection using mssql_connect, and this page ...
-1
votes
4answers
705 views
Host is not allowed to connect to MySQL
I have already uploaded some files in the free web host I chose and created a database there using phpMyAdmin v2.11.4
Also, I have Googled first this question before posting this here but I don't ...
1
vote
0answers
35 views
Host is not allowed to connect to MySQL [duplicate]
First of all I'm acknowledging you that I am a completely newbie in this field. The field I'm referring to is the summation of these things:
Accessing files on different computers or over the ...
0
votes
0answers
55 views
Connection occasionally fails connecting to MySQL on Amazon RDS from PHP
We're moving MySQL databases from our own EC2 instance, to a multi-zone RDS instance. These are accessed from a load balanced lighttpd + PHP cluster.
We've noticed that quite often, in the morning, ...
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
0answers
111 views
Mysql Insert taking too long. Table need optimzation
I have around 60 tables and a video table with over 600,000 rows. with 4 Btree and 2 FULLText Indexes and have around 30 Columns.
Server Specs are high, over 30G of Ram, Intel Xeon Processor.
Mysql ...
-2
votes
0answers
46 views
Can this architecture supports 350 concurrent access? [closed]
This question is more about server capacity issue.
I have a linux server with Apache 2.24 installed (12G Ram, 32 cores CPU, Red Hat 64Bit).
Install 11 instances of Wordpress, all 3.8.1, with WP ...
0
votes
1answer
78 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
0answers
111 views
How to use Select query just right after Insert on master in a query.?
I have a question on mysql replication. As usual, I deployed my db structure like the Update on master db, the select on slave.
My questions. If I use SELECT query just right after INSERT in a query, ...
-1
votes
1answer
106 views
Insert a file into PostgreSQL BYTEA field using PHP
The previous answers have been horribly complex for the scope of this project.
I want to take the $_POST result as a variable and insert it into a BYTEA field of a table.
$_SESSION['username'] = ...
1
vote
1answer
23 views
Duplicate Data from two column
i have a table which has only two column one is pid(Photo ID) and another one is tid(Tag ID)
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
...
