Laravel 5.4 – Get comma separated values in sql
In this post we will give you information about Laravel 5.4 – Get comma separated values in sql. Hear we will give you detail about Laravel 5.4 – Get comma separated values in sqlAnd how to use it also give you demo for it if it is necessary.
Some time you get recird from comma separated values in sql. for example you craete one users module and this user know multiple language like english, france, hindi, italian etc…, so, some time to get only that type records whcih user know english.
So we have hew one language table like that
language table
+----+---------+
| id | name |
+----+---------+
| 1 | english |
+----+---------+
| 2 | hindi |
+----+---------+
And we have one another table in this table we have store user information like that
users table
+----+-------------+----------+
| id | language_id | name |
+----+-------------+----------+
| 1 | 1,2 | john doe |
+----+-------------+----------+
| 2 | 1 | Hanry |
+----+-------------+----------+
| 3 | 2 | Harry |
+----+-------------+----------+
[ADDCODE]
Now we are required only that user which know english, then here we are getting 2 user name. 1.john and 2. Hanry. so how to done this type query in laravel. it is posible with in laravel using find_in_set() like that
$data DB::table("users.*")
->whereRaw("find_in_set('2',language_id)")
->orderBy("users.id","asc")
->get();
Then we are geting like that result
+----+-------------+----------+
| id | language_id | name |
+----+-------------+----------+
| 1 | 1,2 | john doe |
+----+-------------+----------+
| 2 | 1 | Hanry |
+----+-------------+----------+
We are hope this small tutorials is helpfull to you…..
Hope this code and post will helped you for implement Laravel 5.4 – Get comma separated values in sql. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
PHP - I Can't get the $_POST Values on Ajax Request
In this post we will give you information about PHP - I Can't get the $_POST Values on Ajax Request. Hear we will give you detail about PHP - I Can't get the $_POST Values on Ajax RequestAnd how to use it also give you demo for it if it is necessary.
I want to share this posts with you because when i was working on native PHP and Ajax Post request(Specially AngularJS Post request) at that time i can't get Post value on form submit. That's why i would like to share you this post. I also want to tell you i was working on my Ubuntu 14.04. I did try lot but i can't get value.
At last find stuff to how to solve this issue, i did use "file_get_contents('php://input')" that way i could get POST value in json object and i also decode json value using "json_decode()". So let's try this way :
Example:
$post = file_get_contents('php://input');
$post = json_decode($post);
$sql = "INSERT INTO items (title) VALUES ('".$post->title."')";
$result = $mysqli->query($sql);
Hope this code and post will helped you for implement PHP - I Can't get the $_POST Values on Ajax Request. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs