10,942 Topics
 | |
 | 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 … |
The End.