10,946 Topics
 | |
| | 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']; …  |
| | Hi I am new to MySQL and not too shure how can I update row form another table while cheking if logged in user is same: `Telefonist='".$_SESSION["UserName"]." And also I need to check if date is the same so It gets to right pearson on right date in a row: … |
| | Hi, Please help me, i try to fetch category list as like below, where category ids is passed in inclause, it returns two rows. mysql> select c_id,c_name from category where c_id in (870,854); +------+---------------+ | c_id | c_name | +------+---------------+ | 854 | Telugu | | 870 | Telugu Events … |
| | Hai i Have developed android mobile apps using eclipse juno and i have connect it with mysql 5.1.73 but i am unable to do it.please help me to sort it out .i am ruunin with following errors. Errors at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) … |
| | Hi i am a beginner in PHP Ajax. i found this code but i want to know how to start to display the table after i select the value from dropdown list. I am also a bit slow in this. All example i have found are only show how to … |
| | I am using the MySQL C API and having problems defining a stored procedure. MY SQL script works fine in MySQL Workbench but the same script fails in my own software. A test script which shows the problem is: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA … |
| | Below is my database structure: PostUUID subid pricing Name Poscode abc1 1 100 userA 56000 abc2 2 100 userA 56000 abc3 1 100 userB 56000 abc4 2 100 userB 56000 abc5 1 100 userC 56000 abc6 2 100 userC 56000 Now I want to perform search on this table called … |
| | Array ( [0] => Array ( [sn] => 1 [mob_no] => 9602858989 [date] => 06-May-2015 [time] => 12:02:33 PM ) [1] => Array ( [sn] => 2 [mob_no] => 7795055128 [date] => 06-May-2015 [time] => 12:29:44 PM ) ) how to insert these array values in seperate database table fields? |
 | I have created a sp little bit confuse about it. how to count result set if data availabe then show it and if not then retun ResultStatus is zero. did not work much with sp. thanks for any help suggestions. CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_GetProduct`(IN `iProductCategoryId` INT) BEGIN DECLARE ResultStatus INT …  |
| | Hi, I am trying to use the mysqlnd_ms plugin on my php installation but when I run any code trying to utilise the "myapp" variable I have set up as per the tutorial it just gives the error: PHP Warning: mysql_connect(): Unknown MySQL server host 'myapp' (1) in /var/www/settings/database.php on … |
| | I am posting it here because I would really like to read other opinions. I am creating a module for a framework that anyone could install in its system and behave the similar (almost) way. I am starting with that because it is important that I don't control system settings …  |
 | Dear all, I have two identical mysql server with same databases and tables structures but with different data. ServerA ServerB Database Shaqib Database Shaqib Table users Table users ID | Name | Phone ID | Name | Phone 1 |Test1 | 123456 1 |Test13 | 1256456 2 |Test2 | 785632 … |
| | Hi guys having some trouble here with my date's output currently it reads 2015-05-05 10:05:22 but i would like to have it render as eg. Monday 12 Mei 2013 how would i achieve this in codeigniter? Here is my code for creating the post: (Controller) public function new_post(){ if($_POST){ $data … |
| | Can any one send me the config setting for jdbc and mysql using apache server setting in netbean. i wanna use jsp with xampp and jdbc |
| | hi there, i have a vps which has crashed and now have a new build of mysql and server. the old drive is mounted and i can access all the web files from the old drive an have download the mysql raw files from the var/lib folder. i uploaded to … |
| | Hi all! I have a form with a combobox, a listbox and 2 command buttons.(see photo and neglect the blank listview) I select items from the combobox and add items to my listbox after clicking the button.(no problem with this) Then, I need to save each item of the ListView … |
| | Hi I have a query and I like to see the result until the condition match. I am trying to find if the end date(+1day) is equal to next row start date if so list it. I have the below query does the job but it also list whole table … |
| | Hello everyone, I'm creating a simpel survey tool'. When people insert the question, they can also what kind of question type (checkbox or radiobutton) Adding question and types in the mysql is oke.. I have a problem with showing the type & question Problem: the questions only show if I … |
 | Ok, here is what I get when I run the query. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near newmessage`int(4) unsigned NOT NULL DEFAULT `0`,`companyi' at line 4 Here is what … |
| | I want to display images based on what user checked from number of checkboxs. I'm trying this code, but it not working <!Doctype html> <html><body> <form method="post" action="" id="myForm"> <div class="opt-first"> <h1><b>Subject</b></h1> <input type="checkbox" value="Account/Finance" name="subject[]" /> Account/Finance<br /> <input type="checkbox" value="Marketing" name="subject[]" /> Marketing<br /> <input type="checkbox" value="" name="subject[]" … |
| | this code will display all courses user has <h1>YOUR COURSES</h1> <form action="delete.php" method="POST"><ol> <?php $con=mysqli_connect("localhost","FYP","123","FYP"); $sql= mysqli_query($con, "SELECT C_Code FROM F_COURSES WHERE F_ID=".$_SESSION['userid']); while($row = mysqli_fetch_array($sql)){ echo "<li name='course'>".$row['C_Code']."<input type='submit' value='Delete'>";} ?></ol></form> I need when user click on delete button that course delete from F_courses <?php session_start(); if (! empty($_SESSION['logged_in'])) … |
| | id name class marks 1 H 1 60 2 H 2 50 3 S 1 70 4 S 2 60 5 V 1 55 6 V 2 80 7 K 1 60 8 K 2 70 This is my table structure. I want mysql query to get result like id …  |
The End.