Fetch a Mysql Select with PDO (PHP 7)

€8-30 EUR

已完成

已发布

超过 4 年前

€8-30 EUR

货到付款

Hi, I have a complex SQL Select which should be fetched with PHP. The Select is ok, but I do not get any results. (I get results when I fetch in phpmyadmin) Here is my code: <?php include('[login to view URL]'); ?> <?php $stmnt = $pdo->prepare("SELECT COUNT(*) as total, MONTHNAME(datum) as Monat, YEAR(datum) as Jahr from ( select COUNT(*) as cnt, artikel, datum, preis from wccrm_prov where typ = 'Brautkleid' GROUP by artikel, preis, datum ) t GROUP by MONTHNAME(datum), YEAR(datum) ORDER by datum DESC;"); ?> <table> <tbody> <tr> <td>Monat</td> <td>Jahr</td> <td>Verkäufe</td> </tr> <?php while ($daten = $stmnt->fetch()) { ?> <tr> <td><?php echo $daten['Monat']?></td> <td><?php echo $daten['Jahr']?></td> <td><?php echo $daten['total']?></td> </tr> </tbody> <?php } ?> </table> </html>

PHP

MySQL

项目 ID: 20449237

关于此项目

18提案

远程项目

活跃5 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@softcarve

Hi, I would like to fix the above php code to fetch the records. Available for discussion and ready to start now. Regards, Manish

€15 EUR 在1天之内

4.9

(119条评论)

6.2

18威客以平均价€23 EUR来参与此工作竞价

@vishal80

//** READY TO START RIGHT AWAY **// With the reference of your description I would like to inform you that I am the most eligible freelancer here with whom you can discuss this project. After our discussion I am sure you will love to work with me. I have built websites for several brands around the world with great success, and are quite excited to get to work on yours

€19 EUR 在7天之内

4.9

(167条评论)

7.0

@Mickelson

Hi. I have just read your description carefully. As an experienced developer, I am sure that I can handle your project perfectly. Even If you don't hire me, I can give you my opinion related to this job. Let me know If you have any time to discuss more details with me. Looking forward to hearing from you. Thanks. Lian.

€50 EUR 在1天之内

4.9

(107条评论)

6.8

@AndrewYer

Hello! This project is interesting for me. I'm ready to start it right now and finish asap. Best regards, Andrii

€20 EUR 在1天之内

5.0

(248条评论)

6.7

@hoisticdeveloper

Greetings, Hi, I am Hassaan Shuja. I have 6 years of experience in the Web Development Department and Designing. I have reviewed the description and understand it very well. I want to start the project right now, just need to discuss it little to more clear the image of the project. Please come to inbox so that we can lock the scope of the project. “ I am a Laravel Ninja along with Node js and frontend react, vuejs and angular skills that I can prove.” I have 6 years of experience in Web Development, and I am an expert in my domain areas like PHP, Laravel, CodeIgniter, wordpress, shopify, magento, Drupall, My SQL, Angular, React, React Native, Node, Mongo DB, Golang. I have extensive knowledge of Html5, Css3, Javascript, Ajax, jQuery, Bootstrap, and Payment Integration modules as well. I assure you that you will experience the WOW factor in my work. I am looking forward to your response. Many Thanks Hassaan Shuja

€30 EUR 在1天之内

4.9

(35条评论)

6.5

@bindmission

Hello Hope you are doing well. I have 7 years of experience in Linux and PHP. I can fix the error. Regards VishnuLal*

€30 EUR 在1天之内

4.9

(236条评论)

6.6

@ludwig333

Hi, Nice to meet you!.Thank you for your posting job. I read your project description carefully and I can start right now. As you can see on my profile, I have expertise skills to build a web app using PHP, CSS, HTML, Javascript and mysql query expert Please don't hesitate to tell me if you need me. I'd be happy to do your project if you'd like. I hope to work with you, sincerely.

€19 EUR 在1天之内

4.9

(48条评论)

6.1

@iotait

Hello Stefan L, I've worked on your similar project with PDO Select query. I will be able to do this task also. Please feel free to write me back so I can get it working for you. Thanks & Regards.

€15 EUR 在7天之内

5.0

(61条评论)

6.0

@lexsystems

Hey man! I am Alex. I am a Core PHP developer. I do mostly back-end programming so I could easily fix your code or write another one for you. It can be written using PDO or MySQLI , the choice is yours. Give me a message. Alex

€30 EUR 在1天之内

5.0

(24条评论)

5.4

@BlackEagle86

Hi, I’ve carefully gone through your job post. I have more than 8+ years of experience WEB development. I am very much interested in your project with all of your requirements. I feel very confident about your project. I work hard for you and you will surely get the result in a promised time. I can start working immediately. Looking forward to discussing with you the details. Regards.

€19 EUR 在7天之内

5.0

(10条评论)

5.2

@Mexi2705

Hello, I read your requirements and Understand Very well And ready to start work from now . I have developed & delivered Web database applications Mobile App development for enterprises & companies, using open source language PHP, MySQL, HTML 5, CSS3, AJAX, JSON, XML, etc. Coding, project and team management is my passion. My expertise comprises of CMS and Frameworks like, content writing, seo, smm, Wordpress, Cake PHP, Laravel, Magento, OS Commerce, Zen Cart, Codeigniter, Joomla, YII Framework, SEO, Social Media Marketing, MVC frameworks, Google Maps, Payment gateway integration, Familiarity with Linux environment and Apache, Javascript, Jquery, Ajax, xHTML, CSS/CSS3, HTML5, XML, XSLT, Flash, Git & SVN. Throughout these years, apart from advanced coding skills; I have good hands on experience in adding value to customer via effective I look forward to hearing from you. Thanks & Regards, Mehul

€29 EUR 在2天之内

5.0

(26条评论)

5.1

@uelionobre

Hi, I am full stack developer. I have read all your requirement and I wish to work for your project. I'm very interested in your job post.I believe my skills would be ideal for your project. I am ready to start with your project immediately and I can do your task till 10~15 hours. I assure you quality work, complete attention and proper communication. I eager to provide excellent results for my clients and I have never had any kind of incidents with the clients. Client satisfaction is always my first concern. Thank you for your time.

€25 EUR 在1天之内

4.7

(10条评论)

3.3

@Saimi786

Hello Thanks for your posting. Your requirements are fully clear to me and I am applying only because I meet all the requirements that you are looking for. I have been working as a web developer and designer for more than 6 years and I know all the ins and outs of web development and customization.

€17 EUR 在2天之内

5.0

(4条评论)

2.4

@bestappsol

Hello, I checked your program . Sure, I will fetched with PHP as per your needs. I have 6 years of experience in web development . I am waiting your good response Thanks Anamika

€20 EUR 在1天之内