Đã hoàn thành

Query Mysql. Post to a web page

select phone_number,from device_status where bal <>'0.00' and phone_number>'1' and updated_at > date_sub(now(),interval 5 minute) and bal < '5000' and tries < warn and accumulated < x;

Some entries will be found

Log into a web form

*225*[number]*[rand]# where rand will be a random number in a range rounded to a certain amount.

Click send.

increment tries=tries+1

accumulated=accumulated+rand

Example perl script which performs a similar command on the same page.

if con:

[login to view URL]()

def send_message(self):

'''Sends loaded data to server. self.unknow_number and self.known_number must be defined'''

br = [login to view URL]()

cj = [login to view URL]()

# Browser options

br.set_handle_equiv(True)

#br.set_handle_gzip(True)

br.set_handle_redirect(True)

br.set_handle_referer(True)

br.set_handle_robots(False)

# Follows refresh 0 but not hangs on refresh > 0

br.set_handle_refresh([login to view URL](), max_time=1)

# User-Agent (this is cheating, ok?)

[login to view URL] = [('User-agent', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.1) Gecko/2008071615 Fedora/[login to view URL] Firefox/3.0.1')]

r = [login to view URL]('[login to view URL]')

br.select_form(name='login')

[login to view URL]['username'] = 'root'

[login to view URL]['password'] = 'vijay'

[login to view URL]()

#print [login to view URL]().read()

[login to view URL]('[login to view URL]')

#print [login to view URL]().read()

br.select_form(name='myform')

[login to view URL]["smsnum"] = self.known_number[0]

#[login to view URL]["smsnum"] = "16312686765" #set for debug

[login to view URL]["Memo"] = "Is this it? %s" % self.unknown_number[1]

#[login to view URL]["smsgoip"] = self.unknown_number[0] #wrong approach

#[login to view URL]['smsgoip'] = ["181"] #set for debug

item =br.find_control(name="smsgoip", type ="select").get(label=self.unknown_number[0])

item.selected=True #does this work?

[login to view URL]()

import re

search = [login to view URL]('([login to view URL]\?messageid=\d+&USERNAME=&PASSWORD=)')

[login to view URL]('[login to view URL]'+[login to view URL]([login to view URL]().read()).group(1))

#print [login to view URL]().read()

def process_task(self):

''' Does all tasks. Loads data from db and sends it to remote server.'''

self.get_data_from_db()

self.send_message()

def __init__(self):

self.process_task()

if __name__=='__main__':

UnknownNumbersSender()

This page does not have anythign like a capcha . Only a username and password

If the script is already running, ensure It does not run again.

Kĩ năng: Bash Scripting, MySQL, Perl, PHP, Python

Xem nhiều hơn: store data from html form to database, how to insert data in mysql using html form, how to connect html form to mysql database using javascript, how to connect html form to mysql database using php, insert data from form to mysql database php, how to insert data into mysql db using form in php database, how to save data from html form to a database using php, how to store form data in database using php, post web page vb6, php code show mysql table web page, display mysql table web page, upload photos post web page script, post mysql data web page, display mysql results web page, mysql php web page entry, visual basic auto logon post web page, display information mysql database web page, show mysql data web page, delphi post web page form, mysql data web page

Về Bên Thuê:
( 92 nhận xét ) dix hills, United States

ID dự án: #16961756

Được trao cho:

freelance4hire80

Hi I can come out a Perl script to query mysql database, and then post data to a web page. btw, the sample code provided is in python not perl. regards Andy

$222 USD trong 3 ngày
(65 Đánh Giá)
6.8

15 freelancer đang chào giá trung bình $145 cho công việc này

forcitCample

Hi there, How are you?? I read your job description and understand that you want to add Query on a web form which includes the selection of phone number and status. After that, you want to have a login panel having Thêm

$250 USD trong 3 ngày
(117 Nhận xét)
7.1
anatolygenay123

Hello. I am a Mysql, PHP and Python expert. I can help you perfectly. I'd like to discuss. Thanks............................

$250 USD trong 3 ngày
(21 Nhận xét)
5.4
mshahzeb43

Hi there, If you want to create a website for your company or you want to create a personal website or if your website is suffering from any coding issues then you are at the right place. I will develop websites using Thêm

$155 USD trong 3 ngày
(86 Nhận xét)
5.6
rutherfordandco

Hey vjfromgt! I urge you to message me, I have all relevant experience for your project and my portfolio is guaranteed to impress you. I'm English and based in the United Kingdom. My communication, professionalism and Thêm

$155 USD trong 2 ngày
(8 Nhận xét)
3.0
$100 USD trong 3 ngày
(1 Nhận xét)
2.6
shraddha1302

A proposal has not yet been provided

$166 USD trong 3 ngày
(2 Nhận xét)
2.7
hungvotan

with 10 years experience in Wordpress, PHP, Woocommerce, SEO. I can help you finish projects which you probose. we can communicate each other easily. we had several year 's experience in this area. set your mind Thêm

$222 USD trong 3 ngày
(5 Nhận xét)
2.7
$155 USD trong 3 ngày
(0 Nhận xét)
0.0
SujonHosain

hi you need Query in Mysql access .....i can done this job.......i have great experience in this job.... if you interest inbox me thanks

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
heshamtohami23

i'm getting expert of this field for 7 years can do it perfectly have expert certification from cairo university stockholm university stock city fc

$55 USD trong 1 ngày
(0 Nhận xét)
0.0
$45 USD trong 2 ngày
(0 Nhận xét)
0.0
jb9624064090

A proposal has not yet been provided

$30 USD trong 3 ngày
(0 Nhận xét)
0.0
Ebukingz

A proposal has not yet been provided

$55 USD trong 2 ngày
(0 Nhận xét)
0.0
innaghind

A proposal has not yet been provided

$166 USD trong 3 ngày
(0 Nhận xét)
0.0