Tamamlanmış

[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

->limit(10)

->get()->toArray();

//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->timestamps();

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

});

//trying to insert into the temporary table

$to_fill = [];

foreach($Completequerytry1 as $record) {

$to_fill[] = (array)$record;

}

DB::table('temp_trades')->insert($to_fill);

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

Beceriler: PHP, Laravel, Önyükleme, MySQL, HTML

Daha fazlasını gör: 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

İşveren Hakkında:
( 5 değerlendirme ) San Salvador, Malta

Proje NO: #20107431

Seçilen:

wsafreelancer

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(139 Değerlendirme)
6.3

Bu iş için 22 freelancer ortalamada $37 teklif veriyor

leemilun

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(52 Değerlendirme)
6.4
AbhishekGarg001

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 Daha Fazla

$30 USD in 2 gün içinde
(97 Değerlendirme)
5.5
greenforest0204

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 Daha Fazla

$20 USD in 7 gün içinde
(44 Değerlendirme)
5.8
BlackEagle86

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
5.1
ThinkStartPL

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 in 10 gün içinde
(3 Değerlendirme)
4.3
nishantjain21

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 Daha Fazla

$54 USD in 2 gün içinde
(25 Değerlendirme)
5.4
MichealSMoreno

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 in 7 gün içinde
(20 Değerlendirme)
4.7
mayankinnovative

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 Daha Fazla

$155 USD in 3 gün içinde
(77 Değerlendirme)
4.5
vladzolotukhin

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
4.6
bluebear1888

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(26 Değerlendirme)
4.6
shoyablow

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 Daha Fazla

$20 USD in 7 gün içinde
(8 Değerlendirme)
3.4
prettygirl00

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. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.1
chcoder719

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 Daha Fazla

$30 USD in 7 gün içinde
(11 Değerlendirme)
3.1
Ioitsolutions

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 Daha Fazla

$20 USD in 7 gün içinde
(5 Değerlendirme)
3.0
sunainawbst

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
3.1
romansokolv708

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 Daha Fazla

$120 USD in 7 gün içinde
(3 Değerlendirme)
2.6
LyapunovPetr

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 Daha Fazla

$10 USD in 7 gün içinde
(4 Değerlendirme)
1.8
singhdivdeep

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 Daha Fazla

$25 USD in 3 gün içinde
(4 Değerlendirme)
1.8
julianlreeves

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:// Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.9
elrisingServices

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 Daha Fazla

$20 USD in 3 gün içinde
(0 Değerlendirme)
0.0