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

I am learning database and php I have made a database with a list of my game collection with the following fields, 1. ID 2. game_name 3. game_year 4. platform 5. publisher_name 6. media 7. owned 8. finished 9. completed 10. launcher I made this database in phpMyAdmin and would now like to add images of the games and the end of the database. This is for me and will not be going on the internet, so the images will be on my computer, I have searched for answers on the web and can not find any. I want to …

Member Avatar
Member Avatar
+0 forum 1

Hey! I am a bit stuck with my htaccess... let me explain how I want it to work... I have a wildcard subdomain, for example, demo1.domain.com, demo2.domain.com... I want htaccess to take whatever the subpart of the domain is and pass it as a variable... Options +FollowSymlinks RewriteEngine On RewriteCond %{REQUEST_URI} !(/$|\.) RewriteRule (.*) %{REQUEST_URI}/ [R=301,L] RewriteCond %{HTTP_HOST} !^www\.domain.org.uk RewriteCond %{HTTP_HOST} ^(.+).domain.org.uk RewriteRule ^([^/]*)$ http://domain.org.uk/app/index.php?id=%1 [P,L,QSA] This works and I can get the variable ID... I then use the to query a database and get the users database details and settings etc and save them into Sessions... Then I want …

Member Avatar
+0 forum 0

Hi i'm Anis. I want to ask how i can attach image from database in FPDF?

Member Avatar
+0 forum 0

I am a beginner to php and am designing student information system where students need to enter 9 subject and its corresponding grade based on the number of sittings. Is there any better way to do this apart from what I have been doing? These are my codes: <form name="register" method="POST" action="process2.php" > <div class="col-md-12"> <div class="form-group"> <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> </div> <div class="output1" id="div1" name="onesitting"> <div class="col-md-6"> <div class="form-group"> <label>School Name</label> <input type="text" name="schoolname1" id="schoolname" class="form-control" placeholder="School Name" required> </div> </div> <div class="col-md-6"> <div class="form-group"> <label>Exam Type</label> <select …

Member Avatar
Member Avatar
+0 forum 2

Hello Frds, select box option add new state in add.already same state in condition check already exist using php pdo.please help me.

Member Avatar
-1 forum 0

I'm currently working on my project. I use Vertrigo as my virtual server. However recently i always see this message when i use it.... MySQL database server does not work correctly. Check whether other applications use the important port (3306)... i'd no clue at all but then i reconfigure my MySQL..problem still persist. Any solution here? How do i check whether any application using that port as well? Thanks

Member Avatar
Member Avatar
-1 forum 17

Hello i am getting an error on a CASE WHEN THEN syntax on my mySql SELECT DISTINCT u.uid,c.c_id,u.name,u.profile_pic,u.username,u.email,c.time FROM conversation c, users u, conversation_reply r CASE WHEN c.user_one = '99' THEN c.user_two = u.uid WHEN c.user_two = '99' THEN c.user_one= u.uid END AND ( c.user_one ='99' OR c.user_two ='99' ) AND u.status='1' AND c.c_id=r.c_id_fk AND u.uid<>'1'ORDER BY c.time DESC LIMIT 15 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN c.user_one = '99' THEN c.user_two = u.uid WHEN c.user_t' at …

Member Avatar
Member Avatar
+0 forum 6

Hi guys , I have a tables called “scores” With the following Fields AdmNo,Name, Maths,English,Biology ,Avg Am loading this data to my datagridview using select “Select * from scores order by Avg Desc” Which works fine my question is how do i get the rank of every student from the datagridview in the form of Adm Name Maths Eng Biology Avg. rank 1. Peter. 80. 60. 70. 75. 1 2. Alex. 20. 20. 20. 20. 2 Etc How do I rank?

Member Avatar
+0 forum 0

The End.