[mysql] Forum Topics

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 …

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 …

Hello i want to put more than one values in a table's row

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 …

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 …

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?

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.

.............................. <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 …