cemcminn

cemcminn

Member Since 1 Month Ago

Experience Points 2,540
Experience
Level
Lessons Completed 19
Lessons
Completed
Best Reply Awards 1
Best Reply
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • Chatty Cathy Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

11 Jan
1 week ago

cemcminn left a reply on Converting Mysql To Laravel Query

Do you maintain your own database? If so, is it mySQL?

cemcminn left a reply on Converting Mysql To Laravel Query

Here is a stack overflow article:

https://stackoverflow.com/questions/34497063/how-to-execute-stored-procedure-from-laravel

I will go back through my reference material and see if I can find a tutorial for you.

cemcminn left a reply on Converting Mysql To Laravel Query

Why would you not want to do something that detailed as a stored procedure?

Example:

DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));
10 Jan
1 week ago

cemcminn left a reply on Advanced Database Searching (Ad Hoc Querying)

I looked at Scout. I don't see that does anything other than full-text searching. Am I missing something?

09 Jan
1 week ago

cemcminn left a reply on Advanced Database Searching (Ad Hoc Querying)

@JLRDW - Thank you! Scout looks like something I should perhaps look into. My goal is to allow a flexible query building process on as many of the fields as possible. Translation: Not so much coding and more dynamic -- especially if if I add new fields down the road.

Before I decided to use Laravel, I had actually almost built something using MySQL schema info tables and the comment field. Here is a snippet or two:

Array to hold comparison types:

private $operators_arr = ['='=>'equals', '!='=>'not equal to', '>'=>'greater than', '>='=>'greater than or equal to', '<'=>'less than', '<='=>'less than or equal to', 'like'=>'like', 'like'=>'begins with', 'contains'=>'contains'];

Array to hold form field types (html):

private $answer_type_arr = ['textbox'=>'1', 'datepicker'=>'3', 'yn_bit'=>'4', 'dd_specific'=>'5'];

Then in the comments of the field, I planned to add 'Field Label|1' -type conventions for those fields which should be searchable.

I built stored procedures to access the table/column information that started something like this:

select concat(table_name, '.', column_name) as column_name, column_comment from information_schema.columns where (table_name like ...) and COLUMN_NAME not in (place to leave out columns that are not to be searched) or COLUMN_NAME not !=;

Then I had built a form that could be hidden and displayed on the management page and additional rows added as needed (with a plus sign button type design) to build the search parameters for the search.

I think Scout may be infinitely easier, however :-) Thank you for your response.

08 Jan
2 weeks ago

cemcminn started a new conversation Advanced Database Searching (Ad Hoc Querying)

I am developing my first Laravel Project.

The project that I will be building is a web version of a FileMaker legacy system.

In FileMaker, the user is able to search all fields included on the layout in order to display the accounts he/she wants to work with. The database is quite complex with at least 7 to 8 data tables with many fields to maintain for each account (I would say there is 200+ in all). I would prefer to build a search panel -- I do not relish the idea of having search and edit in one set of fields -- unless that is part of Laravel that I need to embrace :-)

I am looking for a design pattern to follow that might be most effective in a case like this in Laravel.

I found this github project: https://github.com/amochohan/advanced-eloquent-search-filters

Is this probably my best route? Anyone else have another suggestion for a design pattern/search setup I should pursue?

Thank you!