Nicolas247's Posts
Nairaland Forum › Nicolas247's Profile › Nicolas247's Posts
1 2 3 4 5 6 7 8 9 10 (of 10 pages)
Pls @ op should stop this immediately I have been using paylater for a while now and I can tell you they are real and have standards too. They are very quick . My current credit worth with them is up to 48k when you meet the requirements you will get the loan Asap and they ate when you default |
Hello Please if you are vast with PHP, javascript and familiar with codeigniter and can translate web app that is almost ready to mobile Please call or chat me up on 08167359739 Contact only if you have time for this project |
Order today Distributors wanted nation wide |
my final Code <?php require_once('config.php'); error_reporting(1); // Pull all the required data from the three tables into one 2 level array $sql = 'select * from january UNION ALL select * from february UNION ALL select * from march UNION ALL select * from april UNION ALL select * from may UNION ALL select * from june UNION ALL select * from july UNION ALL select * from august UNION ALL select * from september UNION ALL select * from october UNION ALL select * from november UNION ALL select * from december'; $query = $pdo->prepare($sql); $query->execute(); $row = $query->fetchAll(); // Pull a list of all the staffId from one of the table assuming we have the same number of IDs in all tables // I added UNION to the select statement because of some record not in all of the table and that works very fine $sql1 = 'select staffId, name FROM january UNION select staffId, name FROM february UNION select staffId, name FROM march UNION select staffId, name FROM april UNION select staffId, name FROM may UNION select staffId, name FROM june UNION select staffId, name FROM july UNION select staffId, name FROM august UNION select staffId, name FROM september UNION select staffId, name FROM october UNION select staffId, name FROM november UNION select staffId, name FROM december'; $query = $pdo->prepare($sql1); $query->execute(); $staffIdList = $query->fetchAll(); // start a loop to loop through the list of the staffIds foreach ($staffIdList as $staffIdList) { //initialize the variable that will store the sum of each column $loanamt = 0; $loan_int = 0; $saving = 0; $total = 0; //start a loop to loop through the 2 level array foreach ($row as $key => $value){ // use an IF statement to select each of the staffIds and corresponding columns (loan_amt etc) and add them together as the loop runs if ($row[$key]['staffId']== $staffIdList['staffId']){ $loanamt += $row[$key]['loan_amt']; $loan_int += $row[$key]['loan_int']; $saving += $row[$key]['saving_ded']; $total += $row[$key]['total_ded']; } } // print out the values after each staffId iteration //echo $staffIdList['staffId']." ".$loanamt." ".$saving." ".$total."</br>"; echo "<tr>"; echo "<td>".$staffIdList['staffId']."</td>"; echo "<td>".$staffIdList['name']."</td>"; echo "<td>".$loanamt += $row[$key]['loan_amt']."</td>"; echo "<td>".$loan_int += $row[$key]['loan_int']."</td>"; echo "<td>".$saving += $row[$key]['saving_ded']."</td>"; echo "<td>".$total += $row[$key]['total_ded']."</td>"; echo "</tr>"; } ?> |
<?php require_once('config.php'); error_reporting(1); // Pull all the required data from the three tables into one 2 level array $sql = 'select * from january UNION ALL select * from february UNION ALL select * from march UNION ALL select * from april UNION ALL select * from may UNION ALL select * from june UNION ALL select * from july UNION ALL select * from august UNION ALL select * from september UNION ALL select * from october UNION ALL select * from november UNION ALL select * from december'; $query = $pdo->prepare($sql); $query->execute(); $row = $query->fetchAll(); // Pull a list of all the memberId from one of the table assuming we have the same number of IDs in all tables // I added UNION to the select statement because of some record not in all of the table and that works very fine $sql1 = 'select memberId, name FROM january UNION select memberId, name FROM february UNION select memberId, name FROM march UNION select memberId, name FROM april UNION select memberId, name FROM may UNION select memberId, name FROM june UNION select memberId, name FROM july UNION select memberId, name FROM august UNION select memberId, name FROM september UNION select memberId, name FROM october UNION select memberId, name FROM november UNION select memberId, name FROM december'; $query = $pdo->prepare($sql1); $query->execute(); $memberIdList = $query->fetchAll(); // start a loop to loop through the list of the memberIds foreach ($memberIdList as $memberIdList) { //initialize the variable that will store the sum of each column $loanamt = 0; $loan_int = 0; $saving = 0; $total = 0; //start a loop to loop through the 2 level array foreach ($row as $key => $value){ // use an IF statement to select each of the memberIds and corresponding columns (loan_amt etc) and add them together as the loop runs if ($row[$key]['memberId']== $memberIdList['memberId']){ $loanamt += $row[$key]['loan_amt']; $loan_int += $row[$key]['loan_int']; $saving += $row[$key]['saving_ded']; $total += $row[$key]['total_ded']; } } // print out the values after each memberId iteration //echo $memberIdList['memberId']." ".$loanamt." ".$saving." ".$total."</br>"; echo "<tr>"; echo "<td>".$memberIdList['memberId']."</td>"; echo "<td>".$memberIdList['name']."</td>"; echo "<td>".$loanamt += $row[$key]['loan_amt']."</td>"; echo "<td>".$loan_int += $row[$key]['loan_int']."</td>"; echo "<td>".$saving += $row[$key]['saving_ded']."</td>"; echo "<td>".$total += $row[$key]['total_ded']."</td>"; echo "</tr>"; } ?> |
Beautiful. it work perfect thanks real good. i made some little adjustment i will post my final code below benjibabs: |
Lovely Turban Fascinator designs for all ages. Kindly place a call to order on this mobile 08034282695, 08167359739. We also deliver nation wide It suit many occasions and groups You can order for Church choir Wedding bridal train All age group Etc.
|
You are the bomb thanks so much problem solved though i am finding it difficult to add a column with staff's name. benjibabs: |
Thanks but i still got this error Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12 Singlecliq: |
Singlecliq: |
lol... this app was my first app and the company are still using it. i will definitely rewrite it but i need this solution in the mean time yorex2011: |
not at all LegendsCoded: |
Softhands:i have checked stack overflow i dont have reference i can relate with. i don tire |
LegendsCoded:it is not giving error but just that it is returning wrong value |
tollyboy5:It is PHP boss I have been on this for a week now it is returning wrong values |
people just they look dey pass? |
help you boy o! |
This is my Code but i am clearly hooked <?php require 'config.php'; $january=mysqli_query($con,'SELECT staffid, saving_ded, total_ded FROM january UNION ALL SELECT staffid, saving_ded, total_ded FROM february UNION ALL SELECT staffid, saving_ded, total_ded FROM march '); while($row1=mysqli_fetch_array($january)) { $jan1=$row1['staffid']; $jan2=$row1['saving_ded']; $jan3=$row1['total_ded']; ?> <tr> <td><?php echo $jan1 ?></td> <td><?php echo $jan2 ?></td> <td><?php echo $jan3 ?></td> </tr> <?php } ?> Please i really need help i am stock for days now Table1 StaffID loan_amt Saving_ded total_ded 122 10 15 25 235 30 20 50 Table2 StaffID loan_amt Saving_ded total_ded 122 10 15 25 235 30 20 50 Table3 StaffID loan_amt Saving_ded total_ded 122 10 15 25 235 30 20 50 >>>>>>>>>>>>>>>>>>>>>>>>>>>>> This is the result i will like to archive StaffID loan_amt Saving_ded total_ded 122 20 30 50 235 60 40 100 |
cc77:where are you sir? we can do weigh bill |
Hi every one Uk used galaxy s5 for sale very neat 16gb black back cover and silver side if interested pls call me 08167359739 Location Lagos
|
Hi I feel i should share this. less than 3 months after my wife finished her NYSC. she is already making fascinators for friends, neighbour, family and having clients everyday. she is already making some decent money from production and training. If you are interested in learning or want to make a purchase feel free to get in touch 08118242156 |
Hello fellow dealers Brand New Audi Q7 or Q5 Urgently needed this morning. Please if you have or know anywhere we can get I have a ready buyer, a Chinese who is ready to pay this morning feel free to call me up on 08167359739 |
Clean Nigeria Used Mitsubishi L300 for urgent sale. the bus is in good working condition and available for inspection. Price : N1.5M (Negotiable) If interested Please call: 08023910935
|
Blackberry Z10 Hi, the phone is without a fault. the screen is still very need though the back cover is not. Any interested buyer should call me Price N15,000 Call 08167359739
|
foldl:note thanks the problem was solved i will share the solution soon thanks |
FincoApps:Here is the where the action pointing to <form class="login-form" action="form_processor.php?action=memberlogin" method="post"> |
lekropasky:Thanks for you contribution here is cut out of the form to submit <!-- BEGIN LOGIN FORM --> <form class="login-form" action="form_processor.php?action=memberlogin" method="post"> <h3 class="form-title">Sign In</h3> <div class="alert alert-danger display-hide"> <button class="close" data-close="alert"></button> <span> Enter any username and password. </span> </div> <div class="form-group"> <!--ie8, ie9 does not support html5 placeholder, so we just show field title for that--> <label class="control-label visible-ie8 visible-ie9">Username</label> <input class="form-control form-control-solid placeholder-no-fix" type="text" autocomplete="off" placeholder="Username" name="memberId"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Password</label> <input class="form-control form-control-solid placeholder-no-fix" type="password" autocomplete="off" placeholder="Password" name="pwd"/> </div> <div class="form-actions"> <button type="submit" class="btn btn-success uppercase">Login</button> |
Why is everyone just looking and pass |
Please some should help me look at my code I am trying to fetch a set data from inside table . when ever i submit the require value, i get this error message "Notice: Undefined index: memberId in C:\xamppp\htdocs\ibank\toinclude.php on line 8 No records matching your query were found." Here is my code <?php $memberId = $_POST['memberId']; /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'root' with no password) */ $link = mysqli_connect("localhost", "root", "", "ibank" ;// Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Attempt select query execution $sql = "SELECT * FROM january WHERE memberId='$memberId'"; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table>"; echo "<tr>"; echo "<th>date</th>"; echo "<th>description</th>"; echo "<th>credit</th>"; echo "<th>debit</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['date'] . "</td>"; echo "<td>" . $row['description'] . "</td>"; echo "<td>" . $row['credit'] . "</td>"; echo "<td>" . $row['debit'] . "</td>"; echo "</tr>"; } echo "</table>"; // Close result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?> Here is my form below <!DOCTYPE html> <!-- Template Name: Metronic - Responsive Admin Dashboard Template build with Twitter Bootstrap 3.3.4 Version: 3.3.0 Author: KeenThemes Website: http://www.keenthemes.com/ Contact: support@keenthemes.com Follow: www.twitter.com/keenthemes Like: www.facebook.com/keenthemes Purchase: http://themeforest.net/item/metronic-responsive-admin-dashboard-template/4021469?ref=keenthemes License: You must have a valid license purchased only from themeforest(the above link) in order to legally use the theme for your project. --> <!--[if IE 8]> <html lang="en" class="ie8 no-js"> <![endif]--> <!--[if IE 9]> <html lang="en" class="ie9 no-js"> <![endif]--> <!--[if !IE]><!--> <html lang="en"> <!--<![endif]--> <!-- BEGIN HEAD --> <head> <meta charset="utf-8"/> <title>Metronic | Login Options - Login Form 1</title> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta content="width=device-width, initial-scale=1.0" name="viewport"/> <meta http-equiv="Content-type" content="text/html; charset=utf-8"> <meta content="" name="description"/> <meta content="" name="author"/> <!-- BEGIN GLOBAL MANDATORY STYLES --> <link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700&subset=all" rel="stylesheet" type="text/css"/> <link href="assets/global/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/> <link href="assets/global/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css"/> <link href="assets/global/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/> <link href="assets/global/plugins/uniform/css/uniform.default.css" rel="stylesheet" type="text/css"/> <!-- END GLOBAL MANDATORY STYLES --> <!-- BEGIN PAGE LEVEL STYLES --> <link href="assets/admin/pages/css/login.css" rel="stylesheet" type="text/css"/> <!-- END PAGE LEVEL SCRIPTS --> <!-- BEGIN THEME STYLES --> <link href="assets/global/css/components.css" id="style_components" rel="stylesheet" type="text/css"/> <link href="assets/global/css/plugins.css" rel="stylesheet" type="text/css"/> <link href="assets/admin/layout/css/layout.css" rel="stylesheet" type="text/css"/> <link href="assets/admin/layout/css/themes/darkblue.css" rel="stylesheet" type="text/css" id="style_color"/> <link href="assets/admin/layout/css/custom.css" rel="stylesheet" type="text/css"/> <!-- END THEME STYLES --> <link rel="shortcut icon" href="favicon.ico"/> </head> <!-- END HEAD --> <!-- BEGIN BODY --> <body class="login"> <!-- BEGIN SIDEBAR TOGGLER BUTTON --> <div class="menu-toggler sidebar-toggler"> </div> <!-- END SIDEBAR TOGGLER BUTTON --> <!-- BEGIN LOGO --> <div class="logo"> <a href="index.html"> <img src="assets/admin/layout/img/logo-big.png" alt=""/> </a> </div> <!-- END LOGO --> <!-- BEGIN LOGIN --> <div class="content"> <!-- BEGIN LOGIN FORM --> <form class="login-form" action="form_processor.php?action=memberlogin" method="post"> <h3 class="form-title">Sign In</h3> <div class="alert alert-danger display-hide"> <button class="close" data-close="alert"></button> <span> Enter any username and password. </span> </div> <div class="form-group"> <!--ie8, ie9 does not support html5 placeholder, so we just show field title for that--> <label class="control-label visible-ie8 visible-ie9">Username</label> <input class="form-control form-control-solid placeholder-no-fix" type="text" autocomplete="off" placeholder="Username" name="memberId"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Password</label> <input class="form-control form-control-solid placeholder-no-fix" type="password" autocomplete="off" placeholder="Password" name="pwd"/> </div> <div class="form-actions"> <button type="submit" class="btn btn-success uppercase">Login</button> <label class="rememberme check"> <input type="checkbox" name="remember" value="1"/>Remember </label> <a href="javascript:;" id="forget-password" class="forget-password">Forgot Password?</a> </div> <div class="login-options"> <h4>Or login with</h4> <ul class="social-icons"> <li> <a class="social-icon-color facebook" data-original-title="facebook" href="javascript:;"></a> </li> <li> <a class="social-icon-color twitter" data-original-title="Twitter" href="javascript:;"></a> </li> <li> <a class="social-icon-color googleplus" data-original-title="Goole Plus" href="javascript:;"></a> </li> <li> <a class="social-icon-color linkedin" data-original-title="Linkedin" href="javascript:;"></a> </li> </ul> </div> <div class="create-account"> <p> <a href="javascript:;" id="register-btn" class="uppercase">Create an account</a> </p> </div> </form> <!-- END LOGIN FORM --> <!-- BEGIN FORGOT PASSWORD FORM --> <form class="forget-form" action="index.html" method="post"> <h3>Forget Password ?</h3> <p> Enter your e-mail address below to reset your password. </p> <div class="form-group"> <input class="form-control placeholder-no-fix" type="text" autocomplete="off" placeholder="Email" name="email"/> </div> <div class="form-actions"> <button type="button" id="back-btn" class="btn btn-default">Back</button> <button type="submit" class="btn btn-success uppercase pull-right">Submit</button> </div> </form> <!-- END FORGOT PASSWORD FORM --> <!-- BEGIN REGISTRATION FORM --> <form class="register-form" action="form_processor.php?action=january" method="post"> <h3>Create an account</h3> <p class="hint"> Enter your personal details below: </p> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Username</label> <input class="form-control placeholder-no-fix" type="text" autocomplete="off" placeholder="Username" name="memberId"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Password</label> <input class="form-control placeholder-no-fix" type="password" autocomplete="off" id="register_password" placeholder="Password" name="pwd"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Full Name</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Name" name="fullname"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Sex</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Sex" name="sex"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Age</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Age" name="age"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Contact Address</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Contact Address" name="address"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">City/Town</label> <input class="form-control placeholder-no-fix" type="text" placeholder="City/Town" name="city"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">State</label> <input class="form-control placeholder-no-fix" type="text" placeholder="State" name="state"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Country</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Country" name="country"/> </div> <div class="form-group"> <label class="control-label visible-ie8 visible-ie9">Zip Code</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Zip Code" name="zipcode"/> </div> <div class="form-group"> <!--ie8, ie9 does not support html5 placeholder, so we just show field title for that--> <label class="control-label visible-ie8 visible-ie9">E-mail</label> <input class="form-control placeholder-no-fix" type="text" placeholder="Email" name="email"/> </div> <div class="form-group"> <!--ie8, ie9 does not support html5 placeholder, so we just show field title for that--> <input class="form-control placeholder-no-fix" type="text" placeholder="vdvdv" name="secretNo"/> </div> <div class="form-group margin-top-20 margin-bottom-20"> <label class="check"> <input type="checkbox" name="tnc"/> I agree to the <a href="javascript:;"> Terms of Service </a> & <a href="javascript:;"> Privacy Policy </a> </label> <div id="register_tnc_error"> </div> </div> <div class="form-actions"> <button type="button" id="register-back-btn" class="btn btn-default">Back</button> <button type="submit" id="register-submit-btn" class="btn btn-success uppercase pull-right">Submit</button> </div> </form> <!-- END REGISTRATION FORM --> </div> <div class="copyright"> 2016 © All right Reserved. </div> <!-- END LOGIN --> <!-- BEGIN JAVASCRIPTS(Load javascripts at bottom, this will reduce page load time) --> <!-- BEGIN CORE PLUGINS --> <!--[if lt IE 9]> <script src="assets/global/plugins/respond.min.js"></script> <script src="assets/global/plugins/excanvas.min.js"></script> <![endif]--> <script src="assets/global/plugins/jquery.min.js" type="text/javascript"></script> <script src="assets/global/plugins/jquery-migrate.min.js" type="text/javascript"></script> <script src="assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script> <script src="assets/global/plugins/jquery.blockui.min.js" type="text/javascript"></script> <script src="assets/global/plugins/jquery.cokie.min.js" type="text/javascript"></script> <script src="assets/global/plugins/uniform/jquery.uniform.min.js" type="text/javascript"></script> <!-- END CORE PLUGINS --> <!-- BEGIN PAGE LEVEL PLUGINS --> <script src="assets/global/plugins/jquery-validation/js/jquery.validate.min.js" type="text/javascript"></script> <!-- END PAGE LEVEL PLUGINS --> <!-- BEGIN PAGE LEVEL SCRIPTS --> <script src="assets/global/scripts/metronic.js" type="text/javascript"></script> <script src="assets/admin/layout/scripts/layout.js" type="text/javascript"></script> <script src="assets/admin/layout/scripts/demo.js" type="text/javascript"></script> <script src="assets/admin/pages/scripts/login.js" type="text/javascript"></script> <!-- END PAGE LEVEL SCRIPTS --> <script> jQuery(document).ready(function() { Metronic.init(); // init metronic core components Layout.init(); // init current layout Login.init(); Demo.init(); }); </script> <!-- END JAVASCRIPTS --> </body> <!-- END BODY --> </html> |
fairview:Over 120 x 60 (A plot ) The price is N25M asking |


;