7,368 Topics
| |
Please help me out. I have a table with one row. I can add rows to it by clicking add button which adds rows through javascript code. I have 3 dropdown columns and one textfield and one more textfield which is not editable. So i need total of last column. … | |
Good afternoon all, The issue I am having is that when POST data values are looped through inside the while loop as each record is compared with the POST data and the database record for any changes. For this test the data from the post is exactly correct. The if … | |
I am trying to put a post feed on the homepage but I am with difficulties on it. I think my query it might be wrong, but I want to pick the username from 'blabs' table and see if that 'username' from the same table is the user or the … | |
The recently active list for admins and mods (team) appears broken, at least regarding myself. Currently it says I was last active 4 days ago, yet I've been on and active every day for the last 4 days (including posting and admin duties - the infractions list even shows my … | |
How to store the following curl_exec output into mysql table? sent,success,114661698,709081462,+919900123456 sent,success,134707665,937687314,+917795987654 Eg: var1='sent' var2='success' var3='114661698' var4='709081462' var5='+919900123456' --------------------------------------------------- var1='sent' var2='success' var3='134707665' var4='937687314' var5='+917795987654' Thanks in advance | |
Hey guys, I am doing a friend list and it's not working very well. Well I tried to show all the user's friends but it's not working, it only shows one instead of all. In MySQL friends_request I have something like this: username1 -> username2 username1 -> username3 username2 -> … | |
help please.. guys this is just the only problem in my program i cant print my data from sql..i need my thesis to finish soon..help please.. heres my code <?php require('fpdf.php'); $fullname = ""; echo $contractno = $_REQUEST['contractno']; echo $sname = $_REQUEST['sname']; echo $fname = $_REQUEST['fname']; echo $mi = $_REQUEST['mi']; … | |
**Note: this project is being restarted after one year of in-action, using the most relevant files I am able to locate. All final code will be adapted to MySQLi.** Versions of this code functioned properly to the best of my knowlege; now, with a new host I am having issues … | |
hi im attempting to update a script and i have come across the following error PHP Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in so here was the orginal $sql = "select * from chat where (chat.to = '".mysqli_real_escape_string($_SESSION['usernamechat'])."' AND recd = 0) order by id ASC"; … | |
/* initialize the calendar -----------------------------------------------------------------*/ var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); /* selects the events to load in the calendar -----------------------------------------------------------------*/ $.ajax({ url: 'process.php', type: 'POST', data: 'type=fetch', async: false, success: function(response){ json_events = response; } }); $('#calendar').fullCalendar({ //events: … | |
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 | |
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 … | |
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 ![XMpE2.png](/attachments/large/4/5770083e49ac1a4334d730c309c84293.png "align-center") 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 | |
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? … |
The End.