10,940 Topics
 | |
| | 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 ,,, … |
 | 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 … |
The End.