Kapalı

Write a Python Exe which reads SQL queries and displays a PHP Webpage Report

Please author a program which can be downloaded from my website and run on a Windows computer which completes these functions. The below is a summarized list, a completed spreadsheet of requirements will be sent upon acceptance of the project job.

[PHP]

1. “if Post is Empty”, display instructions to user to download [EXE] and run it. (Text instructions will be provided by me.)

2. “if Post is not Empty and firsttime=yes”, send an email to <useremail> with text “Your report is submitted; review it by clicking this link http://...php?method=post&firsttime=no&name=name&etc=etc”

3. “if Post is not Empty”, display an HTML report <see Command List> which looks similar to:

<table>

<tr><td>User Name</td><td>$name</td></tr>

<tr><td>User Email</td><td>$email</td></tr>

<tr><td>SQL Version</td><td>$sqlver</td></tr>

<tr><td>Count of Documents</td><td>$doc_cnt</td></tr>

<tr><td>Text1</td><td>$var1</td></tr>

<tr><td>Text2</td><td>$var2</td></tr>

etc…

[EXE]

1. This will be written in Python then made “standalone” using PyInstaller

2. Upon running, program will display a UI which receives input from user for some information: Name, EmailAddress, MS-SQL Server Name, MS-SQL Username, MS-SQL Password.

3. The UI has an "Console" which displays results and errors during running. If a command fails, the console/log will display an error message and pause (e.g. "Failed to log in to SQL Server: Username/Password Incorrect")

4. The UI has a button “Read List of Databases” which can be clicked by the user.

5. When user clicks “Read List of Databases”, program will attempt to connect to SQL and read this SQL command: Select Dbname From Vaultlist

6. Upon success, the UI will display a list of <Dbname> and allow the user to select One Single Dbname. The list may require a vertical scroll depending on quantity displayed.

7. The UI has a button “Generate Report from Selected Database” which can be clicked by the user after user has selected One Single Dbname

8. The program will connect to the SQL server. The program will use a specific database (Use <Dbname>). The program will then execute approximately 40 SQL commands and store the results <see Command List>

9. The program will generate a HTTP Post URL to the [PHP] based on the results of the SQL commands.

10. The UI Console will display the HTTP URL. The UI Console will display “Loading Default Web Browser…”

11. The program will attempt to open a Default Web Browser and launch the HTTP Post URL to the [PHP].

12. The UI has a button "Close Program". When the user clicks this button, the program closes.

[Command List]

You will be provided a list in Excel format which has approximately 40 rows and these columns:

DISPLAY TEXT, VARIABLE NAME, SQL COMMAND

User Name, name, N/A (Manual User Entry)

User Email, email, N/A (Manual User Entry)

SQL Version, sqlver, SELECT @@VERSION

Count of Files, doc_cnt, SELECT COUNT(*) FROM FILES

Text1, var1, SELECT COUNT(*) FROM TABLE

Text2, var2, SELECT AVG(*) FROM TABLE2

etc.

Beceriler: Microsoft SQL Server, Python, PHP

Daha fazlasını gör: write sql queries customer order tables, php script reads files folder displays names page, sql queries php slow, delimiter sql queries python, php script reads contents folder displays web page, virtuemart sql queries php, sql queries page php, write sql queries oracle 10g, write sql queries, Write some Sql Queries, how to write complex sql queries, how to write sql queries, how to write sql queries in access 2016, how to write sql queries in access 2007, how to write sql queries in access 2013, best way to write sql queries, how to run multiple sql queries in python, how to automate sql queries using python, best way to write sql queries in java, how to write test cases for sql queries

İşveren Hakkında:
( 2 değerlendirme ) San Jose, United States

Proje NO: #31645599

Bu iş için 33 freelancer ortalamada $553 teklif veriyor

(66 Değerlendirme)
8.1
sapnathakur14

Hello, Warm Greetings! Upon checking your project, I am pretty sure I can produce high-quality and perfect results for your project. By using Python, I used to make AI engines, BOT, Web Scraping Tools, and so on. PHP, Daha Fazla

$750 USD in 7 gün içinde
(67 Değerlendirme)
7.3
(207 Değerlendirme)
7.5
(29 Değerlendirme)
7.1
getwebsolutionsl

Hi, I have the skills "Python, PHP and Microsoft SQL Server" that you are looking for! Let's start your work right away. I can show you my python work by sharing the screen. Also, You should check my work portfolio an Daha Fazla

$750 USD in 8 gün içinde
(44 Değerlendirme)
6.8
(431 Değerlendirme)
6.7
(15 Değerlendirme)
6.2
liveexperts123

Hi there,I'm biddin on your project "Write a Python Exe which reads SQL queries and displays a PHP Webpage Report" I have read your project description and i'm an expert in Python and machine learning therefore i can d Daha Fazla

$750 USD in 5 gün içinde
(31 Değerlendirme)
6.4
durgesh8527

Hi There, *I am available to start immediately.* I have read your post requirement for the " The program will attempt to open a Default Web Browser and launch the HTTP Post URL to the [PHP]. ". Now I have some question Daha Fazla

$400 USD in 6 gün içinde
(99 Değerlendirme)
6.7
DeveloperDaut

***Python && PHP Specialist*** Hello, how are you? I've read your project description carefully. You want to build python application which reads SQL queries and displays query results on a PHP Webpage Report. As a sen Daha Fazla

$500 USD in 5 gün içinde
(23 Değerlendirme)
6.2
(20 Değerlendirme)
5.4
MashoodurRehman1

PYTHON developer I read read your job description and I am pretty sure that I can complete every bit of your requirements. Further details and cost can be discussed in chat

$250 USD in 4 gün içinde
(44 Değerlendirme)
5.2
nzmsaquib

Hi there: I have checked your project details and would like to help you with the report generation. It will take a few days to complete the whole thing working. I can start working on it as soon as you allow me to Daha Fazla

$600 USD in 3 gün içinde
(28 Değerlendirme)
4.7
ninvo

Hi , I have done similar project already and can do this python code for you as requested . Let's talk in details if you are interested.

$400 USD in 4 gün içinde
(26 Değerlendirme)
4.8
jcoulter007

Hello. I have read the project requirements. If you hire me, I will do my best to satisfy you. I have a lot of experience in this field. I hope that you will proceed with the detailed contents through dialogue. Re Daha Fazla

$630 USD in 7 gün içinde
(4 Değerlendirme)
4.4
Aliksandr7777

Hello. I have 8 years of full-stack development career. Python is an awesome platform for various development part such as web scraping, deep-learning, data science, NLP, IoT, etc. I've used PyQt, tkinter for UI in pyt Daha Fazla

$500 USD in 7 gün içinde
(7 Değerlendirme)
4.1
walterjgould

Hello Edwin, hope you have good luck. I have just read your job description carefully and I am really interested in your job. As you can see from my profile, I mastered Python with over 7 years of hands-on experience. Daha Fazla

$600 USD in 7 gün içinde
(4 Değerlendirme)
4.2
vitalik0790

Hello. How are you doing? I am Vitalii from Ukraine and python expert. As you can see my reviews, I have good experience of python and so if you award me, I will do my best and you will get good result as you want. Ple Daha Fazla

$500 USD in 7 gün içinde
(4 Değerlendirme)
3.6
ayoubbouz

Hi, I'm a software engineer, I have done this so many times, I have more than 5 years in python and web developpement, I can help you with your project right now ! Ready to discuss details of the project and budget in Daha Fazla

$450 USD in 2 gün içinde
(11 Değerlendirme)
3.9
novikovyaroslavd

Hello. Python GUI expert here I've much experineced in Python for over 8 years. If you hire me you can save your time and money pls ping me Wish a long term relation

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