Professional Hypertext Preprocessor, a widely used platform for dynamic web applications.
0
votes
0answers
24 views
Trouble with PDO query + LEFT JOIN
I'm having trouble with a specific query (PDO style) that selects 4 fields from a table with a simple condition : contact_type='a' , label_id = a value (number) and also it checks that the particular ...
2
votes
1answer
65 views
shopping cart database schema
I need help creating the schema for a database to hold information relative to a web user's shopping cart/session. Each session will have a session ID, a time stamp holding time of creation, an expiry ...
1
vote
0answers
40 views
Searching through lots of applications
Google search has instant search feature. While you are typing, it finds the pages. Apple.com search box. StackExchange ask question part finds similar questions while you are typing question title.
...
0
votes
1answer
31 views
Is Index Used for This Query
If so, which one?
How do we know?
I have 3 indexes in a query. Actually only the first 2 should be useful
{
"v": NumberInt(1),
"key": {
"LongitudeLatitude": "2d",
"Prominent"▼: ...
0
votes
0answers
68 views
database creation using codeigniter database dbforge class gives “Access denied for user 'username'@'localhost' to database 'database_name' ”
Using codeigniter database dbforge class I have created a database and loaded that database as the current database and created tables in localhost WAMP server. But when I uploaded it to the server I ...
2
votes
1answer
51 views
Mongo connection failing with 'Transport endpoint is not connected'
I have a 2 server installation.
A web server with Apache and a DB server with MongoDB.
I am load testing it, and on ~300 RPS I am getting this error:
PHP Fatal error: Uncaught exception ...
3
votes
3answers
92 views
Database design for changing number of fields
Google Contacts lets you to enter more than one phone number, or email address for a contact. You can add as many as you want. I don't know if there is a limit, other than practical list size. To ...
0
votes
0answers
25 views
MySQL database design help
EDIT: also posted on stackoverflow: http://stackoverflow.com/questions/12148715/mysql-database-design-check-in-system
I am attempting to build a check-in system for an office building.
What happens ...
0
votes
1answer
102 views
WorkAround for PHP PDO(with libpq V 9.1.4) binding for use of CITEXT?
The scenario
Two systems(not server) running PHP and PostgreSQL with the following versions
Fedora 15:
PHP
PHP 5.3.13 (cli) (built: May 9 2012 14:38:35)
Copyright (c) 1997-2012 The ...
1
vote
1answer
56 views
MySQL table locks solution -> InnoDb / Partitions
I'm experiencing many table locks in a MyISAM MySQL table that is pretty big (Constx10xGB and 15M rows).
It's mainly caused due many heavy inserts. My current thoughts to optimize:
Changing to ...
2
votes
2answers
69 views
SQL SELECT Kill FROM problem
$sql = "SELECT Kill FROM tbl_pvporderview";
Problem is that il lend up with : Incorrect syntax near the keyword 'Kill'.
Cuz kill is a TSQL command... any way to bypass it?
I cant change the column ...
0
votes
0answers
55 views
Sqlsrv sqlsrv_num_rows FALSE, adding cursor type times out
$sql = "SELECT * FROM lastdeath";
$result = sqlsrv_query( $con, $sql);
if( $result === false )
{
die( print_r( sqlsrv_errors(), true));
}
$row_count = sqlsrv_num_rows($result);
echo $row_count;
...
2
votes
1answer
96 views
Mongodb - Returning the points nearest to a location, with distance
What is the mongodb's equivalent to this query:
SELECT 111151.29341326*SQRT(pow(-6.186753-Latitude,2)+pow(106.772835-Longitude,2)*cos(-6.186753*0.017453292519943)*cos(Latitude*0.017453292519943)) as ...
3
votes
2answers
94 views
Which graph database for search engine and gis?
I just learned there are "graph databases" out there, which are more suited for two applications "search engine" and especially "gis".
To avoid discussions weather a relational DB is better suited ...
1
vote
0answers
64 views
MySQL GROUP BY and ORDER BY giving inconsistent results
I'm currently working with WordPress, and I've added a new meta value which is a number between 0 and 30. Zero is ignored and up to 30 need to be organised in order and only the latest (based on the ...
