11-10-2010
Script which will run every 10minutes and Send SMS to mobile
Hello Genuis guys,
I am running Aix5 and Oracle 9 on it.
I have sql query which only count a particular rows.
I need to prepare a script which will run that sql query every 10 minutes and if the ouput count is greate than 20. It will send SMS to mobile numbers.
Need your kind help to prepare this.
--Purple
8 More Discussions You Might Find Interesting
1. Programming
actually i need this sms application ,to gain some knowledge in linux
platform. (1 Reply)
Discussion started by: parvathy
1 Replies
2. UNIX for Advanced & Expert Users
hi , can anyone help with a script to send SMS to some mobile numbers on some conditions. (1 Reply)
Discussion started by: sdcoms
1 Replies
3. IP Networking
Hi All,
Can any expert provide me a guide on how i can send SMS from pc to mobile phone using VBA or some other language ?
I am a newbie in networking. (1 Reply)
Discussion started by: Raynon
1 Replies
4. AIX
Any script / program / command can be run directly to send SMS directly on AIX ? Thanks (2 Replies)
Discussion started by: look1
2 Replies
5. Shell Programming and Scripting
Hey guys I was wondering how to go about creating a bash script to send SMS..any ideas are appreciated.. (2 Replies)
Discussion started by: blackzeus
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
Can anyone please help in setting up Unix script for sending text messages on mobile??
Actually scenario is we want notification when there is any failures in our processes or if any service goes down we must be notified by a text message on our mobile, we already have email... (3 Replies)
Discussion started by: NikhilM
3 Replies
7. AIX
I need from aix to send an SMS, you know if the command curl serves me (3 Replies)
Discussion started by: tricampeon81
3 Replies
8. UNIX for Advanced & Expert Users
Hello Folks,
I need to send the output from shell script to range of mobile phones based on their msisdn . Is there any open source solution could help me to do so from CentOS or redhat ?? (11 Replies)
Discussion started by: arm
11 Replies
LEARN ABOUT PHP
sqlsrv_execute
SQLSRV_EXECUTE(3) SQLSRV_EXECUTE(3)
sqlsrv_execute - Executes a statement prepared withsqlsrv_prepare(3)
SYNOPSIS
bool sqlsrv_execute (resource $stmt)
DESCRIPTION
Executes a statement prepared with sqlsrv_prepare(3). This function is ideal for executing a prepared statement multiple times with dif-
ferent parameter values.
PARAMETERS
o $stmt
- A statement resource returned by sqlsrv_prepare(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
sqlsrv_execute(3) example
This example demonstrates how to prepare a statement with sqlsrv_prepare(3) and re-execute it multiple times (with different param-
eter values) using sqlsrv_execute(3).
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "UPDATE Table_1
SET OrderQty = ?
WHERE SalesOrderID = ?";
// Initialize parameters and prepare the statement.
// Variables $qty and $id are bound to the statement, $stmt.
$qty = 0; $id = 0;
$stmt = sqlsrv_prepare( $conn, $sql, array( &$qty, &$id));
if( !$stmt ) {
die( print_r( sqlsrv_errors(), true));
}
// Set up the SalesOrderDetailID and OrderQty information.
// This array maps the order ID to order quantity in key=>value pairs.
$orders = array( 1=>10, 2=>20, 3=>30);
// Execute the statement for each order.
foreach( $orders as $id => $qty) {
// Because $id and $qty are bound to $stmt1, their updated
// values are used with each execution of the statement.
if( sqlsrv_execute( $stmt ) === false ) {
die( print_r( sqlsrv_errors(), true));
}
}
?>
NOTES
When you prepare a statement that uses variables as parameters, the variables are bound to the statement. This means that if you update
the values of the variables, the next time you execute the statement it will run with updated parameter values. For statements that you
plan to execute only once, use sqlsrv_query(3).
SEE ALSO
sqlsrv_prepare(3), sqlsrv_query(3).
PHP Documentation Group SQLSRV_EXECUTE(3)