11,093 Topics
 | |
| | hello ....... i am new in php i have started cms for the college but i am stucking in exam module . our college requirement is like this that they would enter questions from ms word and they want that every student should get randomize questions from one another ,,, … |
 | Hi everyone - Just a quick request for help please, I am trying to add two additional country codes to the following if statement. if ($country_code == "GB"){ I would like to add or "sct" or "wls" - But everytime I try I get error messages... Sorry if its a … |
 | .............................. <form action="introducere.php" method="POST" enctype="multipart/form-data"> .............................. <td>Picture 1:<input id="picture1" name="picture1" type="file"><br> Picture 2:<input id="picture2" name="picture2" type="file"><br> Picture 3:<input id="picture3" name="picture3" type="file"> </form> .............................. **introducere.php** ............................ if(isset($_FILES['picture1'])){ $file = $_FILES['picture1']; $file_name = $file['name']; echo $file['name']; $picture1 = $file['name']; if(!$picture1){//if no picture browsed $picture1="NULL"; } } if(isset($_FILES['picture2'])){ $file2 = $_FILES['picture2']; $file_name2 = …  |
 | Hi guys! Im trying to get the ighest value from any array coming from mysql query. What i've till now is it! class vfsClass{ function localvfs() { try { $sql = $this->link->prepare("select Vfs_ID from tbl_track order by id asc"); $sql->execute(); $rs = $sql->fetchAll(PDO::FETCH_ASSOC); return $rs; } catch (PDOException $e) { … |
 | Hello, i have a problem with a variable i use to call a statement. The statement its ok, returns data from database as wanted, i checked it on phpmyadmin. I think that the problem is on the variable. Here is the code $select =mysqli_query($db,"SELECT * FROM table WHERE row is … |
| | Hello Everyone, So I've begun a new project, in an attempt to show off my progress with Javascript. I'm making a little text-based RPG. However, I would like for it to permanently save your character and their progress. Thus, I need a MySQL database. I won't lie, I've only used … |
 | Hello i want to know how create form signup php&mysql And how security form for inpot with insert data in database 1- firstname 2- lastname 3 -password 4- ُEmail |
| | Am coding a college council voting system for my school in netbeans and mysql saver. i have populated jtables containing cadidates (jtable1 for president, jtable2 for vice president etc) and i have put a jbutton so that after sellecting candidents of choice one from each jtable, you click the jbutton …  |
| | hello daniwebers... I am really stuck with this design of tables for calendar. Here is the thing...there are employees in a specific company. Each employee accepts customers of the company per day. The number of customers is limited by the doctor on a day by day basis. So for e.g. …  |
 | Hi i am currently building a admin section for my website but i am stuck at a certain point, right now my user authentication is working and my form validation is working great, when i log in as admin i want it to display the admin dash and when a … |
| | Hi I am newbie to PHP. I just wanted to create a registration page for students. In that page I've populated checkboxes for students who wants to enroll more than one classes. Everything got done. But I'm stuck with the final phase of this idea. I just wanted to save … |
| | Hello there.. I am currently working with the referral program and I have a page wherein it displays all the personal information of a person who referred by the user login.. I have 2 functions for displaying the records.. Number 1 is just displaying the records when you go to … |
| | Greetings everyone! I have some codes in my application which makes a backup of mysql database and save the backup .sql file to a location on the hard disk. I made the code in like 2013/early 2014, I think I was then using a now older version of mysql, it … |
| | Hi all! I have developed my application in VB.NET that uses a mysql database. From my application, I can make mysql backups and restore them. When i take a backup, the result is a .sql file which is saved somewhere. But as usual, one can open that sql file with …  |
| | Hi. Below is the code which parse data from mysql into json, but for the name column i want to have <a href="http://example.com">column name</a> instead of jst the column 'name'. is it possible in any ways. <?php $link = mysql_pconnect("localhost", "user", "pass") or die("Could not connect"); mysql_select_db("userdb") or die("Could not … |
| | I want to create a table with input fields where student records can be inserted. The name of the students are in the first column of the table fetched from the database with a while loop. The other columns contain fields for inputing the student scores. The challenge I'm facing …  |
| | Hello, I am trying to create a little bit tricky part I thought I would be sucessfull but it didn't happend. Okay so I created a form having multiple field with the same name like users adds package details so it depends on him how much he would be able … |
| | My goal is to populate my HTML table with SQL results that I pull from the below PHP code that I have written. Keep in mind that in reality my hostname, username and password variables do have string data in them. The first block is my PHP where I am … |
| | please i need your help , there is audio playlist im working on and im try to get music from mydql database and i can get the music file to play but playlist is blank. this is my code html code: <ul id="playlist1" style="display:none;"> <li data_path="assets/mp3/music1.mp3" data-thumbpath="assets/thumbnail/img.jpg" data-downloadable="yes" > <p><span … |
 | Hi, I need to drop tables from a database where all the email addresses end in the same domain, ie, say I have 1000 email addresses i need to input an MYSQL query to delete all rows containing email addresses ending with @mydomain.co.uk. Does anyone know how to do this? |
| | I need to crearte pdf file from database table using java with multiple rows and column format design . |
 | hi i am attempting to change my connection from mysql to mysqli so far i have gone through all the files in the script and replaced mysql with mysql and i went to check what id done so far and i got the following error can anyone help in this … |
 | registration table broker_id , email , affiliate_id.....etc 40 abc@gmail.com 9999 62 xyz@gmail.com 8888 affiliate_Stats table status_id , affiliate_id , banner_id , campaign_id , clicks impressioins , ctr , sale , sale_price, total_earned...etc 27 9999 3 0 0 1 0 29 9999 3 0 1 0 0 affiliate_chain id name recruitedby … |
| | Hi everybody, pls i need help here. i ve a video player and i want to populate video on it from mysql database, here is my code. <ul id="playlist1" style="display:none;"> <li data-thumb-source="assets/img/ddd.jpg" data-video-source="assets/video/ddd.mp4" data-poster-source="assets/img/ddd.jpg" data-downloadable="yes"> <div data-video-short-description=""> <div> <p class="minimalDarkThumbnailTitle">ddd</p> <p class="minimalDarkThumbnailDesc">dddd.</p> </div> </div> <div data-video-long-description=""> <div> <p class="minimalDarkVideoTitleDesc">dddd</p> <p … |
| | i want to implement forum on my site so please help me to integrate the same  |
| | My problem Im almost certian is a permissions issue but im still very new to this so bare with me. I have a server running the latest mysql with mysql workbench installed and im tryign to modify the users and privilieges for either my one table or all my tables, … |
| | I am not sure if this is possible or not, but I need help writing a query for a running balance report. I tried a few queries on my own; I've come close but not exactly what I need. For convenience, I've created an sqlfiddle: [Click Here](http://sqlfiddle.com/#!9/caa5c) The report needs … |
| | Hello i have formatted my pc with Windows 7 and installed wamp server. My local project doesnt work. I am familiar with the difference between mysql and mysqli? Do i need to install a most recent version of Mysql than the one provided by Wamp Server? |
| | Hi Guys. I have the following scenario: 1. I have build abig management database at our HQ and it is to be fed from several databases spread across regions. 2.I only want to have records of specific tables from those distributed databases be sent to my central database.Changes in Those … |
| | >/ we have three table like follwing </ weather=> id shop_id temp_c datetime shops=> id gstIncludedSales GST_Inc_Sales, gstFreeSales transacion=> id transaction total time transaction_date shopid >/ i have apply this query ... select HOUR(transaction.time) as Hour ,TRUNCATE(sum(transaction.total),2) as Total_Sales,shops.gstIncludedSales as GST_Inc_Sales,shops.gstFreeSales as GST_Free from transaction,shops where transaction.shopid=shops.id and transaction.shopid=7 and … |
| | Converting mysql to mysqli. i need help av been scratching my head how to make necessary changes but its like am making more errors. please help or give direction what to change.. <?php session_start(); include("php/class.user.php"); $msg = ""; $msg2 = ""; //$submit = $_POST['btnaddnew']; if(isset($_POST['btnaddnew'])){ if(empty($_POST['txtUserId']) || empty($_POST['txtFname']) || empty($_POST['txtMname']) … |
| | Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. CREATE TABLE mysample … |
| | I am retrieving from table based on standard and date. For first standard It, has two sections A & B. A has one subject and B has two subject. While displaying I want to display in a table like this: section | Description A | English B | French,English My … |
| | Dear community, today I am facing a new problem, maybe due to a black out. I am trying to select from a table based on the results from a select statement, however, the result only contains the first few characters of the field. The main table has the field "category" … |
| | I need help with creating a "user account" website (i.e. Facebook, Twitter, etc). I have a home page set up, i just need to have the it jump to the "user's profile page" once they login their credentials (username, password). I know it has something to do with MySQL/PHP. Can … |
| | <grumpy> :( 2 years run an offline mirror of the site, ensuring MYSQLI and MYSQL act exactly the same in my situation, duplicating every transaction Checking and modifying the scripts, there are some dfferences: backed up the DB, uploaded the altered scripts, went live; the host crashed Currently running from … |
| | hello, I am having a problem opening my database. Before this I could directly go to phpmyadmin after logging in to cpanel without entering username/password. Today, I was directed to a page to enter username/password before going to the database so I did but I got this warning: Warning in … |
| | **Hello, please help me on this. I want to select from these table,** table name: User | Register_date | --------------- | 2015-02-04 | | 2015-02-04 | | 2015-02-14 | | 2015-03-14 | | 2015-04-04 | | 2015-04-14 | table name: Reservation | Order_date | Amount | ----------- | ------ | … |
| | Really need soem help here. I'm new to Mysql. my server crashed on me two days ago. I was able to do some data recovery to access the mysql file. the problem is how do i go about getting access my tables after this. I have no backup to restore … |
| | I forgot what type of hashing used for passwords in my database. How can I recover passwords in my database? -Any solution to my problem? or any suggestions? -Thanks in advance. |
| | Hi . I am writing sp that i will use for generating SSRS reports . In the sp , i hv passed month name as input parameter. I am able to get the required output but need to filter it based on months .i.e entries present for current month upto … |
| | I am trying to update data but i get this error. `Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 ' username … |
| | I'm referring to this tutorial: http://www.techfounder.net/2009/02/02/selecting-closest-values-in-mysql/ My query and code to execute search (This doesn't return any result).I need to get 100 closets value to the postcode given by user which is collected by $postcode = $data['postcode']; ERROR shown are: 1) Fatal error: in C:\wamp\www\search\ajax2.php on line 79 2) PDOException: … |
| | Hi all, Below is my sample data. I am trying to get the 'product' name only if the percentage count is varying. Could you please suggest your maximum no of 'Mysql' queries to approach this. Thanks in advance. Input: ============================================== percentage product ============================================== 100.00 A 100.00 A 100.00 A 2.18 … |
| | Hello, I am right now having a dedicated server and when i try to execute a INSERT query in table of 2 Lakh rows it takes about 0.02 seconds. so i am having a website where i need to update all 2 Lakh rows every 15 mins. but it sims … |
| | I am trying to code a search box that will search though a column in my database. If the search matches the column then that record will be printed in the table below. I am searching on a column that contains the county of a company record. There are no …  |
| | <div class="panel-body"> <div class=" col-xs-12 col-sm-12 col-md-12 col-lg-12"> <form class="form-inline" role="form" action="leadentry.php" method="POST"> <div class="form-group form-groupp"> <label>Business Name</label> <input class="form-control" type="text" name ="business_name" placeholder=""> </div><br> <div class="form-group form-groupp"> <label>Contact person</label> <input class="form-control" type="text" name="contact_person" placeholder=""> <div class="person" id="TextBox_person > <button id="add_person" type="button" value="Add more" class="btn btn-default btn-sm" placeholder=""> <span class="glyphicon … |
| | Hello, I'm using fpdf library to generate pdf invoice. I manage to view the pdf invoice for one item row only. below is the code: $qry = "SELECT invitems.itemId, invitems.invoiceId, invitems.itemNumber, invitems.ChargesID, invitems.itemDesc, invitems.itemAmountO, invitems.itemAmountP, invitems.discountAmount, charges.ChargesTitle, invitems.itemqty FROM invitems LEFT JOIN charges ON invitems.ChargesID = charges.ChargesID WHERE invoiceId = … |
| | Good afternoon, I have a very little knowledge in php mysql. I want to make a periodical report of my company's strength of various departments. I have a html page like <!DOCTYPE html> <html> <head></head> <body> <form action="" method="post"> Department : <select name="dept"><option>admin</option><option>finance</option><option>motor dept</option><option>logistics</option></select> Designations:<select name="design"><option>clerks</option><option>executives</option><option>helpers</option><option>drivers</option></select> No. of employees:<input type="text" …  |
| | $str="james//bond"; $str= mysqli_real_escape_string($con,$str); //insert query after successful insert in database it value shows as "james/bond" how I can insert exact string |
The End.