Færdiggjort

Fetch a Mysql Select with PDO (PHP 7)

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>

Evner: PHP, MySQL

Se mere: drop select tables php mysql, writing blog pdo php, dynamic form select ajax php mysql, select mysql mostrar formulario php, select last php mysql, php fetch mysql edit, click menu fetch mysql php script, php fetch mysql displaying html correctly, ajax dynamic select list php mysql , display image custom size fetch mysql blob php, program php fetch mysql data, project pdo php, select multiple php mysql, convert pdo php mysql postgres

Om arbejdsgiveren:
( 13 bedømmelser ) Wien, Austria

Projekt ID: #20449237

Tildelt til:

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 på 1 dag
(116 bedømmelser)
6.2

27 freelancere byder i gennemsnit €23 på dette job

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 Flere

€19 EUR in 7 dage
(134 bedømmelser)
6.7
ghanshyamsain

Hi mate, We’ve gone through your requirements what exactly you want for your work defiantly we will fulfill your requirements within your budget & time duration. We are providing these services are:- PHP/Word press/JQu Flere

€30 EUR på 1 dag
(142 bedømmelser)
6.7
AndrewYer

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

€20 EUR på 1 dag
(236 bedømmelser)
6.6
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 Flere

€50 EUR på 1 dag
(72 bedømmelser)
6.4
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 Flere

€30 EUR på 1 dag
(32 bedømmelser)
6.5
leemilun

Hello. I have good skills and experiences as you requested on your project. You can see my results as follow. [login to view URL] [login to view URL] [login to view URL] I am very interested in your p Flere

€19 EUR in 7 dage
(52 bedømmelser)
6.3
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 på 1 dag
(103 bedømmelser)
6.0
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 Flere

€19 EUR på 1 dag
(46 bedømmelser)
6.0
matteus1118

Welcome to your job! I've just checked your needs with high attention. I have rich experiences and flexible skills in SQL query. I think I'm the right person you are looking for. If you hire me, I'll make great efforts Flere

€19 EUR in 7 dage
(13 bedømmelser)
5.2
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. Flere

€19 EUR in 7 dage
(7 bedømmelser)
5.1
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 sour Flere

€29 EUR in 2 dage
(16 bedømmelser)
4.8
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 mess Flere

€30 EUR på 1 dag
(14 bedømmelser)
4.8
romansokolv708

Hi, Hope you are doing well. I have read your description with care. I am very interested in your project. I can. I have rich experience in Web Development. [login to view URL] [login to view URL] (eCommerce) Flere

€30 EUR på 1 dag
(9 bedømmelser)
3.7
whiteeagle0001

Hello,How are you? I have checked your code. I can do it. I have read your description in more detail and have much interest in your project. So I think that I can finish your work perfectly as you need.I have many exp Flere

€30 EUR på 1 dag
(5 bedømmelser)
3.4
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 y Flere

€25 EUR på 1 dag
(7 bedømmelser)
3.1
aykutcanturkmen

Dear client! I've read your complete requirements and I can fulfill your task perfectly in time on my rich experience for you because I have done those project before. I have been working for 9 years as an Web & Mobil Flere

€10 EUR på 1 dag
(6 bedømmelser)
2.7
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 in 7 dage
(10 bedømmelser)
2.8
jinjinwu

Hi, Client. Thank you for your job posting. I read your description very carefully. I have experience PHP framework(laravel and codeigniter) and Wordpress development for 5 years long. And I majored Angular.js, JavaSc Flere

€30 EUR in 2 dage
(1 bedømmelse)
2.0
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 på 1 dag
(2 bedømmelser)
1.2
MarsCharmer

Hello. I've read your job description carefully. This job really attracts me and also your required skills are completely matched with my major skills. I can start if you hire me for this job. I have good knowledge and Flere

€10 EUR på 1 dag
(0 bedømmelser)
0.0