Completed

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.

Skills: Bash Scripting, MySQL, Perl, PHP, Python

See more: 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

About the Employer:
( 92 reviews ) dix hills, United States

Project ID: #16961756

Awarded to:

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 in 3 days
(65 Reviews)
6.8

15 freelancers are bidding on average $145 for this job

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 More

$250 USD in 3 days
(117 Reviews)
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 in 3 days
(21 Reviews)
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 More

$155 USD in 3 days
(86 Reviews)
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 More

$155 USD in 2 days
(8 Reviews)
3.0
$100 USD in 3 days
(1 Review)
2.6
shraddha1302

A proposal has not yet been provided

$166 USD in 3 days
(2 Reviews)
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 More

$222 USD in 3 days
(5 Reviews)
2.7
$155 USD in 3 days
(0 Reviews)
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 in 3 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
$45 USD in 2 days
(0 Reviews)
0.0
jb9624064090

A proposal has not yet been provided

$30 USD in 3 days
(0 Reviews)
0.0
Ebukingz

A proposal has not yet been provided

$55 USD in 2 days
(0 Reviews)
0.0
innaghind

A proposal has not yet been provided

$166 USD in 3 days
(0 Reviews)
0.0