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