10,946 Topics
 | |
 | I need to update my records normal password into Md5 passwords.my query was like that UPDATE testing SET password = MD5('Manojano234') This query was working fine but i need to add plain text also  |
| | Hi guys, I can't get passed this error: Call to a member function bind_param() on a non-object. I have spent hours looking for insights, and can see that my $statement returns FALSE, but have no idea why? My understanding of PHP is limited, so it might help if I actually … |
| | I'm struggling with my hosting company and have had to move to a new one fairly quickly. I've transferred the pages and the databases over quite easily, but have run into an unexpected problem in the form of the error message below. > Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to …  |
| | Hi Guys I am trying to select and display on the RadGrid. i am using sqlDataSource. i have 2 Tables (Users and DealerShip). User table i have attributes (UserID(pk),UserName,Email,Phoneand DealerShipID(fk)) on DealerShip table i have attributes (DealerShipID(pk),DealerShipName) and now here is what i want to do. on my grid i … |
| | For loop error problem Method: for($i =0;$i<count('$std_id);$i++) { for($j=0;$jcount('$sub_id;$j++) { mysql_query("INSERT INTO mmst_tbl(std_id,sub_id,mark)VALUES('$std_id[$i]','$sub_id[$j]','$mark[$j]')"); } } How to solve this? instead of 138 rows it goes 2000+ lines |
| | Dear all, I have created a website where I would like my users to register and upload profile images to my server and then store it under folder in my server known as "images" and then save the dataurl of the images into MySQL database. Then, I would display their … |
| | Hi, I am trying to get same field name from different tables. And i am using like the below query to get the field name. I am expecting some other queries to get distinct 'function_name' column from 'N' of tables. SELECT function_name FROM base_table UNION SELECT function_name FROM firstcall_table UNION … |
| | Here I have this error java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) if I execute this thing GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION; then I have this error. ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO) |
| | so i have 2 tables here CREATE TABLE tblAcctPrd ( strAPCode VARCHAR(50) NOT NULL, datAPStartDate DATE NOT NULL, datAPEndDate DATE NOT NULL, PRIMARY KEY (strAPCode) )Engine=InnoDB; which is the parent table and CREATE TABLE tblEntry ( <----the child table strEntCode VARCHAR(50) NOT NULL, datEntDate DATE NOT NULL, strEntType VARCHAR(50) NOT … |
| | i want to clear all data in databse automatically for everymonth.iam using xampp.  |
| | Hi, i have a " Deprecated: mysql_real_escape_string()" and a "Deprecated: mysql_query" error while running my webpage in function.php and users.php. I would like to know how to change this following code to be uptodate connect.php <?php $db = new mysqli('localhost','root','','madmax'); if ($db->connect_errno){ die('Sorry, we are having connection problems.'); } ?> … |
| | Hello, I have a table with a filed Customers defined as int(10) I have the following query: SELECT * FROM 'table' where `Customers` = 'a' This query returns all entries which have 0 in this field, BUT a is not equal to 0 as we know? Also I can use … |
| | protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter pw = response.getWriter(); InputStream inputStream = null; // input stream of the upload file // obtains the upload file part in this multipart request Part filePart = request.getPart("audio"); if (filePart != null) { // prints out some information …  |
| | Hello all, I have a J2EE application that displays a dropdown of items, in Arabic text. This data is stored in a table in underlying MySQL server. The DB character set is set to utf8 and I have in my JSP the carset encoding as utf8 as well. This works … |
| | i have a register and login page where the users can register and login. their details gets saved in the database. my requirement is that when the user will login to the account, they should be redirected to their profile page, where they can view all their profile details. Till … |
 | hello there, i have a purchase requisition table in mysql like below: pr no qty items 1 10 pencil 1 5 ballpen 1 8 eraser I would like to display them in tabular form and eventually the users should be able to edit. But my program does not assign the … |
| | Hi, thanks in advance foy your time. I have in the past made a inventory site where a user selects from a dropdown what he or she has and saves it but this is a little different... What I'm attempting to do is this... User creates an account (have the … |
| | I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns … |
 | this is my first time of creating trigger..I tried to create trigger using mysql to count how many 2007 data in the table when inserting new record but it not working....... My table have more than 50 data... CREATE TRIGGER No_of_Publisher_year Before Insert ON Book FOR EACH ROW SET @Count_No=New.Copyright; … |
| | I am trying to update several rows in the database using mysql statement. My code is as follows. <?php $query = mysql_connect("localhost","root","toor"); mysql_select_db("busticket",$query); $result=mysql_query("Select * from ticket_reservation WHERE validate_status='No'") or die(mysql_error()); while($row=mysql_fetch_array($result)) { echo "<tr><td><input type='checkbox' id='name' name='name[]' value=".$row['id']."</td><td>".$row['userid']."</td><td>".$row['busid']."</td><td>".$row['numberofseats']."</td></tr>"; } echo"<tr><td><input type='submit' name='submit' Value='Validate Tickets'></td></tr>"; if(isset($_POST['submit'])) { if(is_array($_POST['name'])) { $qry … |
| | I am using jodatime for datetime. When I persist the date in mysql it stores 2015-09-04 10:30:18 instead of 2015-09-04 14:30:18. My timezone is GMT+4 or UAE. Do you know how to change the timezone? I try to put GMT+4 but it does not work. I run this line on … |
 | Hello i want to put more than one values in a table's row |
| | Hi! I am trying to upload files (.docx, .pptx, .pdf) to an online MySQL database and later be able to save/download it locally to my pc. I am trying to develop a software that could do this particular task using VB.NET and MySql. I have a tbl_proposals with fields: - … |
 | Dear, I need help, how to import my Excel file into Mysql Database. I can successfully upload excel file but its not correctly formated uploaded or imported. please check this image,  My HTML Form looks like, <form enctype="multipart/form-data" method="post" role="form"> <div class="form-group"> <label for="exampleInputFile">File Upload</label> <input type="file" name="file" … |
 | This is about “https://www.daniweb.com/web-development/php/tutorials/499320/common-issues-with-mysql-and-php” i created a new thread because that is a great tutorial and I believe that comments underneath it would troubled the reader. Hello Diafol , I believe that this tutorial should be linked in the “read first” section , but to be honest I don't believe … |
| | ## Contents ## Overview 1. Alternatives to Deprecated mysql_* Functions 2. SQL Injection: What to do with $_POST and $_GET variables 3. How to Insert Tablenames and Fieldnames Properly 4. What to do With Dynamic Values? 5. How to Use Aggregate Functions (COUNT, SUM, MIN etc) 6. How to Paginate …  |
| | My entity class: @Entity @Table(catalog = "emp", name = "person") @XmlAccessorType(XmlAccessType.FIELD) public class Person implements Serializable { private static final long serialVersionUID = 1L; /** */ @Column(name = "ID", nullable = false,length = 50) @Basic(fetch = FetchType.EAGER) @Id @XmlElement String id; /** */ @Column(name = "ADDRESS", length = 50) @Basic(fetch … |
| | Hello there, iam new to this forum but iam also new with retrieving data from a mysql database to an label in vb.net. Iam using vb 2010 and my mysql is hosted on a server. Here is my code: Imports MySql.Data.MySqlClient Imports System.Data.Sql Imports System.Data.SqlClient Public Class Gamefrm Dim con … |
| | I'm at my wits end, perhaps after working non stop for 7 hrs. I'm trying to develop a simple search engine using Php and Mysql. I have borrowed my idea of doing this from a wonderful [youtube tutorial](https://www.youtube.com/watch?v=OPmBJhhuwSM) by nick frosty. Unlike Nick, i'm not doing this the procedural way … |
| | Hi all, I'm quite a new developer, and I've spent a long time trying to figure out what is causing this error: "SQLSTATE[HY093]: Invalid parameter number: parameter was not defined" As far as I can tell, all my parameters are defined? My code is below: $mySQL_query = "INSERT INTO vd_users … |
| | Im trying to understand the buffer settings for MySQL 5.1 Default settings for the buffers im interested in is key_buffer_size=384M read_buffer_size=16M read_rnd_buffer_size=16M My question is to improve performance how should we be modifying these? In the past I lowered the values but logically that doesn't make sense to me. Changed … |
| | how to ransomize multiple choice questions from mysql database which i had imported from excel style sheet and then print it .. |
| | I have lot of values in mysql database. I want to display all that data in excel file. How to do? without plugin is it possible? or how to do? Without any plugin, is comfortable. I am new to this concept. |
 | Hi everyone, I have about 20 simple queries running seperately on loading a php page with mysql querying. On my localhost the page takes about 3 seconds to load but on the live server this is over 30 seconds. I'm trying to shave some time off but I'm having trouble … |
| | Hi All Masters I'm trying to create a form with multiple labels from mysql database, im confused to add newlabel text from records here's my code Dim str As String str = " Select koderoom from room " da = New MySqlDataAdapter(str, conn) ds = New DataSet da.Fill(ds, "room") For … |
 | When I try to create a database with a non root user of MySQL I get this error. -> MariaDB [(none)]> create database cl_db; -> ERROR 1044 (42000): Access denied for user 'garrett'@'localhost' to database 'cl_db' How do I allow my recular username to create databases? Thanks. |
| | hi all. I have got below code from a website. Its work all but its can't delete the selected multiple row. plz help me... where is the problem. [code] <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="forum"; // Database name $tbl_name="test_mysql"; // Table name … |
| | Hi friends i am trying to display dynamic dropdown using php. but it is not fetching the second dropdown value. I collected the below code from internet. please help me to fix it. <?php $dbc = mysqli_connect("localhost","root","escape123","tsheet"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " … |
 | Hi , I want to create a class in lib folder , from that class want to create mysql view . such as in mysql CREATE VIEW rocket_current_activities AS SELECT rocket_activities.status AS status from rocket_activities.... This can be do in mysql but how to do from rails. I dont want … |
 | Hi! I am facing problems with sql server 2008. I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features were displaying 1- sql server configuration manager 2- send errors and reports 3- sql server installation center. But other features … |
| | The following SQL query would return 1 record with a min(unit_cm): select id, name, category, min(unit_cm), unit_Cost, unit_price, unit_costPerc from ( SELECT a.id, b.name, e.name as 'category', (d.unit_price - d.unit_cost) as 'unit_cm', d.unit_cost, d.unit_price, ((d.unit_cost/d.unit_price)*100) as 'unit_costPerc' FROM menu_items a, item b, menu c, price d, categories e where a.item_id_fk … |
| | I dont know how to connect C# to MySQL can someone help me? |
| | Imports MySql.Data.MySqlClient Public Class EmployeeInfo Dim con As MySqlConnection = _ New MySqlConnection("server=127.0.0.1;user id=root;database=bsit3d") Dim cmd As New MySqlCommand Dim da As New MySqlDataAdapter Dim dt As New DataTable Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Private Sub display_Click _ (ByVal sender As … |
| | Hi Guys I am beginner in PHP i am getting Warning: mysql_fetch_array(): Eror... anybody help me Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home4/kksivash/public_html/drngpit/student-portal/admin/model.php on line 76 function get_deptbyID($id=""){ $sql = "SELECT * FROM department where id = ".$id; $result = mysql_query($sql); $row = mysql_fetch_array($result); …  |
 | Hello all, i am stuck on this.. i want to be able to play a video from a mysql database. Currently i can upload the video to mysql (name, type, size, content) and download the file. i have a media player that shows a video, but i have to use … |
| | SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist.  |
 | Hi Php'ers, I'm new to Php. I have some issues INSERTING date to MySQL by PHP. here's my code snippet: //date format $date1 = mysqli_real_escape_string($_POST['j_avail']); $d1 = date('Y-m-d',($date1)); $date2 = mysqli_real_escape_string($_POST['j_expir']); $d2 = date('Y-m-d',($date2)); the query: $sql = "INSERT INTO table (....,j_avail,j_expir) VALUES (....,'$d1','$d2')"; the HTML: <td id="ititle">Availability :</td> <td><input …  |
 | Hello, Please as at this morning everything was fine, but all of a sudden all data record wiped off from 3tables in my database, now my client can't find records. Am using MYSQL, Visual Basic. Thanks. |
| | Good day to you all, I ham having an issue the the following error (Fatal error: Call to a member function fetch_result() on a non-object in on line 167) which is the while ($row = $result->fetch_object()) every way I try to change this another error crops up. If yo can … |
| | 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 ,,, … |
The End.