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_rows_affected
SQLSRV_ROWS_AFFECTED(3) SQLSRV_ROWS_AFFECTED(3)
sqlsrv_rows_affected - Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed
SYNOPSIS
int sqlsrv_rows_affected (resource $stmt)
DESCRIPTION
Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed. For information about the number of rows
returned by a SELECT query, see sqlsrv_num_rows(3).
PARAMETERS
o $stmt
- The executed statement resource for which the number of affected rows is returned.
RETURN VALUES
Returns the number of rows affected by the last INSERT, UPDATE, or DELETE query. If no rows were affected, 0 is returned. If the number of
affected rows cannot be determined, -1 is returned. If an error occurred, FALSE is returned.
EXAMPLES
Example #1
sqlsrv_rows_affected(3) example
<?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 data = ? WHERE id = ?";
$params = array("updated data", 1);
$stmt = sqlsrv_query( $conn, $sql, $params);
$rows_affected = sqlsrv_rows_affected( $stmt);
if( $rows_affected === false) {
die( print_r( sqlsrv_errors(), true));
} elseif( $rows_affected == -1) {
echo "No information available.<br />";
} else {
echo $rows_affected." rows were updated.<br />";
}
?>
SEE ALSO
sqlsrv_num_rows(3).
PHP Documentation Group SQLSRV_ROWS_AFFECTED(3)