I come across this problem every so often and end up having to do work arounds when I would prefer to keep it in the database. I have a query where the data in the query updates frequently so the query won't stay in the cache but I don't need the query to be accurate. I was trying to avoid adding an extra step of storing the data in a temp table and having to update it on a timer. Does anyone know of a way to get MariaDB or MySQL to Keep the result set for a period of …

Member Avatar
Member Avatar
+1 forum 11

Hi everyone, right now I am looking for a database b2c (consumers) from the UK and SPAIN with more than 200k leads. This is to buy, someone interested?

Member Avatar
Member Avatar
+0 forum 2

Really hoping someone can help me out or point me in the right direction. This is my first ever post in a coding forum so I apologize in advance if I’m breaking any forum rules. I already have a bunch of php code sorted from modifying web resources. I need help altering it further to help me accomplish my goals. Below I’ve included my code, along with screenshots of the code executed in a browser and my MySQL database table. Background: I’m a professional musician but I have extremely basic computer programming knowledge. Nothing formal.. I use google, YouTube, Forums, …

Member Avatar
Member Avatar
+0 forum 2

Hello, I'm quite nub in web development, so be gentle please. If this place is wrong for such problems point me to a more appropriate resource please. To became more familiar with web-programming I found good (as I thought) area for self-improvement. One of my friends owns web project. This project was developed during last 15 years with one programmer who seems to be slightly tired and probably is needed for backup. I've tried (for the very beginning) copy all stuff to the new development environment and found that project consists of several tens of sites: site1.domain.name, site2.domain.name, etc. So …

Member Avatar
Member Avatar
+0 forum 1

can you help me add a write and read function to the program below #include <iostream> #include <conio.h> #include <windows.h> #include <stdio.h> #include <fstream> using namespace std; struct daerah { char kel[50]; char kec[50]; char kota[50]; }; struct data { int nomor; char nama[50]; char tinggi[20]; char status[20]; char pekerjaan[20]; char tempat[20]; char tanggal[20]; char almt[20]; char jenis[50]; daerah alamat; }; main() { int menu; int no_sim=-1,i,j; int pilih; int namedit; data sim[20]; char get[1]; bool ketemu; menuutama: system("cls"); cout<<" ---------------- Aplikasi Data Pelanggaran Lalu Lintas ---------------"; cout <<" \nMENU UTAMA :\n\n"; cout<<" 1.Menambah Data Pelanggaran\n\n"; cout<<" 2.Mencari Data Pelanggaran\n\n"; …

Member Avatar
Member Avatar
+0 forum 1

I have a lecture is there anyone who can help me to change the source coding below to OOP C ++ I / O which uses #include <fstream> so that when the file is written can be saved and when the program is closed then we can still write the data back #include <iostream> #include <conio.h> #include <windows.h> #include<stdio.h> using namespace std; struct daerah { char kel[50]; char kec[50]; char kota[50]; }; struct data { int nomor; char nama[50]; char tinggi[20]; char status[20]; char pekerjaan[20]; char tempat[20]; char tanggal[20]; char almt[20]; char jenis[50]; daerah alamat; }; main() { int menu; …

Member Avatar
Member Avatar
+0 forum 2

Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would enter the quantity they are putting on the stock. For example, TOM puts 150 pcs of -product1- in stock. Then Bill will take 50 pcs of the same product1. So the system would do the calculation: 150-50 = 100 pcs left in stock. When TOM will put again 110 pcs …

Member Avatar
Member Avatar
+0 forum 2

I am looking to create a database to record when students' work has been handed in to the office. I have created the form but it needs to be able to record who signed in the work. There are several people working in the office and will use the database. How can I record who logged in to the database to accept the work on the form itself?

Member Avatar
Member Avatar
+0 forum 5

this is may code on adding or saving image in to mysql DB Private Sub SAVECATEGORY_Click(sender As Object, e As EventArgs) Handles SAVECATEGORY.Click If PictureBox1.Image Is Nothing Then MessageBox.Show("Please Insert image ") addcategoryclear() 'you call ddcategoryclear() to clear textbox and picturebox ElseIf TextBox1.Text = "" Then MessageBox.Show("Please Insert Image Name") addcategoryclear() 'you call ddcategoryclear() to clear textbox and picturebox Else Dim ms As New MemoryStream '...........need to Imports System.IO from general PictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png) ' ........save IMAGE cn.Open() Dim command As New MySqlCommand("INSERT INTO `category`( `IMG`, `NAME`) VALUES (@IMG,@NAME)", cn) With command.Parameters .Add("@IMG", MySqlDbType.Blob).Value = ms.ToArray() .AddWithValue("NAME", TextBox1.Text) End With If …

Member Avatar
Member Avatar
+0 forum 9

![help1.png](/attachments/large/4/f82a18611583d3d8a689ee71b5a6bc3b.png) it hard for me to explain what the problem, but the thing that i need your help is , how to retrieve the ID to listview, im trying to create a POS project like on restaurant or fastfood store, in the listview it will retrieve image ang name, but if listview is click the image will copy to picturebox, the name will copy to textbox1 and the ID will copy to textbox , use the ID the name and picture can be change to update, please help me how to get the ID

Member Avatar
Member Avatar
+0 forum 8

Hello guys , can you help me how to get the ID from mysql DB , if the listview is click the name and the ID well retrieve to textbox1 and textbox2, i dont know how to get the ID?, on the listview the ID wasnt retieve , can you help me how to retrieve the ID from db

Member Avatar
Member Avatar
+0 forum 3

<form class="nice-form" action="" method="post"> <?php session_start(); // echo "<script>console.log('test')</script>"; // echo "<script>console.log(".var_dump($_SESSION) .");</script>"; // echo var_dump($_SESSION); // echo var_dump($_POST); include("../connection.php"); if (isset($_POST['action'])) { if ($_POST['action'] == "assign_user") { $doorId = $_POST["door"]; $username = $_POST["username"]; $approverId = $_SESSION["id"]; // echo var_dump($_POST); $sql = "SELECT * FROM user WHERE id = '$username' "; // $sql = "SELECT * FROM door_permission WHERE door_id ='$doorId' and user_id = $userId "; // echo $sql; $result = mysqli_query($connection, $sql); // echo var_dump($result); $row = mysqli_fetch_assoc($result); // echo var_dump($row); $userId = $row["id"]; if (mysqli_num_rows($result) > 0) { $sql = "REPLACE INTO door_permission (door_id,user_id,approver_id,status) VALUES ('$doorId','$userId','$approverId','allow')"; //echo $sql; …

Member Avatar
Member Avatar
-1 forum 1

hello, im going to create POS project, can you help me how to retrieve all image from mysql db to listview, so that i can view all image that i save to my db, i already save image and use sreach button on retrieve image from db to picturebox. thank you guys . the code below is not retrieving image from db to listview, but if you click listview it will retrieve image from db to picturebox Dim constr As String = "Data Source = localhost; User ID = root; Database = chamchamber" Dim cn As MySqlConnection Dim cmd As …

Member Avatar
Member Avatar
+0 forum 8

I want to see your suggestions on comparing CPanel and FASTPANEL. I used CPanel for some time but later I changed to FASTPANEL which is absolutely free but provides you with the same opportunities. Also FASTPANEL's design looks much better than CPANEL's one. So now I can't understand why people pay for CPanel. What panel do you guys use and why?

Member Avatar
Member Avatar
+0 forum 8

Hello. I have a quick question. I am making a database as a personal project (I am using Microsoft SQL Server therefore I am using its SQL syntax). All it does is that it keeps track of singing groups and bands, the members in these groups, albums they made, songs they did and awards they won (for example, I can insert The Beatles into the Database and record all their members, when they debuted, when they disbanded, their songs and more). For now I am only going to create a table that can store the group's/band's name and another table …

Member Avatar
Member Avatar
+0 forum 5

I want to print database value on multiple pages using C# using HasMorePages property. I have worked on the same, but the loop goes infinetly (without stop) and the same data is repeatating on each page, how to solve it?

Member Avatar
+0 forum 0

Heres a pic of my database table ![Screen_Shot_2019-11-16_at_2_35_54_AM.png](/attachments/large/4/0749479693675147a0ccc8219b89e87f.png) Im trying to create a search page with drop down selectors to filter through each of the last 8 columns. I want the the drop down selectors to be able to select multiple entries (I have this working already) I also want them to preload values from data already entered into my table columns. (I also got this working with the help of tutorials... although I admit I don't fully understand how this part works) Using these tutorials i've created a php page that contains 8 drop down selectors that automatically pull …

Member Avatar
+0 forum 0

Hello. I'm currently preparing a seating system in VB. May i know how can I change the booked seats into available by clicking "Reset" button? My database consists of "Booking" table that comprises the booking details and "Seating" table that comprises details including "Availability" whereby once the seats are booked, it will change the seats from available to booked under "Availability" column. As per my understanding, when i click the "Reset" button, it will delete the records in "Booking" table and update "Seating" table from booked to Available under "Availability" column. This action would lead my booked seats turn to …

Member Avatar
Member Avatar
+0 forum 8

analyze the problem. walkthrough the code. I would like to charge for this solution $10 to Renewal Computer Services, if I may post here (kids & teens free). when -50 is reached, doesn't blow past the maxvalue+1U and cause a cpu-hogging forever loop, it doesn't actually reach -50 equivalent (UINTMAX-49). #include <cstdint> #define ufordown0(var,maxvalue,step) for(uint64_t var=maxvalue; var>maxvalue; var-=step) /* Example: ufordown0(i,200U,50U) { } */

Member Avatar
+0 forum 0

Our website is hosted on wordpress and now we are facing an issue of files permissions its getting changed automatically by particular time duration in daily basis. At initially file permission is (755 or 644) but after few time ago it change itself and becomes files permission to 000. The actual issue is files could not execute over my website its showing fatal error because of permission of file is not permitted to execute it. due to this problem i was unable read/write/update any file of my website even tho i was unable to change it via FTP/Wordpress/Cpanel of any …

Member Avatar
Member Avatar
+0 forum 1

here is the normal rows coming ![WhatsApp_Image_2019-11-04_at_2_32_36_PM.jpeg](/attachments/large/4/f5be1a527695a5bf62797e287c220820.jpeg) i want to show the group by product name with the count of store as the below picture ![WhatsApp_Image_2019-11-04_at_3_28_58_PM.jpeg](/attachments/large/4/b96ff7cb890fb01e6de9e5540a7e7a9e.jpeg) here are mysql query SELECT i.barcode, i.name, u.company_name, COUNT(i.id) AS IQTY, COUNT(U.id) AS UQTY FROM inventory i, USER u

Member Avatar
Member Avatar
+0 forum 1

Hello DaniWebian's, This is Muhaimin Sheik, I'm a passionate web developer as back and front end. I was very friendly and helpful person. I want more know about the techie knowledge. Please guide me. Thank you all...!Cheers...!

Member Avatar
Member Avatar
+0 forum 1

help with ER diagram for package courier service systems

Member Avatar
Member Avatar
-1 forum 2

can someone please help me with coding. I need to create a dropdown menu with the options being the category the user has inputted into a file upload page.

Member Avatar
Member Avatar
+0 forum 2

How do I echo selected option? <?php session_start(); if(isset($_SESSION['cherianne'])){ }else{ header("Location:login.php"); } include("../includes/header.php"); // Retrieve our critical page setter variable. $char_id = $_GET['id']; //echo "<h1>$char_id</h1>"; // set this as a default value if (!isset($char_id)) { $result = mysqli_query($con, "SELECT bid FROM cde_blog LIMIT 1"); while ($row = mysqli_fetch_array($result)) { $char_id = $row['id']; } } // Step 3: UPDATE the DB with the new info from the form. Validate first. if(isset($_POST['mysubmit'])) { $title = strip_tags(trim($_POST['title'])); $message = strip_tags(trim($_POST['message'])); //echo "$title, $message"; $valid = 1; $msgPre = "<div class=\"alert alert-success\">"; $msgPreError = "<div class=\"alert alert-danger\">"; $msgPost = "</div>\n"; // Title Validation if((strlen($title) …

Member Avatar
+0 forum 0

CREATE TABLE Peaje ( id_no_pk CHAR(2) NOT NULL, nombre VARCHAR(30) NOT NULL, localizacion VARCHAR(30) NOT NULL, dirrecion VARCHAR(50) NOT NULL, tipo CHAR(1) NOT NULL, municipio_fk CHAR(2), CONSTRAINT Peaje_id_no_pk PRIMARY KEY(id_no_pk) CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)); CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)) * ERROR at line 9: ORA-00907: missing right parenthesis The parenthesis are in pairs and match. Why would this error message occur and how could I fix it>? Edit: this is the other Table for reference: CREATE TABLE Municipio ( id_no_pk CHAR(2) PRIMARY KEY, nombre VARCHAR(20) NOT NULL ) ;

Member Avatar
Member Avatar
+0 forum 1

Hello members, I am kind off new to working with self joins oe self referencing tables, I am wondering how one would update a self join table considering the table aliases naming. Your help will be appreciated. If some one can point me to a good resource, I will be highly grateful.

Member Avatar
+0 forum 0

after i key-in the form, the function change the whole column with the same value for example if i put first name JOHN it will update whole column with JOHN <?php session_start(); require_once("connection.php"); if (isset($_POST['edit'])) { session_start(); $s=mysqli_query($con,"UPDATE user SET first_name ='" . $_POST['first_name'] . "'"); $row = mysqli_fetch_assoc($s); if ($s) { $_SESSION['user_name']=$_POST['user_name']; $_SESSION['first_name']=$_POST['first_name']; echo "<script type='text/javascript'>alert('Successful - Record Updated!'); window.location.href = 'profile.php';</script>"; } else { echo "<script type='text/javascript'>alert('Unsuccessful - ERROR!'); window.location.href = 'profile.php';</script>"; } } ?>

Member Avatar
Member Avatar
+0 forum 3

How to use pivoting WIth join of 3 tables without Aggregate function within it

Member Avatar
Member Avatar
+0 forum 2

So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect a lot of people are going to my website, like more than 20 people in a day, but here is the question or discussion? how and where do I begin learn about databases, I don't really care what language I am going to use, like sql or php, is sql …

Member Avatar
Member Avatar
+0 forum 7

The End.