10,946 Topics
 | |
| | Hi. I got some problem. I want to search data from 2 tables in database and display the result based on the search value. For example, I search employee id number, it will search the employee id number in table 1 and table 2. If the data exist in either …  |
| | I have a database that has columns called start date, start time, end date and end time and want to be able to output the difference so it shows the total time spent per project. Below is the code I have but it shows the error PHP Fatal error: Uncaught … |
| | <?php $name = $email = $password = $repeatpass = ''; $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['password']; $repeatpass = $_POST['repeatpass']; $con = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $sql = "INSERT INTO user-regis (name, email, password, repeatpass) VALUES ('$name', '$email', '$password', '$repeatpass')"; $result = $con->query($sql); if (!$result) { header("Location: …  |
| | <?php require_once './includes/config.php'; $con = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME); $sql = "SELECT * FROM contact-info"; if($result = $con->query($sql)){ while($row = $result->fetch_object()){ //display record 1 by 1 printf(' <tr> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> </tr> ',$row->id, $row->name, $row->email, $row->phone, $row->comment); } } printf(' <tr> <td colspan="5"> %d record(s) returned. [ <a href="insert-student.php">Insert Student</a> …  |
| | I have managed to get blog posts displayed from each blog category but I want to limit it to 1 article from each blog category but unsure how to do it in the sql query I have, below is what I have so far (SELECT BP.postID,postTitle,postSlug,postDesc,postDate,postImage FROM blog_posts BP, blog_post_cats …  |
 | hi i just came here if theres someone who coudl help me with my problem whenever i add a new user this keeps on appearing\ "INSERT INTO teacher_info (firstname,middlename,lastname,gender,address,date_joined,username,password) VALUES ('John','Doe','Doenut','Male','New york USA','2021-06-11','john','admin') Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of … |
 | I found this peaice of code to import a Access database table to sql server Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click Dim fileName As String = "" Dim ofd As New OpenFileDialog If ofd.ShowDialog = Windows.Forms.DialogResult.OK Then fileName = ofd.FileName PerformImportToSql(fileName) End If End … |
| | > Hi, This little program checks to see if the contract is valid. I have a database field "expiry" (int 3) from which 1 is subtracted when run. As long as the expiry is above 0 I want to redirect to "sysnav.html", otherwise I want to redirect to "expiredpage.html". I … |
| | I am trying to output data for selected dates and think I have managed to do the sql query but it's currently not outputting the total amount, below is what it is currently outputting I am looking for the following From To Expense Category Expenses Total 01/01/2018 31/12/2018 Accounting Costs …  |
| | I am trying to connect MySQL(8.0.25) and python(3.8) using mysql.connector but getting the error: mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Windows 10 same code working for pymysql.connect the code used: import mysql.connector as sql s=sql.connect(host='localhost' ,user='root', password='<correct password>) The password I entered is the one … |
 | --Hi DaniWeb. I have been doying bulk data Uploads from Excel Sheet to MySql data base and hence thought that I may need the reverse of this process and so Export MySql Tables into Excel Format for Backup purposes (I also will be happy for a better suggestion for a … |
| | Hello, so as the title says, I'm looking to include a Session Variable into a MySQL Update statement. I'm not exactly sure what I'm doing wrong, but I certainly know I am. I'm also fairly new to this, so that may explain it lol! Thanks in advance for your help. … |
| | I want to ask how to make when we press the value for the combo box. For other textbox can easily appear. So, the user can do input 2 times. Here I attach my code Private Sub combo1() conn.Open() Dim stringsql As New MySqlCommand("select * from supplier", conn) Dim dr … |
| | Trying to have a script built that locks the content until user refers a friend to signup, then they are granted access. They have a set amount of time, as a timer counts down or their account is deactivated. Its for a game we are creating and want to use … |
 | Hi its Huzaifa From Pakistan! i am a designer (web and graphic). want to learn **programming** |
| | HI!! How can I create an automatic numerical progression from 0 to 500,000 in html? The code I was given is this: <p><span style="font-family: Calibri, sans-serif;"><span style="text-shadow: rgba(255, 255, 255, 0.8) 0px 3px 2px;"><sup>437</sup></span></span></p> how can i make the code progressive and automatic every three minutes? The progression I have … |
| | Hi, the scenario is: I run an apartment complex, someone comes in to pay their rent. I fill in an html form to record payment(update "payments" database table) and print a receipt. I hope u will look at it and offer advice. I hope to combine both the payment and … |
| | Find product who hasn't had any sales in first three months of the year?  |
| | |
| | Im a Computer Science student from the University of the Republic of Zimbabwe. Im an aspiring Data Scientist who is interested in leveraging in the power of Artificial Intelligence to address and solve our daily life problems. i am looking for opportunities to expose, improve and expand my skillset and … |
| | Hi Guys, Im not sure how to word the title of this question, but i have a table called "daily_recyclables". Inside this table, i have multiple columns of recyclable materials (example copper, stainless steel, brass etc etc) In my PHP application, i have a statistic card (like below) that is … |
| | In my workplace, we have an intranet website developed internally that we use for CRM. The data of our clients are shown there (MS SQL server is used as a backend to store data). The site has a limited search functionality at the moment (it'll try to match the text … |
| | Write the main such that it reads two integers: Start and End and calls the void function of part ‘a’ in order to print the average of integers divisible by 3 in the range: [Start..End]. |
| | hello, i need someone to tell me how do i read string in assembly 8086 (nasm) and it would be better to write down the code ~~ thank you |
| | It has been a few years since I actually did real coding... well a few years since i had a job for that. Just dumping about 1000 photos from a directory and want to display them. No magic of fancy stuff. Thanks |
 | Hi all, I am working on a website that requires two queries from a table at the same time. They must select a row based on the id, and then another random one not including the row just selected. I currently have: $query = $pdo->prepare('SELECT title, content FROM cards WHERE … |
| | I need help for my code after the user done register for their new account in my system. Here is the verification link that the user will receive via email for him/her to verified the email: `http://localhost/staff/email_verification.php?activation_code=49024f2e7b8c05dc1g66005g780g6060 ` But, when the user click on above link, I notice based on … |
| | I want to create button delete all records in tables database with php |
 | I have three tables in mysql which make up the dropdown menu, as below code. I would like to get a $ breadcrumb variable with link from this menu. Example: Home / Woman Home / Woman / Clothes Home / Woman / Clothes / Women T-Shirth-2 It is possible?? <div … |
| | Write PHP Script to insert data into STUDENT TABLE with fields (roll,first_name,Last_name,city,contact,gender). |
| | Hello, I want to use the checkbox to update the status of a row in mysql using php. If it is checked and submitted, the status will change from 'collect' to 'received'. I tried many ways but I am not sure where the problem is :( please help! <?php include(config.php); … |
| | Hi everyone here, I'm trying to show information about the material according to the year of meeting(is a meeting when they decide to buy a new material) so I use a drop-down list and the information will show according to the year chosen by the user, but it shows the … |
 | Which is the best user-friendly programming language to be used for developing an ecommerce website? |
| | DaniWeb was written in Codeigniter, and when posting to the forums, we use database transactions that look like this: $this->db->trans_start(); ... insert into the posts table ... ... update the member's post count ... ... update the tags table ... etc $this->db->trans_complete(); On occassion, the error log will show for … |
| | Hi! When I am running this code, the output looks how I expected it to be, but the problem is that I cannot go back to home page whenever I want to. I dont know why but when I tried to go back to home page after visiting the tips … |
| | I have a VB.net project that queries my online database directly. Now I want to use API instead of direct connection. Please I have never done such before and all materials I got online are not learning friendly and some that are friendly didn't have relation with database. And secondly, … |
| | I have the following table: my_contacts which contains the following columns: [CODE]contact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, frist_name VARCHAR(20), interest VARCHAR(20)[/CODE] [CODE]-----------+-----------+---------- contact_id | fisrt_name | interest + ---------------------------------- 1 | smith | swim + 2 | mark | dance + ----------------------------------[/CODE] I need to move the interests column … |
| | I got an empty file whenever i download any file. This is an php file where pateint can download his report by entering his appointment id and password. <?php error_reporting(0); include'include/database.php'; if($_POST['sbutton']) { $appid=$_POST['apid']; $password=md5($_POST['pass']); $result=mysqli_query($conn,"select patientId from appointments where app_id='$appid'") or die(mysqli_error($conn)); $row=mysqli_fetch_array($result); $result2=mysqli_query($conn,"select password from patients where id='".$row['patientId']."'") … |
| | <?php $firstname = $_POST{'firstname'}; $username = $_POST{'username'}; $emailaddress = $_POST{'emailaddress'}; $password = $_POST{'password'}; $contact = $_POST{'contact'}; //Database connection $conn =new mysqli('localhost','root','','registration'); if ($conn->connect_error) { die('connection failed : '.$conn->connect_error) }else{ $stmt = $conn->prepare("insert into users(firstname, username, emailaddress, password, contact) vlaues (?, ?, ?, ?, ?)") $stmt-> bind param("ssssi",$firstname, $username, $emailaddress, $password, … |
| | Hi All, I dont know if anyone could help me, I am going slightly mad. I have been following some online demos of creating a simple application using VB.NET / Visual Studio and MYSQL database. I have setup the MySQL database and that looks fine, I would like it to … |
| | I wrote this line of code: database = {"host":host, "user":user, "password":password, "db":db, "charser":charset, "cursorclass":cursorclass} and i'm receiving this: {'host': '35.234.92.142', 'user': "b'freedbtech_'", 'password': "b''", 'db': "b'freedbtech_cursopython'", 'charset': 'utf8mb4', 'cursorclass': "<class 'pymysql.cursors.'>} i need to remove those "b's" and " ' " in the strings, but i don't know how to … |
| | I have an array list that looks like this. 8.1,6.5,4.4,3.2,1,8.9,5,1.4,0.1,1,8.7,6.2,4.3,3.2,3 I would like that my program selects every 5 numbers randomly. for example to select 8.1,6.5,4.4,3.2,1,8.7,6.2,4.3,3.2,3 as you can see it selected 5 numbers from the begging and 5 more from the end and saves them Random random_method = new … |
| | I am currently creating a simple invoice page. But I am also having a hard time retrieving and displaying the price and description of items selected by the userfrom my dropdown (dropdown is populate from database). My knowledge of jquery and php were not that deep yet. I hope someone … |
| | $ array = array ('Main', 'Photo Gallery', 120, 'Rustam', 'Services', 'Lesson 12', 'Link'); This array also contains menu items for the web page. Describe the required menu items in HTML lists. |
| | Good day! I am new in vb.net and I want to detect if there is a duplicate of the record that a user will try to add. If the user adds an existing username from the database then it will show an error that the username has already been used. … |
| | <?php $pdo = new PDO('mysql:host=localhost;port=3306;dbname=crud', 'root', ''); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $title = $_POST=['title']; $description = $_POST = ['description']; $price = $_POST = ['price']; $date = date('Y-m-d H:i:s'); $products = $statement = $pdo->prepare("INSERT INTO products (title, image, description, price, Create_date) VALUES (:title, :image, :description, :price, :date)"); $statement->bindValue(':title', $title); $statement->bindValue(':image', ''); $statement->bindValue(':description', $description); … |
| | Actually I'm studying sciences computer in Belgium |
| | I have two different files, fileA contains employee data (ID and townCode) while file B contains field office data (OfficeID, Town, TownCode, officeCapacity) and a town can contain more than one office. i want to distribute these employees to the offices in the town against their names evenly What I …  |
| | I have my resoruces stored in mysql DB: eg : > |IPaddress | Status| |10.x.x.x| yes| |10.1.x.x| yes| I am trying to get the available resource and after that will update DB with status No. > query = ("SELECT IPaddress from TABLE where status='yes'") cursor = mydb.cursor() cursor.execute(query) result=cursor.fetchall() query1 … |
| | ScanningI'm looking forward to implement a typical "nav" section for the articles in my website. Something like this: **Folder > SubFolder > SubSubFolder** To this end, I think that the best way is to create a database of two tables. The **first** one is called "*Category*": id - title - … |
The End.