How to use pivoting WIth join of 3 tables without Aggregate function within it

Member Avatar
Member Avatar
+0 forum 1

Hello Guys, I am new in this forum. I want to ask a quetion, can anyone tell me, how to learn web design and development? Any idea or any website refrence.

Member Avatar
Member Avatar
+0 forum 1

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 2

I do not have a clue as to what the problem is with this code. I am running php 7.0. This was an old form I used long ago, decided to upgrade it for random use. It works on php 5.0 but not in 7. I have run it through many php checks and not a problem is found. Does anyone have the answer for me? I would greatly appreciate it. No Errors shown just the white age of death. <?php include_once('jcart.php'); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); // Connects to your Database mysqli_connect("localhost", "dnk", "here1") or die(mysqli_error()); mysqli_select_db("dnnnk") or die(mysqli_error()); …

Member Avatar
Member Avatar
+0 forum 3

Please help me to creating code for my images from form to public folder and retrieve it on my view trough database This is my form: <form = method="post" action="/saveform1" > {{csrf_field()}} <input type="text" class="form-control" name="yourname" placeholder="Enter your Name"> </br> <label> Your Email </label> <input class="form-control" type="email" name="email" /> </br> <label> Your Tp Number </label> <input class="form-control" type="number" name="tp" /> </br> <label> Subject </label> <input class="form-control" type="text" name="subject" /> </br> <label for="exampleFormControlTextarea1">Your Message</label> <textarea class="form-control" id="exampleFormControlTextarea1" rows="3" name="message">

Member Avatar
Member Avatar
+0 forum 1

Hello. I am having a problem here. So I have this slider which display the pictures with status "1" which means displayed. Here comes the problem, when there's no pictures with the status AKA "0" (not-displayed), the default image doesn't show up. Here's the script. <div class="carousel-inner"> <?php $no=1; $default=$this->db->get_where("penyaluran", array("status" => "1"))->result(); $g='image.jpg'; $n=''; foreach($default as $pict) { if ($g=$pict->foto_dokumentasi) { $n=$pict->nama_penyaluran; } else { $g='image.jpg'; $n= ''; } if ($no == 1) { $status = 'active'; } else { $status = ''; } ?> <div class="carousel-item <?php echo $status; ?>"> <img src="<?php echo base_url('uploads/'.$g); ?>" alt="" style="max-height: 300px; …

Member Avatar
+0 forum 0

Hi, I'm wondering if it's possible to have a desktop app with a database online? Can you give me an example? :P

Member Avatar
Member Avatar
+0 forum 6

Hi everyone! i have a question that, if there are two radio buttons Male and Female, if some select male,this value will be store into database, but if he select again another value which is female,then how the first value(Male) will be replace by second value (Female) in the database using **PHP and Ajax**, please give me an easy solution

Member Avatar
Member Avatar
+0 forum 2

So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect a lot of people are going to my website, like more than 20 people in a day, but here is the question or discussion? how and where do I begin learn about databases, I don't really care what language I am going to use, like sql or php, is sql …

Member Avatar
Member Avatar
+0 forum 6

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

Hi all, I have a new project with vb.net. I need to always connect with older program that run in foxpro, i need to get dbf table and convert it to mysql table. Can anyone help me ?

Member Avatar
Member Avatar
+0 forum 2

For this particular sub I type the customer id in a text box and then click the button, then I'm trying to get the relative information pertaining to that id. Not sure what I am doing wrong. Comes back with an error message of system.data.sqlclient.sqlexception Recursive common table expression '[customers]' does not contain a top-level UNION ALL operator. Private Sub FillByCustomerIDToolStripButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles FillByCustomerIDToolStripButton.Click Try Dim customerID As Integer = CInt(CustomerIDToolStripTxtBox.Text) ' LOAD THE CUSTOMERS TABLE WITH THE SELECTED CUSTOMER. Dim id = Me.CustomersTableAdapter.FillByCustomerID(Me.DatabaseDataSet.customers, customerID) If Me.DatabaseDataSet.customers.Count > 0 Then For Each row As …

Member Avatar
Member Avatar
+0 forum 2

How do I process the xamarin forms that connect to SQL Server and export data to the listView ? I'm looking for this simple example. What do I find on google ?

Member Avatar
Member Avatar
+1 forum 2

So, I created a program in VB.Net with Windows Form and I want the user to be able to create a new user, limited to 5 user accounts only. I also want to know if it's possible to change password and delete user accounts. Can I make it so that each User has their own MS Access database? For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1. Here is the log-in form that I created that can only have one user account: Public Class Form3 Private Sub Register_Click(sender …

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm creating a project using VB.Net Windows Form and I want to create a Log-In form that can **Add New User (Limited to 5 User Accounts), Delete User Account, and Change Password**. I want to use Microsoft Access with it. What are the codes I should use to create it? I also want each User to have their own database. For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1. I am a beginner and I only see MySQL tutorials on YouTube but I don't have MySQL. On …

Member Avatar
Member Avatar
+0 forum 2

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

Hello everyone, [Dadroit](https://viewer.dadroit.com) is a tool that threats JSON as a Data format, not a plain text. It provides you quick outline view with the help of tree representation of JSON Data from root to last nodes. You can browse and query JSON like an enterprise DBMS. * 10X faster than VSCode in launch * 9X less RAM usage than Sublime * 21X faster than NPP++ in search Please give it a look and let me know what you think about it.

Member Avatar
Member Avatar
+0 forum 2

I have created one table in access with field site,dealer and D_date my data is like as follow site dealer d_date delhi asian 23-10-11 delhi led 24-10-18 so on....... now i want haveing two combobox list of site and dealer in form when i press show button in form i need if todays date is mor then 3 years of d_date then show msg. " out of warranty.... i am using access 207 and vb net basic 2008

Member Avatar
+0 forum 0

If an index file is missing in a folder, apache uses its own file/files to list the contents of the folder. Since I don’t want to create an index file in every folder in the file systems, I wonder where I can find the file/files that apache uses when there is no index file.

Member Avatar
Member Avatar
+0 forum 1

I want to see your suggestions on comparing CPanel and FASTPANEL. I used CPanel for some time but later I changed to FASTPANEL which is absolutely free but provides you with the same opportunities. Also FASTPANEL's design looks much better than CPANEL's one. So now I can't understand why people pay for CPanel. What panel do you guys use and why?

Member Avatar
Member Avatar
+0 forum 5

I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing. BOOM, every database I had there - gone! GRR! Dang! - Fortunately I was proactive and copied all of the previously ( the DB dir Mamp ). The internet tells me to simply put them back in the dir and restart - which I do.... Now PhpMyAdmin "sees" the DB's but does not have index's for any of them …

Member Avatar
Member Avatar
+0 forum 7

I can't accomplish async and await in order to populate array and then show the end result. When I execute the code, firstly there is an empty array. When I go "refresh", then data is populated. Obviously async. But I don't know how to write the code The similar problem is described here https://community.apigee.com/questions/49199/nodejs-cache-retrieve-data-and-push-to-array.html My code so far const express = require('express'); const router = express.Router(); const db = require('../../config'); var async = require('async'); function readDb(nameOfTableInDb, someArray) { // reuse a conneciton to db db.getConnection(function (err, conn) { if (err) { res.json({ "code": 100, "status": "Error in connection DB..." }); …

Member Avatar
Member Avatar
+0 forum 2

Hi, I have a form which consists a dynamic dependent dropdown and I want to maintain the entered data into the fields after the form is saved or edited. For an example: <input type="text" name="serial" value="<?php echo $serial;?>"> Similary i need to get the value in my dropdown as well. Hope there is a solution for this. Below is my code. ## ajax.js ## $(document).ready(function() { $("#brand").change(function() { var Brand_ID = $(this).val(); if(Brand_ID != "") { $.ajax({ url:"SR.php", data:{b_id:Brand_ID}, type:'POST', success:function(response) { var resp = $.trim(response); $("#model").html(resp); } }); } else { $("#model").html("<option value=''>----Select Model----</option>"); } }); }); ## Dropdown …

Member Avatar
Member Avatar
+0 forum 2

In this case I display values into datagridview from Projects table which it has only 2 columns: PROJECT_NAME VARCHAR ID INT // Which is hidden in datagridview, and as AUTOINCREMENT I have already done with editing values in this table and it works fine: `private void dataGridView4_CellEndEdit(object sender, DataGridViewCellEventArgs e) { string name_project = dataGridView4.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); string id = dataGridView4.Rows[e.RowIndex].Cells[0].Value.ToString(); MySqlConnection connection = new MySqlConnection("datasource = localhost; port = 3306; username = root; password = "); MySqlCommand cmd = new MySqlCommand("UPDATE projekt1.projects SET PROJECTS_NAME = @PROJECTS_NAME WHERE ID = @ID", connection); cmd.Parameters.Add("@ID", MySqlDbType.Int64).Value = int.Parse(id); cmd.Parameters.Add("@PROJECTS_NAME", MySqlDbType.VarChar).Value = name_project; try { …

Member Avatar
Member Avatar
+0 forum 1

This was a query raised by one of a forum members at another site, where he had a worksheet filled with random numbers, and I have already answered that query [at my post here](https://vbacoder1962.wordpress.com/2019/07/15/extracting-cell-phone-numbers-from-random-strings-of-variable-length/). You may go through that post and read the logic behind the code. ![vbacoder_Code_20190715.jpg](/attachments/large/4/160efbe4e4d0a8400d04653a6e420c7b.jpg)

Member Avatar
+1 forum 0

Hello. So I had to make this program that: 1. User enters a value (say, ID number) in a textbox, presses search, then the program searches for that particular item on a table and then copies all the row data where that ID number is. 2. Then pastes those copied data on another table in Access, then displays it on a datagrid Thanks. Im new so I haven't made up code yet :(

Member Avatar
+0 forum 0

How can you get the alternate records from the table in the SQL?

Member Avatar
Member Avatar
+0 forum 1

hello dear experts hello dear user, first of all; many thanks for this great wordpress-plugin. This is just overwhelming. currently i am planning to set up a site: well – We would like to create a dropdown menu that selects jobs from different sites on a WordPress-multisite. Scenario: imagine – when on one site, I can select a site from a dropdown menu and have it populate with that other subsite’s job listings. So there would be a central db where all the jobs are stored ** – i would have three sites:** jobs.mysite.com free-volunteering.mysite.com work-and-travel.mysite.com is this doable – …

Member Avatar
+0 forum 0

in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT, TABLUONGNV3.HOVATEN, TABNHANVIEN.IDNV, TABLUONGNV3.MACANV, TABNHANVIENCA.CANV, TABLUONGNV3.N01, TABLUONGNV3.N02, TABLUONGNV3.N03, TABLUONGNV3.N04, TABLUONGNV3.N05, TABLUONGNV3.N06, TABLUONGNV3.N07, TABLUONGNV3.N08, TABLUONGNV3.N09, TABLUONGNV3.N10, TABLUONGNV3.N11, TABLUONGNV3.N12, TABLUONGNV3.N13, TABLUONGNV3.N14, TABLUONGNV3.N15, TABLUONGNV3.N16, TABLUONGNV3.N17, TABLUONGNV3.N18, TABLUONGNV3.N19, TABLUONGNV3.N20, TABLUONGNV3.N21, TABLUONGNV3.N22, TABLUONGNV3.N23, TABLUONGNV3.N24, TABLUONGNV3.N25, TABLUONGNV3.N26, TABLUONGNV3.N27, TABLUONGNV3.N28, TABLUONGNV3.N29, TABLUONGNV3.N30, TABLUONGNV3.N31, TABNHANVIENCA.TIENMOTCA, TABLUONGNV3.TONGLUONG, TABLUONGNV3.PHAT, TABLUONGNV3.TAMUNG, TABLUONGNV3.THUCNHAN, …

Member Avatar
+0 forum 0

The End.