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
Dear all I am a beginner in web development. Please help to resolve the below problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers. > When customer select the specific job we need to filter particular job …
by Faisal_13 in Web Development ()
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
Hello. I am new to PHP/MYSQL. My array looks like this: Array ( [1] => item1 [2] => 1tem2 [3] => item3 [4] => item4 [5] => item5 [6] => item6 ) Array ( [7] => item1 [8] => item2 ) Array ( [9] => item1 [10] => 1tem2 [11] …
by Gurjit_2 in Web Development ()
Member Avatar
Hi Dw. I have a MySql server database, and I'm polling data from the database. The problem I'm getting is that when I'm retrieving users activities I only get the first record only which is on `Row(0)` or the first record with that username. Suppose I have a database like …
by Mr.M 32 in Software Development ()
Member Avatar
Dear developers How to show contact details while clicking the particular name from <li> list Contact_list.php <?php $con=mysqli_connect("localhost","user","pass","nilambu1_mydb"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM n_info "); while($row = mysqli_fetch_array($result)) { echo "<li><a href='contact.php' data-transition='slidedown'> <img …
by Faisal_13 in Web Development ()
Member Avatar
: CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not …
by Pam Thomas in Databases ()
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
Hello, i am a new php and html developer. kindly assist me for my querys thanks in advance raj
by Raj_18 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
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
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,066 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 ()