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, I can even shut down MySQL if needs be. 4) The database is mostly MYISAM but with a few InnoDBs and a couple Memory (VBulletin) 5) Both servers are Linux based and I have root access on both. I've done the transfer using a mysql dump, but the import took …

Member Avatar
Member Avatar
+0 forum 14

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] => 2 [B] => 1 ) I NEED THE CODE TO DISPLAY You made 2A(s), 1B(s) I want to count how many A's and C's

Member Avatar
Member Avatar
+0 forum 3

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 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 of subjects grades, subjects grades.........depending on the numbers of subjects and grades users select (e.g English C6, Mathematics C6) all in one column results. ## This is my html codes ## <form action="insert.php"> <div class="form-group"> <label>Exam Number</label> <input type="text" class="form-control" name="examno" id="examno"> </div> <table width="100%" cellpadding="0" cellspacing="0" border="0" class="table table-borderless" …

Member Avatar
+0 forum 0

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 of subjects grades, subjects grades.........depending on the numbers of subjects and grades users select (e.g English C6, Mathematics C6) all in one column results. ## This is my html codes ## <form action="insert.php"> <div class="form-group"> <label>Exam Number</label> <input type="text" class="form-control" name="examno" id="examno"> </div> <table width="100%" cellpadding="0" cellspacing="0" border="0" class="table table-borderless" …

Member Avatar
+0 forum 0

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.

Member Avatar
+0 forum 0

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 them. this is not the problem. the problem comes when I have a member that is logged in - they are great to surf through ANY of the accessible web pages within the site, however, if they want to visit an html web page within the site..how can i ensure …

Member Avatar
Member Avatar
+0 forum 1

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 not existed in my database.

Member Avatar
Member Avatar
+1 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

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

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 only shown in drop down list i dont have any code could you please help me any one .

Member Avatar
+0 forum 0

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

I have developed a game for android mobiles ["Rise Up Air Balloon"](https://play.google.com/store/apps/details?id=com.abacus.riseup). I want to updatte it. Kindly suggest me something if it is better to update https://lh3.googleusercontent.com/rB-fPEBiaGzT_ubSzCtSfftC4pKkIm5buAS2_DhQz4_exYFCrjbcN2T1NhkmM0A3Jj0=s180-rw

Member Avatar
Member Avatar
+2 forum 1

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

Member Avatar
+0 forum 0

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 to work on an administration panel, my users table in the database is currently setup as follows; id username password created_at I want to add another column called `is_admin` and the default value set to 0, where if `is_admin` is set to 1 then user is admin. I know how …

Member Avatar
+0 forum 0

I have three tables(table, table2,table3). From table1 i want to return three rows: Title, Desc,time,'products' AS type From table2 i want to return three rows: group_title, group_desc, created,'groups' AS type From table3 i want to return three rows: name, occupation,birth,'users' AS type $sql = "SELECT DISTINCT * FROM (SELECT table1.title, table1.desc, table1.time,'products' AS type FROM table1 ORDER BY rand() LIMIT 5) AS T UNION ALL (SELECT table2.group_name,table2.group_desc,table2.created,'groups' AS type FROM tabl2 JOIN table1 ON table2.id = table1.id ORDER BY rand() LIMIT 5) UNION ALL (SELECT table3.name,table3.occupation,table3.birth,'users' AS type FROM table3 JOIN table1 ON table3.id = table1.id ORDER BY rand() LIMIT …

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

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 need is PHP/high chart code that will dynamically plot a pie chart for columns q1,q2, and q3. The idea here is to have the output as per google form does.

Member Avatar
Member Avatar
+0 forum 1

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

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
Member Avatar
+0 forum 2

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 (!empty($error)) { $i = 0; while ($i < count($error)){ $showError.= '<div class="msg-error">'.$error[$i].'</div>'; $i ++;} return $showError; }// close if empty errors } // close function if (isset($_POST['upfile'])){ // check feilds are not empty if(get_file_extension($_FILES["uploaded"]["name"])!= 'csv') { $error[] = 'Only CSV files accepted!'; } if (!$error){ $tot = 0; $handle = …

Member Avatar
Member Avatar
+0 forum 6

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 row ....

Member Avatar
+0 forum 0

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 holidays (which I'll show in code snippet), then it shows about like that: +--------+---------+---------+-------------+---------+----------+----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE |LEAVE TIME| +--------+---------+---------+---------+------------+-----------+----------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 |838:59:59 | +--------+---------+---------+----------------------+-----------+----------+ Which time 838:59:59 is about... 35 days. I have a trouble with it. Is that possible to calculate …

Member Avatar
Member Avatar
+0 forum 1

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 have tried to connect/load crystal report file that is .rpt file using COM Object but it gives error $my_report = "report/rptone.rpt"; $COM_Object = "CrystalReports115.ObjectFactory.1"; $objCom = new COM($COM_Object, "localhost", 0, ""); $crapp = $objCom->CreateObject("CrystalDesignRunTime.Application"); $creport = $crapp->OpenReport($my_report, 1); This expected to be open rptone.rpt file that must show the report …

Member Avatar
+0 forum 0

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, then it only generate the QR Code of of only last one student. For Example if i have 6 students, it only generate the qr code of student whose id is 6. Code is here:

Member Avatar
Member Avatar
+0 forum 2

hello dear experts here at Daniweb, first of all i am pretty new to this site - to daniweb. I am new to this site. My interests are Programming in PHP, Python and running websites - with WordPress. Well - i am running webadmin - a Apache and MySQL-Server-frontend- for years now. now i run into troubles when establishing a db connection. i thought that during the installation process the file wp-config-sample.php gets to wp-config.php - but this is not happening.- i have gathered some more infos and inights due to some tests. see the following data: - the outcome of …

Member Avatar
Member Avatar
+0 forum 4

I am having problem in submitting this form when I select "1" on the number of setting in html form. The submit button is working if I select 2 in the number of sitting from html form as it will show all the form fields but when I select 1, submit form is not working. I am new to PHP This is my html form <form name="register" method="POST" action="process.php"> <label>Select Number of Sitting(s)</label> <select name="sitting" id="sitting" class="form-control" onchange="showDiv(this)"> <option value="1">1</option> <option value="2">2</option> </select> <div class="output1" id="div1" name="onesitting"> <label>School Name</label> <input type="text" name="schoolname[]" id="schoolname1" class="form-control" placeholder="School Name" required> <label>Exam Type</label> <select …

Member Avatar
+0 forum 0

The End.