[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.

Taidot: PHP, Laravel, Bootstrap, MySQL, HTML

Näytä lisää: 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

Tietoa työnantajasta:
( 5 arvostelua ) San Salvador, Malta

Projektin tunnus: #20107431

Myönnetty käyttäjälle:


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 Lisää

$15 USD 1 päivässä
(139 Arvostelua)

22 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$40 USD 1 päivässä
(52 arvostelua)

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 Lisää

$30 USD 2 päivässä
(97 arvostelua)

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 Lisää

$20 USD 7 päivässä
(44 arvostelua)

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 Lisää

$25 USD 1 päivässä
(7 arvostelua)

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 10 päivässä
(3 arvostelua)

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 Lisää

$54 USD 2 päivässä
(25 arvostelua)

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 7 päivässä
(20 arvostelua)

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 Lisää

$155 USD 3 päivässä
(77 arvostelua)

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 1 päivässä
(7 arvostelua)

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 Lisää

$20 USD 1 päivässä
(26 arvostelua)

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 Lisää

$20 USD 7 päivässä
(8 arvostelua)

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. Lisää

$20 USD 1 päivässä
(7 arvostelua)

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 Lisää

$30 USD 7 päivässä
(11 arvostelua)

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 Lisää

$20 USD 7 päivässä
(5 arvostelua)

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 Lisää

$50 USD 1 päivässä
(4 arvostelua)

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 Lisää

$120 USD 7 päivässä
(3 arvostelua)

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 Lisää

$10 USD 7 päivässä
(4 arvostelua)

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 Lisää

$25 USD 3 päivässä
(4 arvostelua)

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:// Lisää

$50 USD 1 päivässä
(2 arvostelua)

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 Lisää

$20 USD 3 päivässä
(0 arvostelua)