I'm using the below code to pull some results from the database with Laravel 5.
BookingDates::where('email', Input::get('email'))->orWhere('name', 'like', Input::get('name'))->get()
However, the orWhereLike doesn't seem to be matching any results. What does that code produce in terms of MySQL statements?
I'm trying to achieve something like the following:
select * from booking_dates where email='my@email.com' or name like '%John%'
after reading error msg in CMD (DOS) and check laravel documentation
error in length i dont know if any one see this error before or not but when i edit length its work
i edit 3 migration as below :-
1 -1- Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('username')->unique(); $table->string('email')->unique(); $table->string('password'); $table->rememberToken(); $table->timestamps(); $table->integer('role'); });
and now its
Schema::create('users', function (Blueprint $table) {
$table->increments('id')->autoIncrement();
$table->string('name',200);
$table->string('username',50)->unique();
$table->string('email',100)->unique();
$table->string('password',50);
$table->string('role',50);
$table->rememberToken();
$table->timestamps();
});
number 2 it was
Schema::create('password_resets', function (Blueprint $table) { $table->string('email')->index(); $table->string('token'); $table->timestamp('created_at')->nullable(); });
and now its :-
Schema::create('passwordreset', function (Blueprint $table) {
$table->string('email',200)->index();
$table->string('token',200);
$table->timestamp('created_at')->nullable();
});
number 3 it was :-
3- Schema::create('tweets', function (Blueprint $table) { $table->increments('id'); $table->integer('user_id')->unsigned()->index(); $table->text('text'); $table->timestamps(); });
now its :-
Schema::create('tweets', function (Blueprint $table) {
$table->increments('id')->autoIncrement();
$table->string('user_id',50)->index();
$table->string('twetts',255);
$table->timestamps();
});
A bit of a late response but I figured it out. This is my solution.
I First added this function to my User Modal Class.
public function getRanking(){
$collection = collect(User::orderBy('wins', 'DESC')->get());
$data = $collection->where('id', $this->id);
$value = $data->keys()->first() + 1;
return $value;
}
Now in my view I run my getRanking() function.
@foreach($ranking as $key => $rankings)
<tr>
<td>{{ $rankings->getRanking() }}</td>
<td><a href="{{ route('profileView', ['id' => $rankings->id]) }}">{{ $rankings->username }}</a></td>
<td>{{ $rankings->wins }}</td>
<td>{{ $rankings->losses }}</td>
</tr>
@endforeach
I am using my array keys to determine the user ranking.
Good night!
Use DB::raw()
User::where(DB::raw('upper(name)'), 'LIKE', '%FOO%')->get()
It would generate query like this
"select * from `users` where upper(name) LIKE ?"
I Solved My Problem Myself by Changing My create_users_table.php
<?php
use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class CreateUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::dropIfExists('users');
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('password');
$table->rememberToken();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('users');
}
}
If you want to see what is run in the database use
dd(DB::getQueryLog())to see what queries were run.Try this