10,942 Topics
 | |
| | I am trying to add new data to my mysql database using tkinter in python. Does anyone have any best practices for doing this? I have tried thus far to no avail. thanks in advance for any help.  |
| | <?php if(isset($_POST['login'])) { require 'connection.php'; include 'password.php'; $email = $_POST['email']; $password = $_POST['pass']; $query = $dbh->prepare("SELECT id,name,email,password FROM users WHERE email = :email"); $query->bindParam(':email', $email, PDO::PARAM_STR); $query->execute(); $userData = $query->fetch(PDO::FETCH_ASSOC); $userEmail = $userData['email']; $hash = $userData['password']; if(password_verify($password, $hash) && $email == $userEmail) { session_start(); $_SESSION['sess_user_id'] = $userData['id']; $_SESSION['sess_name'] = $userData['name']; …  |
| | Hello Guys I want to insert into two tables with one query in mysql the first table contains a primary key and other stuff the second table contains a foreign key and other stuff I'm wondering how this would happen ? and if so how would be the query of … |
| | /////Get gl accounts class///// $sql_class = "SELECT cid,class_name FROM 0_chart_class WHERE cid>=3 ORDER BY cid ASC"; $result_class = mysql_query($sql_class) or die("Error in query: $sql_project.".mysql_error()); echo "<TABLE class='swPrpTopMenu'>"; echo "<th>Account Code</th><th>Name</th><th>Amount</th>"; while($row_class=mysql_fetch_array($result_class )) { $c_id=$row_class['cid']; $c_name=$row_class['class_name']; echo "<tr><td>$c_name</td></tr>"; ////////get accounts $sql_accounts="select ct.name,ct.class_id,cm.account_code,cm.account_name FROM 0_chart_types ct,0_chart_master cm WHERE ct.id=cm.account_type AND ct.class_id='$c_id' GROUP … |
| | Hello, I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client …  |
| | I am building a url shortner application in php and mysql and i am using the follwing logic to create short urls, pls tell me how is it First i fetch the last id from the database using select max(id) from urls then suppose if it returns 100 then i … |
 | Hy now i have this code <div class="row"> <div class="col-xs-12 col-md-6 left"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-primary" href="{{URL::route('displayProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-visual-eye-fill icon"></i>1</a> @else <button type="button" class="btn btn-sm btn-primary view-profile" profile-id="{{$profile->Entity_Id}}"> <i class="icon-visual-eye-fill icon"></i>not</button> @endif </div> <div class="col-xs-12 col-md-6 right"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-info" href="{{URL::route('messageProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-envelope-fill-1 …  |
| | I'm a little bit stuck at this moment. As of now, this is the code that I have: private void btnChangeImage_Click(object sender, EventArgs e) { using (OpenFileDialog openFileDialogForImgUser = new OpenFileDialog()) { string location = null; string fileName = null; openFileDialogForImgUser.Filter = "Image Files (*.jpg, *.png, *.gif, *.bmp)|*.jpg; *.png; *.gif; … |
| | Hi I have a problem with inserting into the database. This is my code : $insert = $db_con->query("INSERT INTO users (username,password,email,com-name,com-logo,com-phone,com-mobile) VALUES('".$username."','".$enc_pass."','".$email."','".$com_name."','".$profile_path."','".$com_phone."','".$com_mobile."')"); |
| | I am building a site where members can create profiles that other members can view. I want to add a favourites feature to the profiles so a member can keep a list of their favourties members. This all works fine but now I want to find a way that a … |
| | hey guys. i have this table that lists contacts that are stored in database. the data is selected from 2 tables using join which i have already got working: SELECT c.contact_id,c.salutation,c.fname,c.lname,c.dob,c.houseadd,c.personalno,c.officeno,c.email,c.spouse,c.child, s.spouse_id,s.s_salutation,s.s_fname,s.s_lname,s.my_spouse FROM contact1 c LEFT JOIN spouse1 s ON c.contact_id = s.my_spouse what im having trouble with is selecting … |
| | hello. i was just wondering if it is possible to insert data for date and time separately into database for a column with type datetime. datetime format is like : yyyy-mm-dd h:m:s . I know you can get date and time separately FROM database but is it possible to be … |
 | How do I fetch data from table into dropdown menu in mysql and post back to another table? What I want is to create a registration form for customers and attach an agent to each customer, the agent names are stored in a table and i need to post agent … |
| | hello. I have a table populated by name. The names are links when clicked will pop up a form for editing. each input (for editing) is populated by the equal value from database but im having trouble with one particular text box. this text box is for date of birth … |
| | Hello, I have been breaking my head here and I can't figure out what I am doing wrong, I am trying the get the result of the first query into variables to then run the second query. It works inside mysql but not insite my php query. $data = mysql_query("select … |
| | I want to count records using datediff() and where condition; I am getting the result with no. of days; but cant count records with condition; below is the my query SELECT DATEDIFF(CURDATE(), jobs.jobs_listed_date) FROM tbl_first_category AS FIRST , tbl_second_category AS SECOND , tbl_jobs AS jobs WHERE first.fc_id = second.sc_fc_id AND … |
| | I'm trying to code a registration form. But I'm stuck at adding a borrowed code of image upload, resize, save and store its path in MySQL database. The error message is "Undefined index: fileimage" on the line where I have this code: if($_FILES['fileimage']['name']). Here is the register.php: <?php // include … |
 | How do I upload photos to a mysql database using php and I again reproduce an image from the database and displayed in the browser |
| | Hi There. I have the following code for a login system withing VB 2010. I am getting a Warning: "Variable 'reader' is used before it has been assigned a value. A null reference exception could result at runtime." Where did I go wrong? Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal …  |
| | I have a Website and i want to backup my MySQL data base from cpanel can anyone help me with the solutions? |
| | hey guys. I've always had problems when it comes to getting data from multiple tables in a database and so now I have another one. I want to get data from 3 different tables: contact1, child1 and spouse1. columns in contact1 where i want to get data from: contact_id | … |
 | i have a prinscreen of the problem http://i.imgur.com/GMJho9r.jpg i use mySQL to create the query and i have a database called tap that contains the events table I try SELECT sensor_id,event_type,value from tap.events where events.time = (SELECT MAX(events.time) from tap.events) group by sensor_id,event_type ORDER BY sensor_id,event_type; I get only the … |
| | |
 | i had some trouble when updating a mysql field, i had 2 text fields and 1 textarea fields, both the text fields updated ok through this query: but textarea field is not updating.. edit.php <?php include('connect.php'); $id=$_GET['id']; $result = $db->prepare("SELECT * FROM telugunews WHERE id= :userid"); $result->bindParam(':userid', $id); $result->execute(); for($i=0; … |
| | how could i send email to list of email addresses inside a mysql database?? i want to create a site helping students find home tuitions. when students fill form regarding subjects they want tuitions ,concerning teachers should get e-mail..tell how can i do this??  |
| | i have a table fieldname like companyname and Created Date shown in below image. in that i want to display data's date wise ASC or DESC, like that if i click companyname the data's will show ASC and again if click will show DESC order format. and here i added … |
| | Hello, i want to allow my users to reset their passwords if they forget it. My problem is that i lose the code sent to user via email, if this is the link sent to user via email http://localhost/citi/forgot.php?code=8b15388bc5ca7e2821ab6ce59b465f684942dd7901f4e31439575ab72028f84f , when the user get to forgot.php and type in the …  |
 | I have this code below for export mysql database to excel..however, if i run this it will only export the html code of the page not the sql query..please help..thank you. <html> <head><title>Exports</title> <link rel="stylesheet" href="css/css.css" /> <h2>EXPORT DATE/YEAR</h2></head> <form action="" method="post"> <table> <tr> <td><input size="40" name="searchString" type="text"class="ed" /> <select … |
 | whenever i use mysql_connect() It gives Fatal errror of using unidentfied function i'm using mysql version 4 on windows 7, what to do? it looks like php never heard of that function, wonder if someone does have a straight forward solution? |
| | help me..view direction and marker on database mysql? |
The End.