Posts Tagged with comma

Displaying 1-10 of 13 results.
Resolved: JetBrains PhpStorm run terminal command line cmd from IDE space
posted by admin on February 6, 2017
I want to run terminal from cmd terminal from JetBrains PhpStorm IDE space from menu, or by keys combination or from project right click.Read more
Resolved: How to cretae(make) .htaccess file in Net Beans
posted by admin on February 6, 2017
I want to create .htaccess file in NetBeans.
I want to relize it by short and easy way.
How to make it?Read more
Resolved: Command Line mkdir p The syntax of the command is incorrect error
posted by admin on February 1, 2017
I try to run command in CMD

mkdir –p config/env/dev

And I got error

The syntax of the command is incorrect

Error in Russian

Ошибка в синтаксисе команды.
Read more
Resolved: Composer composer self-update errors in Windows by XAMPP
posted by admin on February 1, 2017
I try to update composer and got some errors.
When I tried the command

composer self-update

Error

'composer' is not recognized as an internal or external command,
operable program or batch file.

When I tried the command

php composer self-update

Error:

Could not open input file: composer

And finally

composer.phar self-update

Error
Trying to search composer.phar in intsernetRead more
Wiki: Laravel 5.2 install IDE helper for NetBeans (Namespaces, Classes and all libraries)wiki
posted by admin on August 12, 2016
Helper Source laravel-ide-helper GITHUB Official

CMD Terminal
Open CMD terminal
Go to your Laravel project root directory by

cd C:\xampp\htdocs\laravel.dev


Install
Require this package with composer using the following command:

composer require barryvdh/laravel-ide-helper

After updating composer, add the service provider to the providers array in config/app.php

Barryvdh\LaravelIdeHelper\IdeHelperServiceProvider::class,


Automatic phpDoc generation for Laravel Facades
You can now re-generate the docs yourself (for future updates)

php artisan ide-helper:generate

Note: bootstrap/compiled.php has to be cleared first, so run

php artisan clear-compiled

before generating (and

php artisan optimize

after).

You can configure your composer.json to do this after each commit:
You can also publish the config file to change implementations (ie. interface to specific class) or set defaults for --helpers or --sublime.

php artisan vendor: publish --provider="Barryvdh\LaravelIdeHelper\IdeHelperServiceProvider" --tag=config


Restart NetBeans IDERead more
Wiki: Yii 1.1 app db createCommand execution of SQL statement wayswiki
posted by admin on November 7, 2016
Once a database connection is established, SQL statements can be executed using CDbCommand. One creates a CDbCommand instance by calling CDbConnection::createCommand() with the specified SQL statement:

$connection=Yii::app()->db; // assuming you have configured a "db" connection
// If not, you may explicitly create a connection:
// $connection=new CDbConnection($dsn,$username,$password);
$command=$connection->createCommand($sql);
// if needed, the SQL statement may be updated as follows:
// $command->text=$newSQL;

A SQL statement is executed via CDbCommand in one of the following two ways:
  • execute(): performs a non-query SQL statement, such as INSERT, UPDATE and DELETE. If successful, it returns the number of rows that are affected by the execution.
  • query(): performs an SQL statement that returns rows of data, such as SELECT. If successful, it returns a CDbDataReader instance from which one can traverse the resulting rows of data. For convenience, a set of queryXXX() methods are also implemented which directly return the query results.

An exception will be raised if an error occurs during the execution of SQL statements.

$rowCount=$command->execute(); // execute the non-query SQL
$dataReader=$command->query(); // execute a query SQL
$rows=$command->queryAll(); // query and return all rows of result
$row=$command->queryRow(); // query and return the first row of result
$column=$command->queryColumn(); // query and return the first column of result
$value=$command->queryScalar(); // query and return the first field in the first row
//in Russian
$rowCount=$command->execute(); // выполнение запроса типа `INSERT`, `UPDATE` или `DELETE`
$dataReader=$command->query(); // выполнение запроса типа `SELECT`
$rows=$command->queryAll(); // возвращает все строки результата запроса
$row=$command->queryRow(); // возвращает первую строку результата запроса
$column=$command->queryColumn(); // возвращает первый столбец результата запроса
$value=$command->queryScalar(); // возвращает значение первого поля первой строки результата запроса
Read more
Resolved: Laravel Update version to latest version by composer
posted by admin on October 23, 2016
In my project I use Laravel 5.1 and now I want to update by composer to Laravel 5.3 version, it is latest version!
Not manually, by composer or cmd line or artisan command!Read more
Resolved: Composer.phar Warning: This development build of composer is over 30 days old
posted by admin on June 21, 2016
I am facing warning statements in my cmd.

Warning: This development build of composer is over 60 days old.Read more
Resolved: Replace %2C with a comma in javascript?
posted by admin on June 18, 2016
I get string from URL

#&q=car&category=Car%20Audio%2CAccessories&brand=

%2C is comma in url, and I want to recover my string with comma

#&q=car&category=Car%20Audio,Accessories&brand=
Read more
Resolved: Get data from table from a list of strings on MySQL
posted by admin on May 6, 2016
How can I query data from a table available on a list of strings?

I only want to get the data from the list of strings.

Example:
Table
ID Name
1 Big
2 Small
3 Extra
4 Orange
5 Drink



List of Strings:
Big
Small
Extra
Read more