[QuickProject]: Fix laravel +AdminLTE bootstrap mysql sintax errors and send results to view

Hi, i have a laravel 5.8 + AdminLTE bootstrap project.

I have managed to read values from dropdowns and a date picker to build a query.

I only need 4 things from you:

- This query results have to be inserted into a temporary table (without using raw sql) and displayed in a new view.

- Below is the code i have so far so you can have a better idea of what to do. It's giving me errors and i keep testing without luck so you only have to review it and fix the errors.

- The date picker isn't working and you have to fix the current bootstrap plugin that i'm using or choose any other that you want, as long as you still tell me how you made it work.

(please if you are reading this contact me with codeword: lucino)

- Give me a few minutes so you can answer my question about the changes you made to the controller and views.

If you can do this, I'll give you access to my server so you can work in there.

//This is the code:

public function TrendSelector2(Request $request) {

//catching all dropdown values

$subSectorSelect = $request->input('subSectorSelect');

$ColumnType = $request->input('ColumnType');

//you have to catch $selectedrisklevel as well

$selectedrisklevel = $request->input('riskSelect');

//And to catch the value from the date picker

//translating columntype value to trend in order to use it for the query later

if ($ColumnType == "Arriba") {

$ColumnType = 'X';

} elseif ($ColumnType == "Abajo") {

$ColumnType = '0';

} else {

echo "Selecciona la tendencia deseada";


//This is the query

$Completequerytry1 = DB::table('Companies')

->join('Sectors', '[login to view URL]', '=', '[login to view URL]')

->join('Company_PriceRS', '[login to view URL]', '=', '[login to view URL]')

->join('SubSectorsBPIsData', '[login to view URL]', '=', '[login to view URL]')

->select('[login to view URL]', '[login to view URL]', '[login to view URL]', '[login to view URL]', '[login to view URL]','[login to view URL]')

->where('[login to view URL]', '=', 'strong')

->where('[login to view URL]', '=', $ColumnType)

->where('[login to view URL]', '=', '2017-05-08') //catch the value from the date picker in order to select a day



//Now i need to create a temporary table where to insert the results from the query

Schema::create('temp_trades', function ($table) {

$table->string('SectorName', 150);

$table->string('Symbol', 30);

$table->string('strenght', 30);

$table->bigInteger('parentid'); //check lenght

$table->string('Risklevel', 50);

$table->string('ColumnType', 1);


$table->temporary(); // temp table


//trying to insert into the temporary table

$to_fill = [];

foreach($Completequerytry1 as $record) {

$to_fill[] = (array)$record;



$tempdatatable = DB::table('temp_trades')->get();

Schema::drop('temp_message'); //dropping the temp table

return view('besttradesresultstable', array('$tempdatatable' => $tempdatatable)); //returning the view with a new table



Thanks in advance.

Kemahiran: PHP, Laravel, Butstrap, MySQL, HTML

Lihat lagi: fix mysql joomla errors, mysql database errors, bootstrap mysql static hotel info engine, php dashboard template, how to create admin panel in php with demo, how to use adminlte, adminlte examples, php dashboard examples, adminlte laravel demo, jeroennoten/laravel-adminlte, adminlte 3 laravel, twitter bootstrap mysql, bootstrap mysql, bootstrap mysql javascript, bootstrap mysql grab table, php bootstrap mysql website, php bootstrap mysql, codeigniter bootstrap mysql, getacoder bootstrap mysql, php, cakephp, laravel, html, jquery, mysql

Tentang Majikan:
( 5 ulasan ) San Salvador, Malta

ID Projek: #20107431

Dianugerahkan kepada:

                                                's Profile Picture"                                                    >
                                        <div class=

HI sir i am interested to fix your datepicker issue with mysql once contact me i will start your project immediately once we will discuss about project if you are not satisfied with my skills once visit in my profile Lagi

$15 USD dalam sehari
(139 Ulasan)

22 pekerja bebas membida secara purata $37 untuk pekerjaan ini


Dear employer. I have read your project description. Surely I can help you. As you can see from my profile, I have a wealth of experience of Laravel. I will do my best to satisfy you, I am very passionate about quality Lagi

$40 USD dalam sehari
(52 Ulasan)

lucino Hello As I can see from job posting, you are in need of a Laravel expert who can help you with your Laravel developer project. Well, I am highly interested in applying for this. I have been working on Laravel Lagi

$30 USD dalam 2 hari
(97 Ulasan)

Hello! I am very interested in your post project. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have worked on similar projects to what you are look Lagi

$20 USD dalam 7 hari
(44 Ulasan)

Hi, High talented Mathematician, Mobile and Web expert is here! I have read your proposal very carefully and I have come to learn that this job is very suitable for me. I have 10+ years of experience for Mobile App D Lagi

$25 USD dalam sehari
(7 Ulasan)

Hello Sir! Greetings! I have 5 years of experience as a PHP full stack developer. Please open chat for further discussion. Regards, ANIL

$25 USD dalam 10 hari
(3 Ulasan)

Dear Employer, I came across your job post of need a Laravel developer to fix mysql error [login to view URL] have 5+ years of experience with over 600+ happy [login to view URL] can do your task elegantly and efficiently within the ti Lagi

$54 USD dalam 2 hari
(25 Ulasan)

Dear client, how have you been? I've read your project description carefully. Presenting this proposal with 100% confident. How about discuss in chat? Waiting for your reply. Best regards.

$25 USD dalam 7 hari
(20 Ulasan)

Dear Client, We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, OpenCart, Magento, PSD to HTML, Angular JS, Node JS photoshop, OPencart, Codeignitor, Laravel and many other technologies. We have Lagi

$155 USD dalam 3 hari
(77 Ulasan)

Lucino#################### hi,client I saw your codes above. I can fix your error. My skill is in my profile as you can see. I 'm ready to work for you. I would like you to discuss more with you. Thank you.

$20 USD dalam sehari
(7 Ulasan)

How do you do? I am a creditist. I'm very happy to have a chance of bidding your project. I have read carefully the descriptions and understood clearly what you want. I have experience in development of the projects li Lagi

$20 USD dalam sehari
(26 Ulasan)

Hello, I am a PHP developer, with 7 years of experience, with excellent expertise in API, JS and Wordpress. Please check some of my past work: Wordpress: [login to view URL] [login to view URL] http://operadesi Lagi

$20 USD dalam 7 hari
(8 Ulasan)

hi sir i am very pleasure the opportunity to discuss this job with you. i am a full time freelancer with skills and experience on laravel,codeigniter,wordpress and angular.js, vue.js, react.js node.js, JavaScript etc. Lagi

$20 USD dalam sehari
(7 Ulasan)

hello you job posting caught my eyes and i got interested in your project. i have already experience about it. i am managing Larvel project. please contact me if you would like to schedule an interview or have a questi Lagi

$30 USD dalam 7 hari
(11 Ulasan)

I have the ability to create back-end code that will add utility to everything the front-end designer creates. I'm passionate about the impact of my skills I have in the real world, and firmly believe that I can creat Lagi

$20 USD dalam 7 hari
(5 Ulasan)

lucino *********LARAVEL EXPERT********** Hello, Thanks for job posting. I have read the description carefully and give you 100% assistance as PHP Developer to fix laravel +AdminLTE bootstrap mysql sintax errors an Lagi

$50 USD dalam sehari
(4 Ulasan)

Yes, Sir. I have read your project with care. Thank you for give a chance to prove me by my skills. Your project is very fit to my skills. If you would award it to me, I am sure that I can complete this project with Hi Lagi

$120 USD dalam 7 hari
(3 Ulasan)

Hello! I have read and understood your description enough. So I am interested in your project. I have an excellent background as a Web Developer along with my academic education in Computer Science and Technology. The Lagi

$10 USD dalam 7 hari
(4 Ulasan)

lucino Greetings I am a web developer and have experience in the same from the last 5 years. I have developed many websites and clients have given good reviews about them. I have experience in PHP, Laravel and have Lagi

$25 USD dalam 3 hari
(4 Ulasan)

Hello. I have just read and understood your description enough. So I am excited in your project. I will be always self-motivated, passionate and dedicated in client's project. [login to view URL] https:// Lagi

$50 USD dalam sehari
(2 Ulasan)

We provide superb quality web design and development works for websites, Android App, e-commerce stores, businesses, and brands. To provide quality designs on time to meet your requirements and to fit into your budget Lagi

$20 USD dalam 3 hari
(0 Ulasan)