7,368 Topics

Member Avatar for
Member Avatar for Techmed
Member Avatar for rjusman90

here is the normal rows coming ![WhatsApp_Image_2019-11-04_at_2_32_36_PM.jpeg](/attachments/large/4/f5be1a527695a5bf62797e287c220820.jpeg) i want to show the group by product name with the count of store as the below picture ![WhatsApp_Image_2019-11-04_at_3_28_58_PM.jpeg](/attachments/large/4/b96ff7cb890fb01e6de9e5540a7e7a9e.jpeg) here are mysql query SELECT i.barcode, i.name, u.company_name, COUNT(i.id) AS IQTY, COUNT(U.id) AS UQTY FROM inventory i, USER u

Member Avatar for Reverend Jim
0
254
Member Avatar for Muhaimin

Hello DaniWebian's, This is Muhaimin Sheik, I'm a passionate web developer as back and front end. I was very friendly and helpful person. I want more know about the techie knowledge. Please guide me. Thank you all...!Cheers...!

Member Avatar for John_165
0
236
Member Avatar for lanny_1

can someone please help me with coding. I need to create a dropdown menu with the options being the category the user has inputted into a file upload page.

Member Avatar for lanny_1
0
313
Member Avatar for Cheri Anne

How do I echo selected option? <?php session_start(); if(isset($_SESSION['cherianne'])){ }else{ header("Location:login.php"); } include("../includes/header.php"); // Retrieve our critical page setter variable. $char_id = $_GET['id']; //echo "<h1>$char_id</h1>"; // set this as a default value if (!isset($char_id)) { $result = mysqli_query($con, "SELECT bid FROM cde_blog LIMIT 1"); while ($row = mysqli_fetch_array($result)) { $char_id …

0
302
Member Avatar for SharkJr

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 …

Member Avatar for anand9796
0
416
Member Avatar for Vin vin

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 …

Member Avatar for damonmoats
0
564
Member Avatar for Nuel

I have table i wish to count how many times a value appears in all column the table structure id Subject1 Subject1score subject1grade Subject2 Subject2score subject2grade 1 English 100 A Mathematics 100 C HERES MY PREVIOUSLY TRIED CODE <?php $subject1grade='A'; $subject2grade='A'; $subject3grade='B'; $a=array("$subject1grade","$subject2grade","$subject3grade"); print_r(array_count_values($a)); ?> THE RESULT Array ( [A] …

Member Avatar for Bert Pitt
0
1K
Member Avatar for phase3studios

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 …

Member Avatar for daydah
0
430
Member Avatar for cybertech09

Please I need your help, I am new to PHP and I need your help in inserting multiple select array into the database in the form of this. This is what I want to achieve. My table has 3 columns (id, examno, results). I want results column to be inform …

0
1K
Member Avatar for cybertech09

Please I need your help, I am new to PHP and I need your help in inserting multiple select array into the database in the form of this. This is what I want to achieve. My table has 3 columns (id, examno, results). I want results column to be inform …

0
250
Member Avatar for uppalusman

Hi Dani, I am very much new in web development, i developed a page in bootstrap HTML and now i want to pull some data from mysql. i am able to pull data in php but not in HTML.

0
186
Member Avatar for rayne_lynch

hi everyone! I am wondering if anyone can point me in the right direction regarding cookies and sessions. What I need to know is this; I am developing a website that has mixed html and php pages. I am wanting to have "members" where certain web pages are accessible to …

Member Avatar for alan.davies
0
249
Member Avatar for nagendraveer

Actually iam a new PHP Learner, i developed an web app using Bootstrap, PHP, Mysql. Now i want to give login access for gmail id's which are already existed in my database, so i used login with google API, but want deny login access for any other gmails which are …

Member Avatar for Dani
1
1K
Member Avatar for Edy_3

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 for DGPickett
0
536
Member Avatar for madhava_3

hai all, i have 2 tables 1)state state contains stateid,statename here stateid is primary key. city contains cityid,cityname,stateid stateid is foreign key. 2)city now state contain 1 ap,2 tamilnadu,3 banglore. city contains chittor 1,madanapalle 1,tirupati 1 katpadi 2 ,kanchi 2 mysore 3 ,chintamani 3 when i select the ap city …

0
198
Member Avatar for aruneshdutta

Hello all wanted guidance on CMS(Content Management System) to be able to work with REST API for integrating REST API as needed for performing needed tasks.Kindly guide me with same

Member Avatar for rproffitt
0
407
Member Avatar for Rhemiel

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 …

Member Avatar for alan.davies
0
348
Member Avatar for SpottyBlue

Hi, I do need help with my solo project called Salary Expenses project in PHP and Laravel and I don't see any data for the current month in the **Monthly Expenses page**, even the data is recorded during the current matching month. Can help? My project file: https://drive.google.com/open?id=11qrmVHOwdgiiYQbw981o4y_CNp9DrTUM

0
222
Member Avatar for NoizeDev

I apologize in advance if the title in unclear. I am fairly new to PHP/MySQL programming. I have a script I am working on - I have the login, register setup correctly and working fine. I have the pages restricted so that you're required to login. I am now trying …

0
152
Member Avatar for Ron Peters

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 …

Member Avatar for rproffitt
0
219
Member Avatar for idaryl

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! …

Member Avatar for rproffitt
0
340
Member Avatar for jadago

Dear all, Am new programmers and I'm facing a problem on how I can draw a pie chart column-wise using PHP MySQL. Please see the MySQL table below; id Q1 Q2 Q3 1 Female No 30 2 Male Yes 40 3 Female Yes 50 4 Male Yes 60 What I …

Member Avatar for AndreRet
0
340
Member Avatar for bprosic

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 …

Member Avatar for sagar_14
0
4K
Member Avatar for rchawdhari

I have storing major data in mysql and logs are stored in cassandra. Cassandra db getting heavier and difficult to do queries. So I want to migrate all my cassandra's table in mysql is it possible?

Member Avatar for DimaYasny
0
318
Member Avatar for CarterLangley

Hi guys, I have the following code that I just cannot get to work! Can you please let me know where I have gone wrong? <?php //db_connect.php $con=mysqli_connect("localhost","root","password","database"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } function get_file_extension($file_name) { return end(explode('.',$file_name)); } function errors($error){ if …

Member Avatar for Ajit_786
0
1K
Member Avatar for Ravi_53

I have One Problem in my coding ..I want to upload multiple images in the database in one row with using comma ... for($i=0;$i<count($_FILES['eventpic']['name']);$i++) $pic = $_FILES['eventpic']['name'][$i]; $tmp =$_FILES['eventpic']['tmp_name'][$i]; $location="pics/".$pic; move_uploaded_file($tmp,$location); $q="insert into tbl1(title,tdate,eventpic)values('','','$pic')"; echo $q; through this code i can upload tthe multiple images but not in a single …

0
212
Member Avatar for prochotap

In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and …

Member Avatar for rproffitt
0
354
Member Avatar for soham_3

Hello I am using Crystal report version 11.5.8.826, php version 7.0.10, Apache version 42.4.33 and MySql Version 5.7.14. I have created the sampel rptone.rpt file that contents sample report. I want to load that rptone.rpt file using php. With Crystal report 11.5.8.826, php 7.0.10, apache 42.4.33 and MySql 5.7.14 i …

0
174
Member Avatar for AsjadAli

Hello Experts! I am stuck here while generating QR Code using php sql. Basically I am generating code for students using their ids and other information while fetching data from database. But the problem is that when i click on submit button so that table data store in QR Code, …

Member Avatar for alan.davies
1
7K

The End.