11,093 Topics
 | |
| | hello i need solution for to create a insert/select/delete/update stored procedure in mysql and how to call them from php currently i am using xampp 1.6.6 version of software thank you  |
 | Any ideas why this is not actuall writing to the database <form method="post" action=""> <p> </p> <table width="300" border="0" align="center" cellpadding="0" cellspacing="10"> <tr> <td width="100" align="right"> Film Title : </td> <td><input type="text" name="Film_Title"></td> </tr> <tr> <td width="100" align="right"> Film Format : </td> <td> <select name="Format_ID"> <option>- Select Film Format -</option> <option …  |
 | hi ive picked up a script and although ive put database details in its not picking them up heres the database file ommiting my database details of course config.php <?php ob_start(); session_start(); ini_set("display_errors", 0); $hostname = "localhost"; $database = "matureco_test"; $password = "xxxxx"; $username = "xxxx"; and heres the database … |
 | Hi everyone, I have database in cassandra . I am facing difficulties in cassandra. So I want to migrate cassandra tables in mysql. Is it possible ? How I can do this? Please help me.  |
| | I need to show excel type data for each of my website, means I want to show the sale on each date and if there is no sale on a particular day that date should be empty. Currently my data is showing like this  This is what I … |
| | Hi, I have two tables as employee id int primary key, purchase_order_product int, bundle int fabric_bundles id int primary key, purchase_order_product int, bundle int, quantity I want to make assciation between employee and fabric_bundles via purchase_order_product and bundle |
 | Hi, I have built an application using java programming and I want to write MySQL table data to excel sheet by using Apache's POI libraries and MySQL connector in java. I have explored many [mobile development blogs](findnerd.com/NerdDigest) for my previous query on Android Programming & get a satisfactory solution. I …  |
| | Hello everyone..it's me again..adindra i have a problem : i have 1 database name [B]manipulasiphp[/B], with 10 field (id,nama,email,alamat,umur,negara,universitas,jurusan,prodi,no_telp) i have 1 HTML script and 1 PHP script they're name are [B]index.html[/B] and [B]input.php[/B] here's the script : [B]index.html[/B] [code=php] <html> <head> <title>Form Calon Peserta Beasiswa Monbugakusho Jepang</title> </head> <body> … |
 | want to create website in php using mysql. i dont know how to start i am new in php programming. Please help me!!!  |
 | I want to retrive data from two tables. I used below code : (SELECT sum(total_amount) as tr from loan where loan_status = 'not finish') union (SELECT sum(amount) as tt from settlement where sett_status = 'Active') But It load data by one column and these two values load under the another …  |
 | I tried this code But does not download File while ($row = $result->fetch_assoc()) { $filename=$row['name']; echo "<tr>"; echo "<td>".$i."</td>"; echo "<td>".$row ['cdetail']. "</td>"; echo "<td>".$row ['tenNo']. "</td>"; echo "<td>".$row ['tdetail']. "</td>"; echo "<td>".$row['ldate']."</td>"; echo "<td> <a href=adminfrm.php?file=".$filename."target='_blank'>Download</a></td>"; Please, guide me |
| | hi i have the following error [09-Nov-2016 16:22:28 America/Chicago] PHP Notice: Undefined index: HTTP_REFERER in /home/matureco/public_html/index.php on line 224 [09-Nov-2016 16:22:28 America/Chicago] PHP Notice: Undefined index: email in /home/matureco/public_html/index.php on line 225 ive checked and they are in the php block see code below can anyone tell me why this … |
 | Hello :) Around a month ago, i got a custom bookmarklet coded for my wordpress blog and on top of the bookmarklet .js code there is this line var token = 'QzEJ5PJ3/RRO4cubQQiKKNg5au6SESUSkQOK5w9HKFgH6GxVu1NNilA5TYqoMBbz6sKdZP6eQ4GeLyZ1Ht5S/VrHIISvHXKFPxXNUZmRp1M='; I think this is some sort of API key or something that’s specific to a wordpress installation right? … |
| | Generate JSON According to Drill Down Drill -Up Events6  |
 | I want to make a script that changes pictures depending on the type . I am getting a error on Sql but i dont know what i am doing wrong this is the script function Pic($profilePic) { if($profilePic) { $profile_pic=BASE_URL.UPLOAD_PATH.$profilePic; } else { $sql = "SELECT type FROM messages WHERE … |
 | Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Timetable\timetable.php on line 90 |
| | I had mysql database and had many tables in database. For this problem we need details only about two tables. These tables are customer and guarantor. For each customer had two guarantors. In Customer tables it's primary key is Customer_id In Guarantor table it's primary key is Guarantor_id Then I …  |
 | I am using the Ionic framwork for the mobile app and Bootstrap for the web app, this has been set by my University as what we have to use, so we can't change them, but is there a way to link the data base to both services? Thanks in advance …  |
| | dear friends, I have created Php form to store data in my mysql database. But i am facing problem in updating file data to store in database. Please check my code below $edate=$_POST['edate']; //$edate=date("d-m-y h:i:s a",time()); $ldate=$_POST['ldate']; //$ldate=date("d-m-y h:i:s a"); $cdetail=$_POST['cdetail']; $tenNo=$_POST['tenNo']; $tdetail=$_POST['tdetail']; $name = ($_FILES['uploaded_file']['name']); $mime = ($_FILES['uploaded_file']['type']); $data … |
 | Hi. I'm in the process of learning Swift coding and decided to attempt a porting of one of my existing Windows programs. The thing is, that program relies heavily on connecting to a remote MySQL server. I've seen a few attempts to provide various connectors to an assortment of databases, …  |
 | the code below is working, but it is displaying only one image in a blank page where there is no css I want it to display all the image in a table. please help me... <%@page import="com.sun.javafx.tk.Toolkit"%> <%@page import="java.awt.Image"%> <%@page import="javax.swing.ImageIcon"%> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@page import ="java.sql.*" … |
 | hello guys its been a while since my last question here :P am working right now on PHP script to upload and convert video files to several resolutions ( 360 - 720 ), here a piece of my php code to convert move_uploaded_file($file_tmp, 'upload/'.$fileName); add_to_queue($time,"360-".$fileName,$status="pending"); //where add_to_queue is simple function … |
| | Hi Friends. i am working on my internal work. i am having n dynamic rows, Each and every row contain total. i want to sum all the rows total. i have attached the screen shot for the reference |
 | Hi, Please I have a problem inserting record to mysql database, it always shows this error " Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www" here is my code <?php if(isset($_POST['submit'])){ $member_dat1=$_POST['member_first']; $member_dat2=$_POST['member_lastname']; $member_dat3=$_POST['sex']; $member_dat4=$_POST['member_type']; $member_dat5=$_POST['m_email1']; $member_dat6=$_POST['m_phone1']; $member_dat7=$_POST['m_address1']; $member_dat8=$_POST['m_address2']; $member_dat9=$_POST['city']; $member_dat10=$_POST['state']; $member_dat11=$_POST['added_by']; $member_insert= "INSERT INTO members(member_first,member_lastname,sex,member_type,m_address1,m_address2,city,state,m_phone1,m_email1,added_by)" … |
 | i have been rearrange the code for whole day still cannt make the datepicker search filter working only the dropdown select filter is working.. previously is datepicker search filter is working and dropdown options is not working, but i working it and it turns around where the datepicker is not … |
| | Hi, by passing city name, I take all hotels reviews among on the requested city groupin by hotel id and user id that reviews should be greater than 0, The query works correctly, but taking values using while loop it combines all the hotel review values together. How to take … |
| | I use a webservice to pull some data from it everyday & update it on my MySQL database. I'll make around 600 calls to this service. The webservice response is very slow (takes around 30 minutes to complete 600 transactions) & during this time, the MySQL is also giving slow …  |
| | Dear Friends, I ctreate database in mysql database data transfer from PHP form. Problem: I can not save my Date formate(dd-mm-yy) in to database. My code is below please, if($epr=='save'){ // $cid=$_POST['id']; $edate=$_POST['edate']; //$edate=date("d-m-y h:i:s a",time()); $ldate=$_POST['ldate']; //$ldate=date("d-m-y h:i:s a"); $cdetail=$_POST['cdetail']; $tdetail=$_POST['tdetail']; $sql1="INSERT INTO tentb(edate,ldate,cdetail,tdetail) VALUES('$edate','$ldate','$cdetail','$tdetail')"; $result1=$conn1->query($sql1); if($result1){ echo "Data … |
| | Dear Friends, I created Table in PHP. Columns are SrNo. ---- Tender Detail----- Last Date----- Remaining Days ---------- Status(Pending/Proceded) I have Database in mysql. I get "last date" from database and minus with Current date. But i tried there is any problem please, check. Code is below <?php function dateDifference($date_1 … |
 | 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  |
 | this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)") Press any key to continue . . . from pony.orm import * db = Database() db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data') |
| | <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="relaxinn"; // Database name $con=mysqli_connect("$host","$username","$password","$db_name"); if (mysqli_connect_errno($con)) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } //Get number of rows $categories = array(); $sql="SELECT * FROM books "; $result=mysqli_query($con, $sql); while($row=mysqli_fetch_assoc($result)) { $categories[$row['language']][] = $row['code']; … |
 | Hi, I just need a little help here. I have no experience in syncronization of databases of any type and I think I need it in my project now. I developed a CATV (Cable TV) Billing Software in VB.Net for all cable system branches of our company and I use … |
 | I'm trying to get the text value from a select dropdown menu that is populated by a database using the following function: <?php function searchintspokenlang() { require ('../../../connect_db.php'); $queryintspoken="SELECT Language FROM languages"; $result=mysqli_query($dbc, $queryintspoken); while ($row = mysqli_fetch_array($result)) { echo "<option value='" . $row['Language'] . "'>" . $row['Language'] . "</option>"; …  |
| | Hi, I have a column "statustime" in a table , which has values( like,10:24:10 PM,12:04:00 AM) with mixed of AM and PM . I want to display the other values by "statustime" in ASC . How to do? |
| | Guys i'm trying to get data joined from two tables. I have a select options dropdowns with Fabrics names the other has sizes. I am wondering how i will make my dropdown changes the values for each fabric in each size and multiply for the amount of fabric selected. this … |
| | i am able to populate data in chain select drop down list but the problem is when page is refreshing selected data is lost how to fix that .. here is the code.. <?php require_once 'include/config.php'; require_once 'include/opendb.php'; ?> <?php if(isset($_POST['model'])){ //This is for the third and final drop down … |
 | Hello, its been a while since I use mysql and I breaking my head with this syntax: SELECT * FROM `Botones` WHERE `aprove` = 1 AND `descripcion` LIKE '%$search%' OR `nombre` LIKE '%$search%' ORDER BY `likes` DESC LIMIT 0,20 Its working great only problem is that it returns colums even …  |
 | Hi Guys! i need some help, with recurring invoices or payments. I have Application which i developed recently to my customer. And inside of App i got a module to invoice clients, for a product, which this product is valid only for one year starting may for each year and … |
 | I have created template for user to user chat module. Need help to complete realtime chat. Need some validations like highlight chat window on message received if it is inactive. `to_id` is collected in script (`var userid`). how to collect `from_id` , if user is logged in via php. currently …  |
 | Now, i have Set up the Connection to MySQL,and i have this Layout: |ID|Class|Name|Password| The Names are ALL shown in Combobox2.But i have a Combobox1 with Numbers.Now if i select 1, i want only the Users with Class 1 to show in my Combobox2,when i Select 2, only Class 2 … |
 | I´m in disgrace with the framework Codeigniter version 2.2.0, it only displays the json response, no errors, no chart... Code **Model** function get_pata() { $this->db->select('theyear, cantidad_alumnos, rawkw, rawkwxgei'); $this->db->from('pdc_factor_gei'); $query = $this->db->get(); return $query->result(); } **Controller to handle data from Model and display in view;** function data_fik() { $data = … |
| | I have a database to manage students 1. I want to Select students that are in level 1 fom the students table 2. Select the subjects from the subjects table 3. and echo the matching results on am html table any help? |
| | Working on law firm website. Different Lawyers have assigned different cases ( in same law firm). For that purpose it needs Family Tree implementation to collect clients history. There is main table `persons` personID primary key AUTO INCREMENT firstName lastName sex birthDate birthPlace deathDate deathPlace parents, spouse, childre all are … |
 | I need to create a form with five dropdown select lists. Making a selection in any list will cause the other lists to repopulate. It's fine if the page refreshes in order to repopulate the lists, although eventually I'd love to have it happen dynamically (using Ajax or JQerry). The … |
| | My question is related to an [answered question](https://www.daniweb.com/programming/web-development/threads/506078/parsing-xml-to-extract-attributes) that was asked here on the ever reliable forum - Daniweb. I have been trying to insert the parsed data as a string into mysql table in vain. This is what i am trying to do..... From the solution in the link … |
 | Hi everyone, i'm having problem on what PHP code that is appropriate for me to search for a specific data from mysql database, help me with how to go about please  |
| | Hi guys. Today I want help from you experts. This will help others as well. Okay. Directly to the topic. My senario is this. I want to save image to mysql database. By this way. There was table contain two data columns. which are ID and Image path. So now … |
| | Hi, can we import .xls file in mysql? or how to upload .csv(Comma delimited) with multiple language using Load data? how to save multiple languages in .csv(Comma delimited) ? |
| | Hi, I was asked by my lead engineer to configure and migrate current database to elasticsearch that he believe will overcome the slow query issues . We are using laravel 5.2 , and using Amazon Web Services : Amazon Elasticsearch Service . I already done a proof of concept on … |
The End.