Head to `File &gt; Settings &gt; Languages &amp; Frameworks &gt; SQL Dialects` and set it for the whole project.

This is a screenshot of how to do that inside the settings: 
[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/CCDdY.png

This is on version 2016.3

We&#39;ve got an Xcode project with build configurations for the Apple Watch as well. Our Apple Watch app isn&#39;t ready yet, so we&#39;d like to release with it disabled. What&#39;s the best way to disable Apple Watch functionality in a build?

Prevent deploying (disable) WatchKit App with iOS iPhone App in Xcode

This is weird.  This is what happens at the JavaScript console in Chrome (version 42.0.2311.135, 64-bit).

&lt;!-- language: lang-none --&gt;

    &gt; 0
    &lt; 0
    &gt; 00
    &lt; 0
    &gt; 0.0
    &lt; 0
    &gt; 00.0
    X Uncaught &gt; SyntaxError: Unexpected number

Firefox 37.0.2 does the same, although its error message is:

&lt;!-- language: lang-none --&gt;

    SyntaxError: missing ; before statement

There&#39;s probably some technical explanation regarding the way JavaScript parses numbers, and perhaps it can only happen when tinkering at the console prompt, but it still seems wrong.

Why does it do that?


Why does 00.0 cause a syntax error?

I am working on Google oauthorization2 and I encounter problem that 
&gt;SQL dialect is not configured 

That&#39;s why my query is not executing and data is going to table.

I have listed below both of queries where I encounter problem.

Tools:
PhpStorm 8+
MySQL
Localhost 


    $user_exist = $mysqli-&gt;query(&quot;SELECT COUNT(google_id) as usercount FROM google_users WHERE google_id=$user_id&quot;)-&gt;fetch_object()-&gt;usercount;
    
    $mysqli-&gt;query(&quot;INSERT INTO google_users (google_id, google_name, google_email, google_link, google_picture_link)
    		VALUES ($user_id, &#39;$user_name&#39;,&#39;$email&#39;,&#39;$profile_url&#39;,&#39;$profile_image_url&#39;)&quot;);



SQL Dialect is Not Configured (Phpstorm)

I am working on Google oauthorization2 and I encounter problem that
>SQL dialect is not configured
That's why my query is not executing and data is going to table.
I have listed below both of queries where I encounter problem.
Tools:
PhpStorm 8+
MySQL
Localhost
<pre><code class="hljs language-bash">$user_exist = $mysqli->query("SELECT COUNT(google_id) as usercount FROM google_users WHERE google_id=$user_id")->fetch_object()->usercount;

$mysqli->query("INSERT INTO google_users (google_id, google_name, google_email, google_link, google_picture_link)
		VALUES ($user_id, '$user_name','$email','$profile_url','$profile_image_url')");
</code></pre>

I get my bearer token from an API end point and set the following:

    $authorization = &quot;Bearer 080042cad6356ad5dc0a720c18b53b8e53d4c274&quot;

Next I want to use CURL to access the secure endpoint however I am unsure on how or where to set the Bearer token.

I have tried this but but it does not work:

     curl_setopt($ch, CURLOPT_HTTPHEADER, array(&#39;Content-Type: application/json&#39; , $authorization ));
        curl_setopt($ch, CURLOPT_CUSTOMREQUEST, &quot;POST&quot;);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_POSTFIELDS,$post);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
        $result = curl_exec($ch);
        curl_close($ch);
        return json_decode($result);

EDIT:

According to the documentation, I am supposed to be using the bearer token as such: https://apigility.org/documentation/auth/authentication-oauth2

    GET /oauth/resource HTTP/1.1
    Accept: application/json
    Authorization: Bearer 907c762e069589c2cd2a229cdae7b8778caa9f07



Correct way to set Bearer token with CURL

I am trying to create mysql tables in Laravel 5. I created a file in `/project/database/migrations` called `users.php`:

    [...]
    public function up()
    {
    	Schema::create(&#39;users&#39;, function(Blueprint $table)
    	{
    		$table-&gt;increments(&#39;id&#39;);
    		$table-&gt;string(&#39;username&#39;);
    		$table-&gt;string(&#39;fullname&#39;);
    		$table-&gt;int(&#39;number&#39;);
    		$table-&gt;string(&#39;email&#39;)-&gt;unique();
    		$table-&gt;string(&#39;password&#39;, 60);
    		$table-&gt;rememberToken();
    		$table-&gt;timestamps();
    	});
    }
    [...]

I then tried running these commands in the `project`-folder:

    $ php artisan migrate
    $ php artisan migrate:install
    $ php artisan migrate --pretend

None of them return *any* output and no tables are created. The database to be populated exists.

Artisan, creating tables in database

I&#39;m trying to add users to a list I&#39;ve created in Mailchimp but I can&#39;t find any code examples anywhere. I&#39;ve tried figuring out how to use the API but I&#39;m very much a &quot;Look at an example and learn&quot; kind of person.

I&#39;ve tried using version 2 of the API but nothing seems to be working despite working from examples on the net and Mailchimp says the following about earlier versions of their API on their website:

&gt; Versions 2.0 and earlier are deprecated. Only minimal support—bug fixes, security patches—will be available for those versions.

**UPDATE 1**: I did some further research based on TooMuchPete&#39;s [answer][1] with regards to the link on Managing Subscribers and altered some code I found [here][2], but it won&#39;t work because the function [http_build_query()][3] doesn&#39;t deal with nested arrays. I&#39;m not sure how to deal with the &#39;merge_fields&#39; portion of adding a subscriber. My current code is below:

    $postdata = http_build_query(
						array(
							&#39;apikey&#39; 		=&gt; $apikey,
							&#39;email_address&#39; =&gt; $email,
							&#39;status&#39; 		=&gt; &#39;subscribed&#39;,
							&#39;merge_fields&#39; 	=&gt; array(
								&#39;FNAME&#39; =&gt; $name
							)
						)
					);
					
					$opts = array(&#39;http&#39; =&gt;
						array(
							&#39;method&#39;  =&gt; &#39;POST&#39;,
							&#39;header&#39;  =&gt; &#39;Content-type: application/x-www-form-urlencoded&#39;,
							&#39;content&#39; =&gt; $postdata
						)
					);
					
					$context  = stream_context_create($opts);
					
					$result = file_get_contents(&#39;https://us2.api.mailchimp.com/3.0/lists/&lt;list_id&gt;/members/&#39;, false, $context);
					
					var_dump($result);
					die(&#39;Mailchimp executed&#39;);

**UPDATE 2**: I&#39;ve now resorted to using curl and I&#39;ve managed to get something almost working. The data sends through to Mailchimp but I&#39;m receiving the error ***&quot;Your request did not include an API key.&quot;*** I&#39;m guessing I need to authenticate as mentioned [here][4]. I&#39;ve tried adding it to the http header which hasn&#39;t worked. See my code below:

    $apikey = &#39;&lt;api_key&gt;&#39;;
					$auth = base64_encode( &#39;user:&#39;.$apikey );
					
					$data = array(
						&#39;apikey&#39; 		=&gt; $apikey,
						&#39;email_address&#39; =&gt; $email,
						&#39;status&#39; 		=&gt; &#39;subscribed&#39;,
						&#39;merge_fields&#39; 	=&gt; array(
							&#39;FNAME&#39; =&gt; $name
						)
					);
					$json_data = json_encode($data);
					
					$ch = curl_init();
					curl_setopt($ch, CURLOPT_URL, &#39;https://us2.api.mailchimp.com/3.0/lists/&lt;list_id&gt;/members/&#39;);
					curl_setopt($ch, CURLOPT_HTTPHEADER, array(&#39;Content-Type: application/json/r/n
																Authorization: Basic &#39;.$auth));
					curl_setopt($ch, CURLOPT_USERAGENT, &#39;PHP-MCAPI/2.0&#39;);
					curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
					curl_setopt($ch, CURLOPT_TIMEOUT, 10);
					curl_setopt($ch, CURLOPT_POST, true);
					curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
					curl_setopt($ch, CURLOPT_POSTFIELDS, $json_data);                                                                                                                  
					
					$result = curl_exec($ch);
					
					var_dump($result);
					die(&#39;Mailchimp executed&#39;);


  [1]: https://stackoverflow.com/a/30492435/2443113
  [2]: https://stackoverflow.com/a/2445332/2443113
  [3]: https://php.net/http_build_query
  [4]: http://kb.mailchimp.com/api/article/api-3-overview

Adding subscribers to a list using Mailchimp&#39;s API v3

I have searched on the web for over two days now, and probably have looked through most of the online documented scenarios and workarounds, but nothing worked for me so far.

I am on **AWS SDK** for PHP V2.8.7 running on PHP 5.3.

I am trying to connect to my Amazon S3 bucket with the following code:

```php
// Create a `Aws` object using a configuration file
$aws = Aws::factory(&#39;config.php&#39;);

// Get the client from the service locator by namespace
$s3Client = $aws-&gt;get(&#39;s3&#39;);

$bucket = &quot;xxx&quot;;
$keyname = &quot;xxx&quot;;

try {
    $result = $s3Client-&gt;putObject(array(
        &#39;Bucket&#39; =&gt; $bucket,
        &#39;Key&#39; =&gt; $keyname,
        &#39;Body&#39; =&gt; &#39;Hello World!&#39;
    ));

    $file_error = false;
} catch (Exception $e) {
    $file_error = true;

    echo $e-&gt;getMessage();

    die();
}
```
			

My config.php file is as follows:

```php
return [
    // Bootstrap the configuration file with AWS specific features
    &#39;includes&#39; =&gt; [&#39;_aws&#39;],
    &#39;services&#39; =&gt; [
        // All AWS clients extend from &#39;default_settings&#39;. Here we are
        // overriding &#39;default_settings&#39; with our default credentials and
        // providing a default region setting.
        &#39;default_settings&#39; =&gt; [
            &#39;params&#39; =&gt; [
                &#39;credentials&#39; =&gt; [
                    &#39;key&#39;    =&gt; &#39;key&#39;,
                    &#39;secret&#39; =&gt; &#39;secret&#39;
                ]
            ]
        ]
    ]
];
```

It is producing the following error:

&gt; The request signature we calculated does not match the signature you provided. Check your key and signing method.

I&#39;ve already checked my access key and secret at least 20 times, generated new ones, used different methods to pass in the information (i.e. profile and including credentials in code) but nothing is working at the moment.

Amazon S3 - How to fix &#39;The request signature we calculated does not match the signature&#39; error?

I have a questions table and a tags table. I want to fetch all questions from tags of a given question. So, for example, I may have the tags &quot;Travel,&quot; &quot;Trains&quot; and &quot;Culture&quot; attached to a given question. I want to be able to fetch all questions for those three tags. The tricky, so it seems, is that questions and tags relationship is a many-to-many defined in Eloquent as belongsToMany.

I thought about trying to merge the questions Collections as below:

    foreach ($question-&gt;tags as $tag) {
        if (!isset($related)) {
            $related = $tag-&gt;questions;
        } else {
            $related-&gt;merge($tag-&gt;questions);
        }
    }

It doesn&#39;t seem to work though. Doesn&#39;t seem to merge anything. Am I attempting this correctly? Also, is there perhaps a better way to fetch a row of rows in a many-to-many relationship in Eloquent?

How to Merge Two Eloquent Collections?

I need to provide the mysql connection for modules. I have a code like this.

    var express = require(&#39;express&#39;),
    app = express(),
    server = require(&#39;http&#39;).createServer(app);

    var mysql      = require(&#39;mysql&#39;);
    var connection = mysql.createConnection({
	    host     : &#39;127.0.0.1&#39;,
	    user     : &#39;root&#39;,
    	password : &#39;&#39;,
	    database	: &#39;chat&#39;
    });

    connection.connect(function(err) {
	    if (err) {
	        console.error(&#39;error connecting: &#39; + err.stack);
	        return;
        }
    });

    app.get(&#39;/save&#39;, function(req,res){
    	var post  = {from:&#39;me&#39;, to:&#39;you&#39;, msg:&#39;hi&#39;};
    	var query = connection.query(&#39;INSERT INTO messages SET ?&#39;, post, function(err, result) {
    	    if (err) throw err;
	    });
    });

    server.listen(3000);



 But how we provide one time mysql connection for all the modules.


How to provide a mysql database connection in single file in nodejs

trying to write pandas dataframe to MySQL table using `to_sql`.  Previously been using `flavor=&#39;mysql&#39;`, however it will be depreciated in the future and wanted to start the transition to using SQLAlchemy engine.

sample code:

    import pandas as pd
    import mysql.connector
    from sqlalchemy import create_engine

    engine = create_engine(&#39;mysql+mysqlconnector://[user]:[pass]@[host]:[port]/[schema]&#39;, echo=False)
    cnx = engine.raw_connection()
    data = pd.read_sql(&#39;SELECT * FROM sample_table&#39;, cnx)
    data.to_sql(name=&#39;sample_table2&#39;, con=cnx, if_exists = &#39;append&#39;, index=False)

The read works fine but the `to_sql` has an error:

&gt; DatabaseError: Execution failed on sql &#39;SELECT name FROM sqlite_master
&gt; WHERE type=&#39;table&#39; AND name=?;&#39;: Wrong number of arguments during
&gt; string formatting

Why does it look like it is trying to use sqlite? What is the correct use of a sqlalchemy connection with mysql and specifically mysql.connector?

I also tried passing the engine in as the connection as well, and that gave me an error referencing no cursor object.

    data.to_sql(name=&#39;sample_table2&#39;, con=engine, if_exists = &#39;append&#39;, index=False)
    &gt;&gt;AttributeError: &#39;Engine&#39; object has no attribute &#39;cursor&#39;



Writing to MySQL database with pandas using SQLAlchemy, to_sql

I am working on MySQL 5.5 and trying to do index rebuild using an `OPTIMIZE TABLE` query. I am getting the error below:

&gt; Table does not support optimize, doing recreate + analyze instead

What does this mean? Is MySQL engine not allowing Index Rebuild? What is being done behind this message, at MySQL 5.5 Engine level?

What does &quot;Table does not support optimize, doing recreate + analyze instead&quot; mean?

I am trying to change MySql root password.

What I have done is below.

 1. Install MySql-5.7.6 ~ .dmg(Community Server) and workbench.
 2. Turn off the server on OSX System preferences.
 3. Access MySql with console. The command was `mysqld_safe --skip-grant`
 4. Execute `update user set password=password(&#39;1111&#39;) where user=&#39;root&#39;;` and got an error message --&gt; `ERROR 1054 (42S22): Unknown column &#39;password&#39; in &#39;field list&#39;`.

FYI, I did `use mysql;`.
So I did select query on user table and found password column actually does not exist. 

It is very weird. Is it possible that original user table does not have password column?

How can I change password, which does not exist?

Thanks for your answer :D

MySQL user DB does not have password columns - Installing MySQL on OSX

i was trying to insert some data into the database but i got this error &quot;**Error while sending QUERY packet**&quot;  

    $insertDeta = $conPat-&gt;prepare(&quot;insert into table1(data) VALUES(:data)&quot;);
    $insertDeta-&gt;bindParam(&#39;:data&#39;,$data);
	$conPat-&gt;beginTransaction();	
	    $insertDeta-&gt;execute();
	$conPat-&gt;commit();

but what i think the problem is that size of the **data** is over 16MB.  
the data type of the column is set as **longtext**, which i think can keep data as big as 4GB.  

I dont know if PDOs is having problems running the query or transfering 16MB of data to the database.  
Thats the only guess i can make as mysql might send the data in _packets_ and the packet cannot hold data as large as 16MB.

Error while sending QUERY packet

I have two different machines both using PhpStorm. One has the feature enabled, that I can select a `text` and by pressing &lt;kbd&gt;&#39;&lt;/kbd&gt; it will become `&#39;text&#39;`:

![Example of the working feature][1]

Yet the other one will just erase the text:

![Example of the not working feature][2]

I have forgotten how I set it up. Where can I enable this feature?

  [1]: http://i.stack.imgur.com/SafuL.gif
  [2]: http://i.stack.imgur.com/Je8kp.gif

How to wrap selection in quotes using PhpStorm?

How can I set the font size in the embedded terminal in the JetBrains PhpStorm IDE? The text is too small. Is this possible?

Set terminal font size in PhpStorm?

I have an open project in PhpStorm that I manage using SourceTree.  I was trying to remove some image files from a commit using SourceTree, but accidentally selected a file that should not be deleted.  I haven&#39;t changed anything (in either PhpStorm or SourceTree) since deleting the file.  I tried to do &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Z&lt;/kbd&gt; in SourceTree but nothing happened.  I then checked in PhpStorm Vcs -&gt; local history, but it didn&#39;t show the file.  How can I recover this file?

Recover deleted file from PhpStorm and SourceTree

failed insert data into database, and all query class and Model class&#39;s method not found show in IDE (phpStrom) how can I solve it? 

here is my extended class (Post.php) here show error in latest and where method:


    &lt;?php namespace App;
    
    use Carbon\Carbon;
    use Illuminate\Database\Eloquent\Model;
    
    class Post extends Model {
    
    	protected  $fillable=[
            &#39;title&#39;,
            &#39;description&#39;,
            &#39;location&#39;,
            &#39;contact&#39;,
            &#39;type&#39;,
            &#39;published_at&#39;
        ];
        protected $date=[&#39;published_at&#39;];
        public function setPublishedAtAttribute($date)
        {
            $this-&gt;attributes[&#39;published_at&#39;] = Carbon::createFromFormat(&#39;Y-m-d&#39;, $date);
        }
    
        /**
         * @param $query
         */
        public function scopePublished($query)
        {
            $query-&gt;where(&#39;published_at&#39;, &#39;&lt;=&#39;, Carbon::now());
        }
    
        public function scopeUnPublished($query)
        {
            $query-&gt;where(&#39;published_at&#39;, &#39;&gt;=&#39;, Carbon::now());
        }
    
        /**
         * An post is owned by a user.
         * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
         */
        public function user(){
            return $this-&gt;belongsTo(&#39;App\User&#39;);
        }
    
    } 

and Here is my Controller class where i use it : 



    &lt;?php namespace App\Http\Controllers;
    
    use App\Http\Requests;
    
    use App\Http\Requests\CreatePostRequest;
    use App\Post;
    use Request;
    use Illuminate\Support\Facades\Auth;
    use Session;
    
    class PostsController extends Controller {
    
    	//
        public function __construct()
        {
            $this-&gt;middleware(&#39;auth&#39;);
        }
    
        public function index()
        {
            //return \Auth::user()-&gt;name;
            $posts = Post::latest(&#39;published_at&#39;)-&gt;published()-&gt;get();
            $latest= Post::latest()-&gt;first();
            return view(&#39;tolet.index&#39;, compact(&#39;posts&#39;,&#39;latest&#39;));
    
        }
    
        /**
         * @param Post $post
         * @return \Illuminate\View\View
         * @internal param Articles $article
         * @internal param Articles $articles
         */
        public function show(Post $post)
        {
    
            return view(&#39;tolet.show&#39;, compact(&#39;post&#39;));
        }
    
        public function create()
        {
            if (Auth::guest()) {
                return redirect(&#39;tolet.index&#39;);
            }
            return view(&#39;tolet.create&#39;);
        }
    
        /**
         * @param CreatePostRequest $request
         * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
         */
        public function store(CreatePostRequest $request)
        {
            //validation
    
            $this-&gt;createPost($request);
    
    
           // flash(&#39;Your tolet has been created!&#39;)-&gt;important();
    
            return redirect(&#39;tolet.index&#39;);
        }
    
        /**
         * @param Post $post
         * @return \Illuminate\View\View
         * @internal param Articles $article
         */
        public function edit(Post $post)
        {
            return view(&#39;tolet.edit&#39;, compact(&#39;post&#39;));
        }
    
    
        /**
         * @param Post $post
         * @param CreatePostRequest $request
         * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
         * @internal param Articles $article
         * @internal param $id
         */
        public function update(Post $post, CreatePostRequest $request)
        {
            $post-&gt;update($request-&gt;all());
            return redirect(&#39;tolet.index&#39;);
        }
    
        /**
         * sync up the list of tags in the database
         *
         * @param Post $post
         */
    
    
        /**
         * save a new post
         *
         * @param CreatePostRequest $request
         * @return mixed
         */
        private function createPost(CreatePostRequest $request)
        {
            $post = Auth::user()-&gt;posts()-&gt;create($request-&gt;all());
    
            return $post;
        }
    
    
    }



PHPStorm is not recognizing methods of my Model class in Laravel 5.0

How to make something like this? (all methods collapsed by default without any hotkeys)

[![collapsed methods][1]][1]


  [1]: http://i.stack.imgur.com/FBVrj.jpg

Content Type	Original Author	Original Content on Stackoverflow
Question	RAZA MUSTAFA	View Question on Stackoverflow
Solution 1 - Php	Michael Bolli	View Answer on Stackoverflow
Solution 2 - Php	S.Mason	View Answer on Stackoverflow

SQL Dialect is Not Configured (Phpstorm)

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

Why does 00.0 cause a syntax error?

Prevent deploying (disable) WatchKit App with iOS iPhone App in Xcode

Attributions