10,938 Topics
 | |
| | Hello, I'm looking for the download solution from data on MySql to file .ical aims to import to Outlook Calendar. Do you have something to share with me? Thank a lot. |
| | Any body help me how to use stored procedure and sample code for how to use. I dont know usage of stored procedure. Currently i am facing interview questions on stored procedure |
| | Hello, please help me sold this issue. It can read the content on the MySql table but when I change the value on the input, then click on Submit, nothing is updated on the table. I don't know why. <?php global $wpdb, $current_user; $user_id = get_current_user_id(); $sql = 'SELECT `slot`, …  |
| | I have my codes here, i cant update my database using this codes please help. if(isset($_GET['submit'])){ $servername = "localhost"; $username = "root"; $password = ""; $dbname = "elev8groupportal"; $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } //$req_code = $_POST['req_code']; … |
| | Hello, I hope that I can get an answer for this question. I have a MYSQL table for charges which contains the following fields: ChargesID, ChargesTitle, OfficialFees and ProfessionalFees. What I need is to make a dropdown list which contain ChargesTitle and upon selection to autofill the OfficialFees and ProfessionalFees. … |
 | I have a problem with mysqli syntax. I really can't see what the problem is in this code. I dont know much about it. When i use it on a function like this public function Somefunction() { $query=mysqli_query($this->db,"SELECT title,url,img FROM table WHERE status='1' ORDER BY id DESC")or die(mysqli_error($this->db)); while($row=mysqli_fetch_array($query,MYSQLI_ASSOC)) { … |
| | hi, I am creating a form for user to update their details which is saved in the database. So far i can show their details in the form where i have a submit button but the updating part doesnt work(it doesnt update at all). here is the code: [CODE] <html> … |
 | Hello everyone, I have been using xampp for my web app developments for quite a while now. Usually after the app development is done, I upload my files to paid hosting. Now, this is the case I'm designing a school's accounts managements software which will be used on an intranet. …  |
| | I was wondering if someone could tell me how I could store audio files in a mysql database |
| | I am trying to update for some products their category in Database. But I get an error and and I dont understand where my statement is wrong. Please help me. I want to find products that have in their name a specific word and after that I want to update …  |
| | I am trying to force log out an inactive user from my CMS. The timeout value is stored in a value called PREF_TIMEOUT in my database. Ive borrowed this code and modified it a little. The code does not seem to be doing anything. Does anyone know of a better …  |
| | In a form, I am displaying a select box value , based on that select box value i show two more select boxes using ajax in div id. And I don not know about session, I want to save that in session using ajax . How to do? |
 | Hi all :) Before i'm starting futher more about my problem. lets me tell a short description about my program. user will choose path ID (retrieve all this data from table TPATH of database SDO) that they want to delete. before the path ID would be delete, it will compare … |
| | Good evening, I wanted to know if we can create a table with an array type fields with phpMyAdmin , thank you |
| | I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the … |
| | hello I have an application run in php with mysql database that shows me a list of people in different services it occupies. I would like to make a menu that is based on the clicked service shows me the list of persons who holds this service and each new … |
| | Hi, In a representative table, I have fields, like, id, mark_id, rep_id rep_name, father name,etc, In this table, rep_id field is empty, And in rep_area table, the fields are like id, rep_id, dist_id,etc, in this table, rep_id has values. While editing the representative form i want to display rep_id from … |
| | I am quite new to web development, so I naturally came to a point where I needed some help. I am making a web site where the user has to log in, and if authentication is successful, the user's data will be fetched from server and displayed on page (and … |
| | function view_report($dateval1, $dateval2, $id) { global $connection; $query_get = "SELECT * FROM presence WHERE p_date BETWEEN {$dateval1} AND {$dateval2} ORDER BY DATE"; $query_confirm = mysqli_query($connection, $query_get); if(isset($_POST["show"])) { while($record = mysqli_fetch_assoc($query_confirm)) { $output = "<tr>"; $output .= "<td>" . $record["p_date"] . "</td>"; $output .= "<td>" . $record["p_day"] . "</td>"; $output … |
| | <?php $this->user_id = $_SESSION['user_id']=$user->id; //create a database connection mysql_connect("host","user","pass") or die("Error:".mysqlerror()); //select database mysql_select_db("db"); ?> <html> <body> <link href="tab.css" rel="stylesheet" type="text/css" media="all" /> <table id="box-table-b"> <tr> <th>User ID</th> <th>Status</th> <th>I.P</th> <th>Offer Id</th> </tr> <?php $result = mysql_query("SELECT * FROM clicks where userId='$id'"); //return the array and loop through each row … |
| | Hey everybody, I'd like to get some specific, but not all rows of a MySQL DB into an array, like those I get if I use mysql_fetch_array(). But feth_array, fetch_row, fetch_object, etc... just returns one row. There are many search functions in the internet, so it must be possible. I … |
 | Hi guys i have simple problem that i can't seem to solve and has been frustrating me for some time i am a newbie when it comes to Codeigniter so be kind hahah, okay so on to my problem i have form validation on a subscription form that seems to …  |
| | Hi I am trying to read the datas from mysql using php in json. but i am not getting my expected output. Please help me to fix the issue. **code** <?php include('../config.php'); //mysql_query("SET NAMES 'utf8'"); $tdate = date('d-m-Y'); $url = 'url'; $sql = "SELECT * FROM pimage where date<='$tdate' and … |
 | I'm trying to implementing faceted search in a Jewellery store, but failed. Problem is when try to filter the attributes table. structure is as follows: Products Table: Id Product_Code Product_Name 1 ABCGOLD1GM 1 gm Gold 2 ABCGOLD2GM 2 gm Gold 3 ABCGOLD394 3.94 gm Gold Attributes Table: Id Attr_Name Alias … |
| | Hi, I am displaying list of jobs that are posted by admin from mysql db. In that Table I used requisition_id (job id) , and the datatype is varchar(255), if we click the job id , it will show the description . My problem is, if it more than one … |
| | Hello, Is it possible to join two tables from two different databases? I have the following query whereas the table named "calendar" is in a separate database than the table named "history". Any ideas on how to join bottom? SELECT C.theDate as day, IFNULL( sum(case when DATE( CAST( H.timeentry AS … |
| | Hi, No matter what I do I get the Access denied for user error.I watched the video but still get it. Are there any common errors I should be aware of in setting up a db user? Thanks, duchaine |
| | I have a large MYSQL / PHP in a while loop report being run and in many cases the report times out due to the large amount of data being calculated. Is there a way to make have a div displaying "Processing" when the while loops is calculating and if … |
| | Hi I have this query: `SELECT SUM(`KN`) + SUM((COALESCE(`EUR`, 0)))*7.5 FROM log WHERE `KN` IS NOT NULL and `EUR` IS NOT NULL` And it retunrs 0 SUM(`EUR`)* 7.5 should be zero but SUM(`KN`) is 60. I am not shure what I am doing wrong here, I want to add numbers … |
| | Hi, I have created a test procedure (for the sake of example to get this working) called test_proc like below - DELIMITER $$ CREATE DEFINER=`tloken`@`%` PROCEDURE `test_proc`(In user_id varchar(100), OUT message varchar(1000)) BEGIN set message ='OK'; END and calling it from php test page like below - $sso = $_GET['sso']; …  |
The End.