after i key-in the form, the function change the whole column with the same value for example if i put first name JOHN it will update whole column with JOHN <?php session_start(); require_once("connection.php"); if (isset($_POST['edit'])) { session_start(); $s=mysqli_query($con,"UPDATE user SET first_name ='" . $_POST['first_name'] . "'"); $row = mysqli_fetch_assoc($s); if ($s) { $_SESSION['user_name']=$_POST['user_name']; $_SESSION['first_name']=$_POST['first_name']; echo "<script type='text/javascript'>alert('Successful - Record Updated!'); window.location.href = 'profile.php';</script>"; } else { echo "<script type='text/javascript'>alert('Unsuccessful - ERROR!'); window.location.href = 'profile.php';</script>"; } } ?>

Member Avatar
Member Avatar
+0 forum 3

Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel data into GDV successfully, but i d'nt know how to save data in access db. Access db Name "MyInvoice" and table Name is 'InvoiceData'. Please help me to write correct code. Thank You. Imports System.Data.OleDb Imports System.Data.SqlClient Public Class MainForm Private Sub BtnImpExcelFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Member Avatar
Member Avatar
+0 forum 1

I am building my blog website and I want to make a page that will search info I have created in an excel spreadsheet and I want to include images for each item. Almost like an e-commerce or retail type of search but only for information but not just a slideshow... I mainly just needs to know what would be the easiest way to create this or if there is a WP Plugin I can use to create this. Perhaps it will be better if I tell you what I created first that I would like to allow people to …

Member Avatar
Member Avatar
+0 forum 5

What Is SVG And Why Do You Use It ???

Member Avatar
Member Avatar
+0 forum 3

This is the process I want to attain: 1. I have 4 buttons 2. Each 4 buttons have categories under it 3. When those categories is selected it shows list of datas 4. The datas are like powerpoint empty slides Can Someone give me some idea how to create relational database base on that idea? Flow of the Category: https://www.screencast.com/t/rYKS7zkXlKCD Best Regards

Member Avatar
Member Avatar
+0 forum 1

I have multiple HTML tables which is generated by PHP, Each table has a dynamic ID assigned to it What i would like is a total of the time in the "Worked Time" column for each table. [![enter image description here][1]][1] <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>Visitor Sign In Admin</title> <!-- Bootstrap Core CSS --> <link href="css/bootstrap.min.css" rel="stylesheet"> <!-- Custom CSS --> <!--link href="css/sb-admin.css" rel="stylesheet"> <!-- Morris Charts CSS --> <link href="css/plugins/morris.css" rel="stylesheet"> <!-- Custom Fonts --> <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"> <link rel="stylesheet" href="css/ionicons.min.css"> <!-- needs to …

Member Avatar
Member Avatar
+0 forum 1

I made sorting arrows for a table in illustrator and exported it out as an svg. I want to place them in a table head, and use css to style it. I will be using javascript (vannila) to swap classes to change the state of my icon. What is the best tag to use for svg in my case? below is sample of what I have now <thead> <tr> <th id="step">Step<img class="sort" src ="assets/sort-up-and-down-arrows-couple.svg"></th>

Member Avatar
Member Avatar
+1 forum 6

Hi, I want to display the avearage row as images. Is it possible? function reviews_average(){ $avgproduct_id = escape_string($_GET['id']); $avgquery = "SELECT avg(rating) as average_rating FROM reviews WHERE product_id = $avgproduct_id"; $avgresults = query($avgquery); confirm_query($avgquery); while($row = fetch_array($avgresults)){ $avgratings = **--THIS IS THE ONE I WANT TO DISPLAY AS IMAGES--** "{$row['average_rating']}"; echo $avgratings; } } This is the image `<img src='../public/images/star.png' height='20px' width='20px'/>`

Member Avatar
Member Avatar
+0 forum 2

I have magento shipping charge code : <?php ob_start(); // require_once(__DIR__ . '/app/Mage.php'); require_once('./../app/Mage.php'); umask(0); ini_set('display_errors',true); ini_set('memory_limit', '1024M'); Mage::app()->loadArea('frontend'); function getShippingEstimate($productId,$productQty,$countryId,$postcode ) { // $quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('default')->getId()); $quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('english')->getId()); $_product = Mage::getModel('catalog/product')->load($productId); $_product->getStockItem()->setUseConfigManageStock(false); $_product->getStockItem()->setManageStock(false); $quote->addProduct($_product, $productQty); $quote->getShippingAddress()->setCountryId($countryId)->setPostcode($postcode); $quote->getShippingAddress()->collectTotals(); $quote->getShippingAddress()->setCollectShippingRates(true); $quote->getShippingAddress()->collectShippingRates(); $_rates = $quote->getShippingAddress()->getShippingRatesCollection(); $shippingRates = array(); foreach ($_rates as $_rate): if($_rate->getPrice() > 0) { $shippingRates[] = array("Title" => $_rate->getMethodTitle(), "Price" => $_rate->getPrice()); } endforeach; return $shippingRates; } // echo "<pre>"; // product id, quantity, country, postcode // print_r(getShippingEstimate('14419','1',"IN","642001")); // echo "</pre>"; $results = getShippingEstimate('14419','1',"IN","642001"); // $results = getShippingEstimate('14419','1',"US","99501"); $count = -1; echo "<select>"; foreach ($results as $result): $count++; ?> …

Member Avatar
+0 forum 0

How can I create different types of joins in SAP HANA?

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm new to php (Yii Framework) and SQL (phpMyAdmin). I have problem to ask. ![Capture11.PNG](/attachments/large/4/1e4d9bf0c9a482a977d0ccb0fa19260e.PNG) Currently the three dropdown menu from different table and each have different id called aircraft_type, aircraft_sn and aircraft_reg. I want to use only one table called aircraft. In this table have all three details and only have one id. What I want to do is, when user choose value from aircraft type, the aircraft serial number and aircraft registration will also automatically fill. Calling value from table aircraft only. So far the code I have is: 1)_form.php (project form) <div class="panel panel-bordered panel-success"> <!-- …

Member Avatar
+0 forum 0

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original data and Result, where Original data is the original data sheet that is the result of the problem I need, when running the access issue, ask you to help me with the problem. http://www.mediafire.com/file/hkkw519bw2k3o9h/baitap_data2.xls/file

Member Avatar
+0 forum 0

I am working on a new project where I want to add candidates scores, there are different columns with HTML inputs that holds their performance scores at every stage, then I want to sum it up under the column TOTAL, get also the AVERAGE, and GRADE also on different columns I intend working with HTML, jQuery and Php in getting this done, any help please?

Member Avatar
Member Avatar
+0 forum 1

--Hi DaniWeb. I have been doying bulk data Uploads from Excel Sheet to MySql data base and hence thought that I may need the reverse of this process and so Export MySql Tables into Excel Format for Backup purposes (I also will be happy for a better suggestion for a better data backup solution if is any from this like saving them in .sql readable format and ready for upload Programatically as the way is there if I go to Php Myadmin). For now I just wanted to have something of the sort as I alredy have a mechanism for …

Member Avatar
Member Avatar
+1 forum 4

I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error '424' Object required". Sub extractDataFromTable() Dim IE As Object Dim theTable As Object Dim form As Variant, button As Variant Dim doc As Object Set IE = CreateObject("InternetExplorer.Application") ' navigate to a web page With IE .Visible = True .navigate ("http://www.sizemyups.com") End With While IE.ReadyState <> 4 DoEvents Wend Set …

Member Avatar
Member Avatar
+0 forum 10

[B]A Brief History[/B] I like to call this my instant call back feature. Basically I knew that you can send a text message to your phone through email. So I said to myself, "self, why not send yourself the text message through a web form through some type of sendmail script!". So that is how I came up with this little script several years ago, it has been my little secret ever since. I use it on my Real Estate Web Site program, where I build web sites for real estate agents. Basically I label "Instant Call Back Feature", to …

Member Avatar
Member Avatar
+0 forum 37

I want to print the username on jsp page"**success.jsp**" from "**home.jsp**" i have used **hibernate** to save data in table . "home.jsp" <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert title here</title> </head> <body> <center> <h1 ><font color="red">User-Interface</font></h1> <form action=loginServlet method="post"> <table border="1" bordercolor="red" style="border-style: dotted;" cellpadding="5px" cellspacing="10px"> <tr> <td>UserName:</td><td><input type="text" name="username"></td> </tr> <tr> <td>Password:</td><td><input type="password" name="password"></td> </tr> </table> <input type="submit" value="Log-In" > </form> New User?<a href="register.jsp"> Register Here</a> </center> </body> </html> success.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> …

Member Avatar
+0 forum 0

I am trying to select all rows from all tables in the database when a column equal a given name. I have like many tables with same structure and columns. I have written this piece of code but it throws an error. SELECT GROUP_CONCAT(qry SEPARATOR ' UNION ') INTO @sql FROM ( SELECT CONCAT('SELECT * FROM `',table_name,'` where Name like ''','sally%','''') qry FROM ( SELECT distinct table_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = 'db_customers' AND column_name LIKE 'Name' ) A ) B; PREPARE s FROM @sql; EXECUTE s; DEALLOCATE PREPARE s; This is the error I am getting. I am aware …

Member Avatar
Member Avatar
+0 forum 3

Hey everyone i am just asking for a little bit off help if thats fine how can i make 11 fetch scripts into 1 script please [database ](https://i.imgur.com/BTGQF1P.png) i like to make this menu to display the coins i know you can do it but i dont know how since am not pro <ul class="nav nav-pills mb-3" id="pills-tab" role="tablist"> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" data-toggle="dropdown" href="#" role="button" aria-haspopup="true" aria-expanded="false">Pick a coin</a> <div class="dropdown-menu"> <a class="dropdown-item" id="pills-btc-tab" href="#pills-btc" role="tab" data-toggle="pill" aria-controls="pills-btc"><img src="https://i.imgur.com/h2bZxBg.png" width="23" height="23"> Bitcoin</a> </div> </ul> fetch from mysqli i have btc here but i like to get every …

Member Avatar
+0 forum 0

How can I find the parent tr from the closest child tr e.g. from the second child tr, how can I get to the first parent tr? Below is the html table: <table> <tr class="menu"> <td><input type='text' class='parent' value='First Parent'></td> </tr> <tr class="submenu"> <td><input type='text' class='child' value='First Child'> </td> </tr> <tr class="submenu"> <td><input type='text' class='child' value='Second Child'> </td> </tr> <tr class="menu"> <td><input type='text' class='parent' value='Second Parent'></td> </tr> <tr class="submenu"> <td><input type='text' class='child' value='First Child'> </td> </tr> </table> I have tried the following JQuery code: $(this).closest('tr.submenu').closest('tr.menu').find('.parent').val(); $(this).closest('tr.submenu').parent('tr.menu').find('.parent').val(); $(this).closest('tr.menu').find('.parent').val(); $(this).closest('tr.submenu').prevUntil('tr.menu').find('.parent').val(); $(this).closest('tr.submenu').parentsUntil('tr.menu').find('.parent').val(); $(this).closest('tr.submenu').parents(':first-child').find('.parent').val(); All attempts have failed. How can I get the parent …

Member Avatar
Member Avatar
+1 forum 3

I have two tables like below tb1 Date Cr Dr 2018-04-29 100 50 2018-04-30 0 150 2018-05-01 250 100 2018-05-02 150 100 2018-06-10 300 250 2018-06-11 0 50 tb2 Date Cr 2018-05-01 350 2018-05-02 250 2018-06-10 300 2018-06-11 100 2018-06-15 200 2018-06-18 100 I need the following Result Apr May Jun Cr 100 1000 1000 Dr 200 200 300 Basically I have to add the respective Cr columns from both table and get the Dr from tb1 for the corresponding dates and create a monthly report. I have tried SELECT Date(tb1.Date) as sDate, SUM(tb1.Cr+tb2.Cr) sumcr, SUM(tb1.Dr) sumdr FROM tb1,tb1 WHERE …

Member Avatar
Member Avatar
+0 forum 7

Hey guys. So this should be a pretty simple question (but doesn't appear to be) that I'm hoping some of the database wizards out there can help me with. I'm not too long outta university with a BSC in Computing, I didn't get a full classification due to the fact that yup I failed the Data Management module. I was never very good with normalization and splitting a database down into the correct amount of tables and relationships. Anyway I've been asked to produce a simple web site (first paid project) for a fish and chips take away down the …

Member Avatar
Member Avatar
+0 forum 5

Hi I am struggling how to list all the permissions and with checkboxes. if anyone can help me with it this is the code echo "<table cellpadding='0' cellspacing='0' width='100%' class='table table-bordered'>"; echo "<tr>"; echo "<th>PERMISSION</th>"; foreach($user_groups->rows as $row) { echo "<th class='checkbox'>".$row['title']."</th>"; } echo "</tr>"; $users_permission_query = $this->db->query("SELECT * FROM users_permission"); foreach($users_permission_query->rows as $row) { $group_permissions_rows = json_decode($row['permission'], TRUE); echo "<tr>"; echo "<td>".$row['module']."<br />"; foreach($group_permissions_rows as $key => $value) { echo "{$key}<br>"; } echo "</td>"; echo "<td>"; echo "<table cellpadding='0' cellspacing='0' width='100%'>"; for($i=0; $i < count($group_permissions_rows); $i++) { foreach($group_permissions_rows as $key => $value) { echo "<tr>"; echo "<td><input type='checkbox' name='permissions[" …

Member Avatar
Member Avatar
+0 forum 4

Hello, i success display all the record when the button clicked <html> <head lang="en"> <meta charset="UTF-8"> <link type="text/css" rel="stylesheet" href="bootstrap-3.2.0-dist\css\bootstrap.css"> <!--css file link in bootstrap folder--> <title>View Users</title> </head> <style> .login-panel { margin-top: 150px; } .table { margin-top: 50px; } </style> <body> <div class="table-scrol"> <h1 align="center">All the Users</h1> <div class="table-responsive"><!--this is used for responsive display in mobile and other devices--> <table class="table table-bordered table-hover table-striped" style="table-layout: fixed"> <thead> <tr> <th>kepada</th> <th>nama</th> <th>jawatan</th> </tr> </thead> <?php include('db_connection.php'); $view_users_query="select * from permohonan";//select query for viewing users. $run=mysqli_query($dbcon,$view_users_query);//here run the sql query. while($row=mysqli_fetch_array($run))//while look to fetch the result and store in a array …

Member Avatar
Member Avatar
+0 forum 2

I have 2 user which is officer and admin. The officer fill in the form. Admin will open the form, see details of officer and fill his detail. The problem is i success output all the information fill by the officer but when the admin fill the data not in the same row as officer data in database. Here my code: lihatpemohon.php: <?php session_start(); include('db_connection.php'); $view_id=$_GET['get']; $view_query="SELECT * FROM permohonan WHERE id='$view_id'"; $run=mysqli_query($dbcon,$view_query); while($row=mysqli_fetch_array($run)) { echo"Kepada :<input type='text' name='kepada' value='".$row['kepada']."' /><br><br>"; echo'<br>Tuan,<br> <b><h4>MEMOHON KEBENARAN MENINGGALKAN PEJABAT OLEH PEGAWAI/KAKITANGAN BAHAGIAN TEKNOLOGI PENDIDIKAN NEGERI PERAK DAN RANGKAIAN</h4></b><br>'; echo"Saya : <input type='text' name='nama' …

Member Avatar
Member Avatar
+0 forum 2

I have two tables. MODELS and AUTOMOBILES. And procedure which export all models with name that user inputs and their price(stored in AUTOMOBILES). create or REPLACE procedure modelzz( VAR_MODEL IN MODELS.NAME_MODEL%TYPE, VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE ) as begin SELECT a.A_PRICE INTO VAR_PRICE FROM AUTOMOBILES a join MODELS m on a.MODELS_ID_MODEL=m.ID_MODEL where m.NAME_MODEL=VAR_MODEl; dbms_output.put_line(VAR_MODEL||'''s price is : '||VAR_PRICE); procedure start: var v_modelzz varchar2; exec modelzz('&model_name',:v_modelzz); The problem is I want to export all records for certain model. Their's more than one, one model can have two or more records. Here's the error: **exact fetch returns more than requested number of rows**

Member Avatar
Member Avatar
+0 forum 5

Hi I am working on a payroll project and I am coding with php,html,js and mysql on xampp server. I have a salary sheet code which needs to be printed in pdf format for each employee with their names as the pdf filename. on running the php page the js code triggers automatically and generates pdf files but the problem is the salary data of the first employee is printed on every payslip but The filename changes with every pdf. for example : 1st emp name is rajesh rao, 2nd emp name is a.ghosh. now when I print the sheets, …

Member Avatar
Member Avatar
+0 forum 4

Hello, I'm not able to display the whole select result information in the table and I have no idea what I am doing wrong, I would appreciate your help so much. So here's my code: <?php $DBServer = 'localhost'; $DBUser = 'root'; $DBPass = ''; $DBName = 'world'; $conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName); $sql = "SELECT Id, Name, CountryCode, District, Population FROM city WHERE CountryCode = 'USA'"; $result = $conn->query($sql); if($result->num_rows > 0){ echo "<table border='1'> <tr> <th>Id</th> <th>Name</th> <th>Code</th> <th>District</th> <th>Population</th> </tr>"; while($row = mysqli_fetch_array($result)){ echo" <tr> <td>".$row['Id'] ."</td> <td>".$row['Name'] ."</td> <td>".$row['CountryCode'] ."</td> <td>".$row['District'] ."</td> <td>".$row['Population'] ."</td> …

Member Avatar
Member Avatar
+0 forum 3

<div class="content" style="margin-left:17%;"> <div class="box box-warning" > <div class="box-header with-border" style="margin-left:20%;"> <h3 class="box-title">Add Package</h3> </div><!-- /.box-header --> <div class="box-body" style="margin-left:9%;"> <div class="row"> <div class="col-md-10" > <form action="" method="post" accept-charset="utf-8"> <div class="row" > <div class="col-md-6"> <div class="form-group"> <label for="varchar">Name </label> <input type="text" class="form-control" name="name" id="name" placeholder="Name" value=""> </div> </div> <div class="col-md-6"> <div class="form-group"> <label for="enum">Status </label> <select name="status" class="form-control"> <option value="active">Active</option> <option value="inactive">Inactive</option> </select> </div> </div> </div> <div class="form-group" style="margin-left:6%;" > <label for="varchar">Tests </label> <div class="table"> <table class='table table-responsive table-hover' style='margin-bottom: 10px'> </div> <?php $conn=mysqli_connect("localhost","root","","laboratory") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); $query="SELECT * FROM test"; $result=mysqli_query($conn,$query); if ($result) { while ($record=mysqli_fetch_array($result)) { …

Member Avatar
Member Avatar
+0 forum 1

hi everyone hope you are all well... i am login with userid and password and i want to display there username after login from my oracle database how?

Member Avatar
Member Avatar
+0 forum 3

The End.