sedang Berlangsung

PHP mysql query to Powershell

I am running php script on a server that puts multiple logfiles into database, which is working like a charm. So i have noticed that there is some powershell script which would need just a little bit modification to work instead of that php file. Since I am not a real powershell guy and aint going to learn it just for this script I need help with it.

How does it work at the moment?

[login to view URL] (attachment) is the logfile example in the same directory like other logfiles.

[login to view URL] is a php file which puts all logfiles in directory into database if they are not duplicated on some primary key for example... that doesnt really matter the db structure and so on, I will set that.

so now a powershell [login to view URL] which would run on local pc and update the logfiles from that directory in remote mySQL on same principle as does [login to view URL] (note that logfiles does not have any delimiters)

[login to view URL] powershell file is checking for changed/created new logfiles and also outputs them into another logfile every 5 seconds (found on web and would fit my needs)

So what i need from you?

Edit powershell file that scans directory every x seconds for changes and creations of new .log files (this is already done)

If the file edit/modification or creation is true then it should start mysql query to insert that last new lines of .log files

Also there should be in case if pc has no connection and so on, some kind of check of last inserted files and should loop thru that ones until is sucesfully inserted in mySQL tables, so that we dont want to miss any of logfile outputs in mysql.

An mysql connection (password, username or even better also database and server) should be a little bit more secure and not readable, i have seen some examples of that encrypting and decrypting in powershell.

If you have any other questions dont be afraid to ask. However this should be simple task since there is not so much diference in foreach and so on with powershell so I think you got the point.

Regards

Keahlian: MySQL, PHP, Powershell

Lihat lebih lanjut: powershell run mysql script, microsoft powershell mysql, mysql powershell module, powershell update mysql table, powershell mysql insert, powershell execute mysql command, powershell mariadb, connect mysql using powershell, php mysql query table, php mysql query format table, php mysql query category drop, import php mysql query quickbooks, php mysql query sanitize, php mysql query encoding, php mysql query, php mysql query drill, php mysql query sanitized, php mysql query suggest, php mysql query loop records, php mysql query file

Tentang Pemberi kerja:
( 1 ulasan ) Bled, Slovenia

ID Proyek: #17987429

Diberikan kepada:

BongDali

dier sir I fully understand your project. I will make your project perfect. I work on projects related to: - CMS: Wordpress, Opencart, Magento, Drupal, Joomla, ModX, Bitrix - From 'scratch' with core php - Php- Lebih banyak

€20 EUR dalam 1 hari
(0 Ulasan)
0.0

3 freelancer menawar dengan rata-rata €33 untuk pekerjaan ini

sharmarahulraman

Hello, Hope you will be doing well!! I have read your description and I understand your requirement and I can handle your project. Please discuss with me for more clarification. Here is some example of m Lebih banyak

€55 EUR dalam 2 hari
(85 Ulasan)
6.1
stalwartsoftIND

Hello there, Greetings...! A pleasure to submit the proposal for your kind consideration. We have studied your post and understood the requirement. We would like to let you know that I have more than 4 yea Lebih banyak

€23 EUR dalam 1 hari
(11 Ulasan)
2.4