10,938 Topics
 | |
| | Hello I am facing a problem while creating a view in MySQL, I tried all the possible solutions I got from internet but was failed. actually I have two **tables 1** is for installment schedule which contains a planned schedules and the **table 2** contains all installment payment which has … |
 | Hello all, I have the following code. Connection connection = getMySQLConnection(); try { Statement st = connection.createStatement(); String SQL = "SELECT ID, NAME FROM STUDENT WHERE ID=5"; ResultSet rs = st.executeQuery(SQL); System.out.println("SQL =" + SQL); while (rs.next()) { // do something... } } catch (SQLException se) { se.pringStackTrace(); } From … |
| | I'm trying to do use X-editable to do inline editing instead of having textboxes and such, I'm editing labels that I would like to send in a post method to update the values in the database. Is there anyway to send any kind of data within the <form> besides using … |
| | My SQL query is: UPDATE REGISTRUDENT set qual=1 WHERE studentolevelsubjects AS sls INNER JOIN courserequirements AS csreq ON sls.subject_id = csreq.subject_id WHERE sls.stud_id = '$stud_id' AND sls.grade_id>=csreq.min_grade AND sls.examno = '$examno' AND csreq.course_id = '$course_id' I'm having issue comparing two different table to get if a registrant qualified based on … |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
| | Hi, I'm trying to insert some values to database based on how many values are clicked but currently it only takes the last clicked field. I have tried hard coding with mysql_real_escape_string and the dreamweaver way. Both still give me the same last picked value instead of several values separated … |
 | I'm trying to reset my mariadb password following this site -> https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/ but when I enter `mysql -u root` I get the following error: `ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")` Any ideas? Thanks. |
 | What's wrong with my code? my save button is not working.. I need help please? thanks! here's my code: <?php include('header.php'); session_start(); ?> <?php include('navbar1.php'); ?> </br> </br> </br> </br> <form class="form-horizontal" method="post" enctype="multipart/form-data"> <input type="text" name="applicant_name" placeholder = "Applicant Name" required> <br></br> Applicant Type: <br/> <select name="applicant_type"> <option value="">Please …  |
| | Hello all, I have an spring MVC app, that connects to my backend MySQL DB. I have my data source configured properly in my spring bean config XML file, as follow: <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3406/mydb" /> <property name="username" value="root" /> <property name="password" value="passwd" /> … |
| | Controller: function addblogs() { $this->load->library('form_validation'); $this->form_validation->set_error_delimiters('<br /><span class="error"> ','</span>'); $this->form_validation->set_rules('blog_title','Blog Title'); $this->form_validation->set_rules('description','Blog Description'); $this->form_validation->set_rules('category_id','Category Name','required'); $this->form_validation->set_rules('position','Position'); if($this->form_validation->run()== FALSE) { $data['categorylist']=$this->blogs_model->categories_dropdown(); $data['mainpage']='blogs'; $data['mode']='add'; $this->load->view('templates/template',$data); } else { $this -> blogs_model -> insertblogs(); $this->flash->success('<h2>blogs Added Successfully!</h2>'); redirect('blogs'); } } Model: function categories_dropdown() { $this->table = 'categories'; $this->where('status',1); $categorylist=$this->dropdown('category_id','category_name'); return $categorylist; } function … |
| | 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 End.