2
votes
0answers
36 views
PHP / MongoDB Count strings in an array using aggregations
Ive used MySQL since I was a young boy and now I have to switch to MongoDB for various reasons.
I write a log which saves every php error in a MongoDB collection. Reading out the errors is not the ...
2
votes
0answers
75 views
Multiple ids with one form
I don't really know how to explain what I want but I'll try. I know my code is horrid and a big mess, I'm just really bad :/ any help would be appreciated.
I'm making a shop for my game, and have a ...
1
vote
0answers
41 views
Arbitrary user-defined constraints on database results
In a survey framework, where user input (ie "asking" survey questions, not answering them) is fairly trusted, my predecessor went with building a MySQL query pretty much straight from user-defined ...
1
vote
0answers
84 views
MySQL - Friends Leaderboard ranking by wins and include player in ranking
Platform: MySQL/PHP
Scenario: Create Friend Leaderboard which includes all friends of a player and also include the player in the leaderboard within a single query.
Details: I'm trying to create a ...
1
vote
0answers
140 views
Magento 1.7 sorting by ordered quantity - bestseller products issues
There are several cases reported where the standard solution(s) for this query do not work (similar questions on SO are abunding,with no definitive solution whatsoever).
What one would do to retrieve ...
1
vote
0answers
115 views
Jquery.Ajax POST update query
I'm searching for a way to update my Database without having to post the whole page.
I'm trying to keep this as simple as possible.
I'm building a table with with some information in the database in ...
1
vote
0answers
66 views
Querying a Clarizen Project/Task in PHP
I'm currently trying to get a list of all Clarizen active projects so that I can modify some properties of its tasks. I've read the Clarizen API but it doesn't have many informations on PHP queries. ...
1
vote
0answers
108 views
returning an array to echo from sql query
the second echo, for user_name, prints correctly, but the first will only print array and give 'array to string error'.
my query should return an array of about 6 names. Is there something im missing ...
1
vote
0answers
221 views
MongoDB aggregation does not work (or is very slow) with PHP and works perfectly in shell?
I'm trying to use the aggregate method on my collection (containing more than 20M documents).
I first tried it in the Windows shell :
db.data.aggregate([
{$match: {firstname: "Roger"}},
...
1
vote
0answers
141 views
Read Raw Contents of File in Private Repo on Github via access_token
I am trying to retrieve the raw contents of the README.rm file of a private repository on Github.
I'm extremely close, the only issue currently, is that I'm getting back a 401 unauthorized result.
...
1
vote
0answers
97 views
Slow postgresql queries in Zend
I am using Zend 1.12 with postgresql database.
I am also using Zend_Db_Table_Abstract interface for accessing my database.
My code (simplified):
class Application_Model_DbTable_Images extends ...
1
vote
0answers
178 views
Salesforce Soap API, query not returning the value for boolean fields
I have a salesforce query that works without an error. I can use all the data except the boolean fields. I would like to display different information depending on the value (True or False) of the ...
1
vote
0answers
47 views
How to add a second query as a condition?
Please see my query below. Right now its look for system_id from contacts where system_id = '$sid' but i want the query to ALSO look for friend_id from contacts where system_id = '$sid'
$tre = ...
1
vote
0answers
118 views
How to delete all joined entities in the single DQL
I have such a dql statement:
DELETE i, p, d, d2, s
FROM OverseerMainBundle:Image i
JOIN i.plates p
JOIN i.doc d
JOIN p.doc d2
LEFT JOIN p.symbols s
WHERE d.tag LIKE :tag
If ...
1
vote
0answers
159 views
query structure
So, I'm currently doing a small attendance system.
I have a problem structuring the necessary code to work with what I need.
So, to make things short, I have a page named TAKE ATTENDANCE in which ...
