10,940 Topics

Member Avatar for
Member Avatar for JamieBek04

Heres a pic of my database table ![Screen_Shot_2019-11-16_at_2_35_54_AM.png](/attachments/large/4/0749479693675147a0ccc8219b89e87f.png) Im trying to create a search page with drop down selectors to filter through each of the last 8 columns. I want the the drop down selectors to be able to select multiple entries (I have this working already) I also want …

0
602
Member Avatar for guyinpv

Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, …

Member Avatar for Saudi_2
0
4K
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
255
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
314
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
303
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
566
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 joao_9

hello i am developing an application in c ++ and mysql and i am having a lot of difficulties in more specified login in the query where the query needs the user and the pass which are in variables. Can anyone help me? Thanks.

Member Avatar for rproffitt
0
2K
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
431
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
252
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 Jun_8

$strSPQuery = "SELECT * FROM `san_pham` where ma_san_pham=".$arrMa[$i]; $resultSp= mysqli_query($conn,$strSPQuery); $rowsp = mysqli_fetch_array($resultSp); $tong += $rowsp["gia"]*$arrSl[$i];

Member Avatar for Dani
0
2K
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 chandu_4
0
183
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
544
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
199
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
408
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
220
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
355
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
348
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
328

The End.