Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
2
Posts with Downvotes
1
Downvoting Members
2
0 Endorsements
~58.0K People Reached
Favorite Forums
Favorite Tags
Member Avatar for hemgoyal_1990

I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 …

Member Avatar for Manabendra
1
18K
Member Avatar for blueguy777

How to store the following curl_exec output into mysql table? sent,success,114661698,709081462,+919900123456 sent,success,134707665,937687314,+917795987654 Eg: var1='sent' var2='success' var3='114661698' var4='709081462' var5='+919900123456' --------------------------------------------------- var1='sent' var2='success' var3='134707665' var4='937687314' var5='+917795987654' Thanks in advance

Member Avatar for cereal
0
2K
Member Avatar for blueguy777

Getting the follwoing error message. How to fix this? **Parse error: syntax error, unexpected end of file in** Actual Code: <?php session_start(); include("connection.php"); $sqlsettings = "SELECT * from admin"; $resultsettings = mysql_query($sqlsettings); $rowsettings = mysql_fetch_array($resultsettings); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title><?php echo $rowsettings['ScriptName']; ?> …

Member Avatar for blueguy777
0
306
Member Avatar for blueguy777

How to remove duplicate mobile numbers from input text box1 and print the result into text box2. Example mobile nos: 7795012345 7795012345 7795012345 7411312354 7411312354 9900454321 9900454321 9632554123 9632554123 output should be: 7795012345 7411312354 9900454321 9632554123 <?php $myarray = array(); $myarray['numbers']=$_POST['numbers']; foreach($myarray as $num){ $numbers=$num; } $unique = array_unique($numbers); $output=implode("<br …

Member Avatar for blueguy777
0
534
Member Avatar for blueguy777

The following table query is not executing properly, what is the correct syntax? $m_query = 'Insert into'.$job_id.'(`mobile`,`routeID`,`status`) values ('$mobile','$routeID','Sent')';

Member Avatar for pritaeas
0
242
Member Avatar for blueguy777

How to decode and store the following code values like city, zip, region etc into separate variables in PHP a:14:{s:4:"city";s:7:"Bijapur";s:3:"zip";s:6:"586101";s:3:"lat";d:16.83329963684082;s:2:"as";s:33:"AS9829 National Internet Backbone";s:5:"query";s:13:"59.99.192.232";s:6:"region";s:2:"KA";s:10:"regionName";s:9:"Karnataka";s:3:"org";s:4:"BSNL";s:3:"isp";s:4:"BSNL";s:7:"country";s:5:"India";s:11:"countryCode";s:2:"IN";s:3:"lon";d:75.69999694824219;s:6:"status";s:7:"success";s:8:"timezone";s:12:"Asia/Kolkata";}

Member Avatar for blueguy777
0
214
Member Avatar for blueguy777

PHP Code to create table. $create_q = 'CREATE TABLE IF NOT EXISTS `' . $job_id . '` ( `id` int(11) NOT NULL auto_increment, `mobile` bigint(20) NOT NULL, `routeID` int(11) NOT NULL, `status` varchar(20) NOT NULL default `Sent`, `handler` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) '; Mysql Error: You have …

Member Avatar for diafol
0
391
Member Avatar for blueguy777

xml output: <balance> <credits>39660</credits> </balance> how to fetch the xml output from url and store the credits i.e. 39660 into php variable. the above xml output is coming from following url http://www.xyz.com/check-balance.php?username=ssgent&password=ssgentr check-balance.php code: <?php require('dbcon.php'); include('encrypt.php'); include('functions.php'); $username = $_GET['username']; $password = $_GET['password']; $password = encrypt($password, 'riffre'); $url = …

Member Avatar for jkon
0
403
Member Avatar for blueguy777

How to search a string in table i.e. searchstring = "Gandhi Chowk" actual code: if(isset($_POST['companyId'])){ $companyId = $_POST['companyId']; } if(isset($_POST['RouteName'])){ $routeName = '%'.$_POST['routeName'].'%'; } if(isset($_POST['cityName'])){ $cityName = $_POST['cityName']; } // We Will prepare SQL Query $STM = $dbh->prepare("SELECT routeName FROM route WHERE routeName LIKE :route"); // bind paramenters, Named paramenters …

Member Avatar for blueguy777
0
238
Member Avatar for blueguy777

I am writting remider service script it should remind the due amount before 3 days in a particular month once in a year. My code is working fine for current month, but how to set reminder if current date is 2015-07-30 but the actual due date will be in next …

Member Avatar for diafol
0
194
Member Avatar for blueguy777

Unable to execute code, displaying blank page. $q = 'SELECT id,username,email,mobile FROM users WHERE email=:email OR mobile=:mobile'; $query = $dbh->prepare($q); $query->execute(array(':username' => $username, ':email' => $email,':mobile' => $mobile)); if($query->rowCount() == 0){ while($row = $query->fetch(PDO::FETCH_ASSOC)){ if($row[2] == $email) { if($row[3] == $mobile) { echo 'Mobile Number and Email are already registered …

Member Avatar for blueguy777
0
272
Member Avatar for blueguy777

the if condition is not executing and unable to print result, there is a blank page. <?php $url = $_SERVER['HTTP_HOST']; $url_length = strlen($url); if(substr($url, 0, 4 ) = 'www.') { $url_length = $url_length - 4; $url = substr($url, 4, $url_length); } echo $url_length.'<br />'.$url; ?>

Member Avatar for diafol
0
121
Member Avatar for blueguy777

Displaying blank page after inserting PHP code in between DIV tags, the code is as follows: <!DOCTYPE html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <meta charset="utf-8"> <meta name="viewport" content="width=device-width"> <title>Bulk Sms</title> <link rel="stylesheet" href="css/styles.css" type="text/css"> <link rel="stylesheet" href="css/responsive-nav.css"> <script src="js/responsive-nav.js"></script> </head> <body> <div class="inner"> <a href="index.php"> <img src="images/logo.png" alt="Bulk Sms" …

Member Avatar for blueguy777
0
645
Member Avatar for blueguy777

How to fix the following SQL error? 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Sent`, `handler` varchar(20) NOT NULL, PRIMARY KEY (`id`) )' at line 5 Code: $create_q = 'CREATE TABLE IF …

Member Avatar for andrevanzuydam
0
180
Member Avatar for blueguy777

Executing Code upto insert users: <?php require('session.php'); require('encrypt.php'); require('mail.php'); $username = $_POST['user_name']; $password = rand(10000, 99999); $name = $_POST['name']; $password = encrypt($password, 'ganesh'); $email = $_POST['email']; $terms = $_POST['terms']; $address = $_POST['address']; $mobile = $_POST['mobile']; $dob = $_POST['birth_year'] . '-' . $_POST['birth_month'] . '-' . $_POST['birth_day']; $ip = $_SERVER['REMOTE_ADDR']; $url …

Member Avatar for lps
0
235
Member Avatar for blueguy777

how to store json output into seperate PHP variables? {"msg":"success","msg_text":{"9912345678":"N"}}

Member Avatar for diafol
0
271
Member Avatar for blueguy777
Member Avatar for blueguy777

I got smpp class from [Click Here](http://www.phpclasses.org/package/1373-PHP-Sends-SMS-messages-via-an-SMPP-server.html) i am able to send sms to the single mobile number using SMPP connection but unable to send sms to multiple mobile numbers The code is as follows: <?php include_once('smppclass.php'); /* File: smppexample.php Implements: exmaple for smppclass.php::SMPPCLass() License: GNU Lesser Genercal Public License: …

Member Avatar for diafol
0
1K
Member Avatar for blueguy777

how to put `where clause variable $didno` in following code: $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM misscall WHERE did_no = ?"; $q = $pdo->query($sql); $mobile1 = array(); while ($mobi1 = $q->fetchColumn()) { $mobile1[] = $mobi1; } $mobile1list = join(",", $mobile1); Database::disconnect(); thanks in advance

Member Avatar for diafol
0
565
Member Avatar for blueguy777

the success message is not displaying after form submission, still it's displaying error message "Please enter a valid mobile number." it should display Success message. <?php function filterMobileno($field){ // Sanitize mobile number $field = filter_var($field, FILTER_SANITIZE_NUMBER_INT); // Validate mobile number if(filter_var($field, FILTER_VALIDATE_INT)){ return $field; }else{ return FALSE; } } // …

Member Avatar for diafol
0
298
Member Avatar for blueguy777

Array ( [0] => Array ( [sn] => 1 [mob_no] => 9602858989 [date] => 06-May-2015 [time] => 12:02:33 PM ) [1] => Array ( [sn] => 2 [mob_no] => 7795055128 [date] => 06-May-2015 [time] => 12:29:44 PM ) ) how to insert these array values in seperate database table fields?

Member Avatar for diafol
0
4K
Member Avatar for blueguy777

my json decode script throwing error i.e. Error : DATA FETCH My code: <?php $api_url = '{"msg":"SUCCESS","msg_text":"DATA FETCH","data":[{"sn":1,"mob_no":"9602858989","date":"06-May-2015","time":"12:02:33 PM"},{"sn":2,"mob_no":"7795055128","date":"06-May-2015","time":"12:29:44 PM"}]}'; $output = file_get_contents($api_url); if($output=="") { echo "No output received"; } else { $arr_output = json_decode($output, true); if(isset($arr_output['msg'])) { $msg = $arr_output['msg']; $msg_text = $arr_output['msg_text']; if($msg == "success") { if(isset($arr_output['data'])) { …

Member Avatar for blueguy777
0
313
Member Avatar for blueguy777

I am new for MySQL my tables structures are as follows Table: registration ---------------------------------- | cardNo | mainAgentId |subAgentId| ---------------------------------- | 100 | 1 | 4 | ----------------------------------- | 101 | 1 | 5 | ----------------------------------- | 103 | 2 | 6 | ----------------------------------- | 102 | 1 | 4 …

Member Avatar for 1stDAN
0
339
Member Avatar for blueguy777

Unable to execute the sql query, only dispaying blank page. <?php require('fpdf.php'); $today=date('d_m_Y'); $hostname = "localhost"; $database = "developer"; $username = "root"; $password = ""; $conn = mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($database, $conn); class PDF_result extends FPDF { function __construct ($orientation = 'P', $unit = 'pt', $format = 'Letter', …

Member Avatar for pritaeas
0
195
Member Avatar for blueguy777

i have a database table with fields mobno1 and mobno2, first i would like store all the values of field mobno1 into var1 and field mobno2 into var2 by using comma seperator and pdo. my code is as follows. $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT mobno1,mobno2 FROM custreg"; …

Member Avatar for blueguy777
0
453
Member Avatar for blueguy777

displaying blank page index.php // connection.php $server = "localhost"; $user = "root"; $password = ""; $dbName = "matrimony"; $conn = mysql_connect($server,$user,$password, $dbName) or die("There was a problem connecting to MySQL. Please try again later."); if (!@mysql_select_db($dbName, $conn)) { die ("There was a problem connecting to the database. Please try again …

Member Avatar for diafol
0
426
Member Avatar for blueguy777

unable to insert values into mysql table, only showing blank page. but after commenting mysql query code it's displaying echo $success part and not throwing any error message. code: if(!empty($_POST)) { // keep track validation errors $first_nameError = null; $last_nameError = null; $mobile_number1Error = null; $addressError = null; $magent_cityError = …

Member Avatar for blueguy777
0
309
Member Avatar for blueguy777

i've 3 files 1) search-installment.php 2) pay-installment.php 3) update_installment.php first step enter card no into search-installment.php posting value search_cardno to pay-installment.php then updating particular installment row clicking pay button in that row which opens form in modal window after pressing submit button it's updating data in table, but while refreshing …

Member Avatar for diafol
0
2K
Member Avatar for blueguy777

i've stored a line into string `$output='01/07/201521/08/201691754.0';` i want split the line as three different words & store into variables var1 var2 and var3. eg: var1=01/07/2015 var2=21/08/2016 var3=91754.0 hope someone will fix this issue.

Member Avatar for blueguy777
0
265
Member Avatar for blueguy777

i've two files one is send-data.php which contains html form and another one is receive-data.php, i am converting the form value as session value into second file and printing using echo. but it's not printing the output. //send-data.php <?php session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html …

Member Avatar for blueguy777
0
732