Member Avatar
Hi! Having a hard time figuring out how to solve this problem at hand. basically i have several tables that are inter connected in some manners but i need to full all this data and format it in a manner that it will show the total number of trips and …
by skullscript in Web Development ()
Member Avatar
I'm not sure whether this is a good question for this forum but, I'm struggling to set up a database to use in my school academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest part …
by savedlema 17 in Databases ()
Member Avatar
Sir I have this query and result [IMG]http://i66.tinypic.com/4r7oee.jpg[/IMG] Now I want to modify query to get result like this [IMG]http://i65.tinypic.com/11aihzs.png[/IMG] Please help
by phphp in Databases ()
Member Avatar
Hello DaniWeb Users; I'm not a good coder here please hold on me, My machine is linux ubuntu 14.04 and I install apache2 also the php5. I was trying to create a simple log in page here (no registration thing) So in mysql I just create 3 fields (user_id, username, …
by zelrick -1 in Web Development ()
Member Avatar
Dear devolepers, I have problem with my sql database, I want acces my sql database in my <LI> list plaese help to resolve this problem Here is my html sql database : my_db table : info_list Table columns : id,name,job,town,mobile1,mobile2,phone,adress i want to display town list in this <li> list …
by Faisal_13 in Web Development ()
Member Avatar
How to add new languages in this example? <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <script type="text/javascript" src="https://www.google.com/jsapi"> </script> <script type="text/javascript"> // Load the Google Transliterate API google.load("elements", "1", { packages: "transliteration" }); var transliterationControl; function onLoad() { var options = { sourceLanguage: 'en', destinationLanguage: ['ar','hi','kn','ml','ta','te'], transliterationEnabled: true, shortcutKey: 'ctrl+g' }; …
by AntonyRayan 15 in Web Development ()
Member Avatar
I want to add new languages in this example how to add? <html> <head> <script src="https://www.google.com/jsapi" type="text/javascript"></script> <script type="text/javascript"> google.load("elements", "1", { packages: "transliteration" }); function onLoad(){ var options = { sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH, destinationLanguage: [google.elements.transliteration.LanguageCode.GUJARATI], shortcutKey: 'ctrl+g', transliterationEnabled: true }; var control = new google.elements.transliteration.TransliterationControl(options); control.makeTransliteratable(['transliterateTextarea']); } google.setOnLoadCallback(onLoad); </script> </head> …
by AntonyRayan 15 in Web Development ()
Member Avatar
Is it possible to do pagination in Drilldown Graph?
by AntonyRayan 15 in Web Development ()
Member Avatar
I have 2 tables that look like this.(see below). Table one is named tableX and table 2 is named tableY. +-------+---------+ | count | post_id | +-------+---------+ | 3 | 7209 | | 3 | 7210 | | 1 | 7211 | | 1 | 7212 | | 1 | …
by Amaina in Web Development ()
Member Avatar
How to set a image as default as fixed like background and remaining images will have to change dynamically? in HTML, CSS
by AntonyRayan 15 in Web Development ()
Member Avatar
Customers pick When finished If on the book, such as the selection of Van Dyke VT01 from 1/07/59 - 2/07/59-day period, you will not be able to book your car again. It is based on the availability of the vehicle. I made a separate table Storage booking Van table separately …
by Goddy_1 in Web Development ()
Member Avatar
Hi all, I'm using the Laravel framework to create an application, and have a database question. I have a table called `posts`. I have been pulling the 10 most recent rows from here and making use of an offset variable for pagaination. Now however I also have a table `media` …
by James_43 15 in Databases ()
Member Avatar
Hi everyone, I have a submit form on my website that display's to the user once is has been submitted, The problem I have is the text is being displayed as Chris &amp; Amy\&amp;#39;s 30th It should be displayed as Chris & Amy's 30th What is the best way to …
by Lloyd_4 in Web Development ()
Member Avatar
how can i pass the value of $lat and $long in the while loop going to the script for googlemap.. kindly see the code below; while($row = mysqli_fetch_array($query)){ $station = $row['STATION']; $pei = $row['PEIS']; $pga= $row['PGA']; $pgv= $row['PGV']; $lat = $row['LAT']; $lon = $row['LON']; } <script> function initMap() { var …
by michael john in Programming ()
Member Avatar
sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …
by _1_36 in Databases ()
Member Avatar
How to retrieve data from another database using PHP, mySQL?
by AntonyRayan 15 in Web Development ()
Member Avatar
How to retrieve data from one database to another using PHP , mySQL?
by Ragu_1 in Web Development ()
Member Avatar
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …
by cereal 1,078 in Databases ()
Member Avatar
Dear Experts, I am using these codes <?php require_once("../includes/connectw.php"); require_once("../includes/functions.php"); $error=""; if(isset($_POST['login'])) { $muser=clean($_POST['username']); $mpass=clean($_POST['password']); if(empty($muser)) { $error="User name must not be empty"; } elseif (empty($mpass)) { /*echo ('<script>alert("Password must not be empty")</script>');*/ $error="User name must not be empty"; } else { $query="select * from admin where user ='".$muser."' and …
by phphp in Web Development ()
Member Avatar
$stmt = $dbconn->prepare("SELECT * FROM `members` WHERE username=? AND password=?"); $stmt->bind_param("ss", $username, $password); Is what I have. Database is connected etc. How can I set variable called `$dbresult` with array of SQL result? I don't want to set individual variables. I really need an entire array as answer. There's couple …
by Aeonix 39 in Web Development ()
Member Avatar
Hi all, Say I have a table called "posts" with thousands of records. For each user, I want to display the top 10 most recent posts. I would normally use: `select * from posts order by created_date desc limit 10` However, doesn't this select ALL records and then removes all …
by James_43 15 in Databases ()
Member Avatar
I drew a picture of the database performance for editing. But I try not to choose a new image. Then press the update appears that it does not send the originals back. If you choose a new image It was able to get regular updates. If not, select and click …
by Goddy_1 in Web Development ()
Member Avatar
I am inserting dates like 2016-03-01T00:00:00, which is in the varchar format. I want to convert into as mysql date and add between condition to get records. I am using STR_TO_DATE function, but I am getting as NULL value.
by Abhi_6 in Databases ()
Member Avatar
**I want to add multiple Record. Add 1 record if it is to insert 1 record , but if 5 recoed data will insert 5 record. Sorry i'm not good english** images 1 [Click Here](http://i.stack.imgur.com/K4XdO.png) images 2 [Click Here](http://i.stack.imgur.com/K4XdO.png) <?php include_once("connect.inc.php"); if (isset($_POST['submit'])) { $i = 0; foreach ($_POST as …
by Goddy_1 in Web Development ()
Member Avatar
Hi guys I need a help here, I’m trying to use Ajax to update the column of the table in the database with combobox without a submit button, by the way it update the column finely but unfortunately the column data is erased to **0** when a webpage is refreshed. …
by Hamis_3 in Programming ()
Member Avatar
Consider the following query: //$fix and $limit are dynamic values $query="SELECT ICAO_Ident AS ID, Location_Identifier AS LocID, Official_Facility_Name AS Name, Landing_Facility_Type AS AptType, Associated_State_Post_Office_Code AS State, Associated_City_Name AS City FROM APT WHERE `Location_Identifier` LIKE '%$fix%' OR `ICAO_Ident` LIKE '%$fix%' OR `Official_Facility_Name` LIKE '%$fix%' OR `Associated_City_Name` LIKE '%$fix%' ORDER BY `ICAO_Ident` …
by grant.baker 10 in Programming ()
Member Avatar
I used below select query to select information from two tables. But it show one record. How to change this code to view all records ? select loan.loan_id, loan.customer_name, loan.total_amount, ifnull(sum(settlement.amount), 0) as 'Total Received', ((loan.total_amount) - ifnull(sum(settlement.amount), 0)) as 'Total Due' from loan left join settlement on settlement.loan_id = …
by සශික in Databases ()
Member Avatar
I was working on bank ifsc code search engine which provides all branch details for every bank in India. I used Php and Mysql to handle database queries and data retrieval. The whole project looks good but there were some technical limitations stopping me. Like, i have done all SEO …
by ajahar in Web Development ()
Member Avatar
Hi guys, I'm busy testing storing PHP variables in a MySQL table but I'm having difficulties using them as variables when pulling them from MySQL. When I pull the variables is displayed as a normal string and I'm not able to use them as a variable. Is it possible to …
by LRNPHP in Web Development ()
Member Avatar
Hi all, i'm currently workin on a project and i need to show on a maps the live position of my car. i have an arduino wich send every 5sec to my DB the position The problem is that i can't figure out how to refresh my polylines every 5second …
by riccardo_1 in Web Development ()