fetch - w3toppers.com

Can’t send a post request when the ‘Content-Type’ is set to ‘application/json’

It turns out that CORS only allows some specific content types. The only allowed values for the Content-Type header are: application/x-www-form-urlencoded multipart/form-data text/plain Source: https://developer.mozilla.org/en-US/docs/Web/HTTP/Access_control_CORS To set the content type to be ‘application/json’, I had to set a custom content type header in the API. Just removed the last header and added this one: ->header(‘Access-Control-Allow-Headers’, … Read more

Is there a way to fetch associative array grouped by the values of a specified column with PDO?

It’s quite old topic, but I found very easy solution: ->fetchAll(\PDO::FETCH_GROUP|\PDO::FETCH_UNIQUE) First col will be set as key, rest will be set as value. No need to walk over the array or use array_map.

Spring Data JPA And NamedEntityGraphs

We ran into a similar problem and devised several prospective solutions but there doesn’t seem to be an elegant solution for what seems to be a common problem. 1) Prefixes. Data jpa affords several prefixes (find, get, …) for a method name. One possibility is to use different prefixes with different named graphs. This is … Read more

mysql_fetch_array return only one row

That’s because the array represents a single row in the returned result set. You need to execute the mysql_fetch_array() function again to get the next record. Example: while($data = mysql_fetch_array($array)) { //will output all data on each loop. var_dump($data); }

NHibernate QueryOver with Fetch resulting multiple sql queries and db hits

I would say, that this behaviour is what we should expect. Let’s have a scenario, in which we have in the system 2 users and 2 roles User1 – Role1 // has only Role1 User2 – Role1 // now we see that Role2 has more then User1 User2 – Role2 Let’s say, that the first … Read more

Trying to get property of non-object in [duplicate]

Check the manual for mysql_fetch_object(). It returns an object, not an array of objects. I’m guessing you want something like this $results = mysql_query(“SELECT * FROM sidemenu WHERE `menu_id`='”.$menu.”‘ ORDER BY `id` ASC LIMIT 1″, $con); $sidemenus = array(); while ($sidemenu = mysql_fetch_object($results)) { $sidemenus[] = $sidemenu; } Might I suggest you have a look … Read more

PDO::fetchAll vs. PDO::fetch in a loop

Little benchmark with 200k random records. As expected, the fetchAll method is faster but require more memory. Result : fetchAll : 0.35965991020203s, 100249408b fetch : 0.39197015762329s, 440b The benchmark code used : <?php // First benchmark : speed $dbh = new PDO(‘mysql:dbname=testage;dbhost=localhost’, ‘root’, ”); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql=”SELECT * FROM test_table WHERE 1″; $stmt = $dbh->query($sql); … Read more

php pdo: get the columns name of a table

I solve the problem the following way (MySQL only) $q = $dbh->prepare(“DESCRIBE tablename”); $q->execute(); $table_fields = $q->fetchAll(PDO::FETCH_COLUMN);

What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate

In this two queries, you are using JOIN to query all employees that have at least one department associated. But, the difference is: in the first query you are returning only the Employes for the Hibernate. In the second query, you are returning the Employes and all Departments associated. So, if you use the second … Read more