Programming Forum

Hi all, I have been confusing myself for days over this so bear with me if it gets a bit confusing. I have a table called tags with columns id, name which list all unique tags (linux, php, mysql, etc.). And I have an array that includes some tags that have been entered: $tags = array('linux,php,mysql'); Now when the array has just one tag I can search the tags table and return whether the tag already exists in the table or not. But I am unsure how I can go about checking for each array item. My thinking on how …

$stmt = $dbconn->prepare("SELECT * FROM `members` WHERE username=? AND password=?"); $stmt->bind_param("ss", $username, $password); Is what I have. Database is connected etc. How can I set variable called `$dbresult` with array of SQL result? I don't want to set individual variables. I really need an entire array as answer. There's couple answers but some of them are outdated ("such function doesn't exist in this namespace") and others involve 10+ lines of code-functions that should actually be shorter. What is a clean and finite way to extract entire array out of prepared statement?

Hi this is my question , and I have some error in my code ,and I cant correct them ,and I am asking if you could help me ? this is the question : Create a class called BloodDonor that maintains information about blood donors in a blood bank having the following data members: 1. IdNumber, // long int 2. name, //Name of donor 3. bloodGroup//String 4. home_Phone//String 5. mobile_Phone//String 6. address // struct Address that holds int house number, int road number, int block number, string city, and string country It will also have the following member functions: 1. …

Write a program to sort an array of integers in ascending order by using pointers Write a program to sort an array of integers in descending order by using pointers

Hi there, Not sure if I am in the right place, but I wanted to ask where I can access a csv file for all the streets in Belgium?

My experience with C# is very very limited and a simple python program like the one I'm trying to convert is beyond my experience in C#. If anyone knows of any converters or is willing to help me out I would greatly appreciate it! class ByteReader(object): """ Reads bytes from a file. """ def __init__(self, filename): self._buffer = list(bytearray(open(filename, 'rb').read())) self.pos = 0 self._eof = EOFError('unexpected end of file') def read_byte(self): """Read one byte.""" try: byte = self._buffer[self.pos] self.pos += 1 return byte except IndexError: raise self._eof def peek_byte(self): """Return the next byte in the file. This can be used …

please if anyone could tell me, how it would be possible, i want to save the content of a uploaded word document in database field with php, no problem with encrypted file like ( ´V z2Ö<
Ö<
ôÿÿÿÿÿÿ·üü?????ÿÿÿÿSSS8‹DÏLS¥9à
1) as it shows if you open a word document in a browser. just want to save content of whole document in field. thanks for help in advance. i read it somewhere open file with fopen save it in variable n then save it in database, is it possible in that way ?

Hi there, I've come across an issue while trying to get all the records from a SQL database in java. A bit of necessary introduction here. I'm not using any framework just JDBC and the getAllBooks method is part of a REST call. The failing method is essentially doing this: -getting the number of all records in the db; -getting all the ids and use them to get the records, store them in an array and return that array; Unfortunately the call generates the following error in the while loop: SEVERE: Servlet.service() for servlet [Jersey Web Application] in context with …

So im actually creating a fastfood menu in which save how many times a button been clicked as a variable. So I can multiply it to its value. For example if i click btnChicken a variable will count how many btnChicken been clicked then it will multplied on the amount i set for the value of each chicken.

public bool Kayit_Ekle() { sorgu = string.Format("Insert Into [{0}] ([SERVİS FORM NO],[ÇAĞRI NO]) Values ({1},{2})", sheet, formno,cagrino); cmd = new OleDbCommand(sorgu, Baglan()); cmd.Parameters.AddWithValue("@{2}",cagrino); int etkilenen = cmd.ExecuteNonQuery(); if (etkilenen == 0) { return false; } else { return true; } } Hello there, I am writing recording program with c #. but I'm saving to excel. My question would be: I note excel data but does not start from the first row for example, it starts to record the thousandth continue to lower the bottom line . my goal is to go down to the bottom line at a time …

I am trying to use many employees, but I do not how I can use case in my arrays. Could you help me, please? ---- program StaffSal(input, output); uses Crt; const SalRate = 0.1; A = 150; B = 85; C = 95; D = 120; type Employee = record Names, Position: string; OctSales, NovSales, DecSales, JanSales, MarchSales, AprilSales, TotalSales, Salary, thPay: Real; end; var Staff : array[1..6] of Employee; q : integer; TotalSalary : real; begin for q := 1 to 6 do begin Write('Enter Employee name : ') ; readln(Staff[q].Names); Write('Horas laborales del día lunes: ') ; readln(Staff[q].OctSales); …

function username_exists($username){ global $db; $sql = "SELECT 'username' FROM users WHERE 'username' = '$username'"; $result = mysqli_query($db, $sql); confirmquery( $result ); if (mysqli_num_rows($result) > 0) { return true; }else { return false; } } if(username_exists($username)){ $error['username'] = 'Username already exists'; }

Here is what i get when compiling py to exe using cx_Freeze... I used Admin cmd too... but it keep give me this error.. how can I make it right...please help me with this. C:\Windows\system32>"C:\\Program Files (x86)\\Python38-32\\python.exe" "E:\\New folder\\Python Player\\Setup.py" build running build running build_exe pygame 1.9.6 Hello from the pygame community. https://www.pygame.org/contribute.html error: [Errno 13] Permission denied: 'E:\\New folder\\Python Player'

Hi all, I have a question about updating two values in a sql table using a subquery. My database is called books and the below table books too: id title author location_id 11 Tera Netrear 4 14 Disser Bubu 1 15 Tenno Puoio 4 16 Oban Tyrone 5 18 Sisnobi Teru 3 Location_id is indeed another table as it's a foreign key in this table but that shouldn't matter. So what I want to do is to change all the location_id currently at 4 to 2. I know i could do it like this `update books set location_id = 1 …

After minimize the window disappear from taskbar and i can't set that again as it's looping...Is there any other way to minimize or fix that. watch inline code examples. from tkinter import * from PIL import Image, ImageTk import time from ctypes import windll GWL_EXSTYLE = -20 WS_EX_APPWINDOW = 0x00040000 WS_EX_TOOLWINDOW = 0x00000080 `Inline Code Example Here` def set_appwindow(root): hwnd = windll.user32.GetParent(root.winfo_id()) style = windll.user32.GetWindowLongA(hwnd, GWL_EXSTYLE) style = style & ~WS_EX_TOOLWINDOW style = style | WS_EX_APPWINDOW res = windll.user32.SetWindowLongA(hwnd, GWL_EXSTYLE, style) # re-assert the new window style root.wm_withdraw() root.after(10, lambda: root.wm_deiconify()) print('done') class modtk(Tk): toptitlebar = None maincanvaswindow = None …

Hey guys, I want to make a simple program which calculates speed, distance and time. This is the code I used: [CODE] a=input("1)Find speed\n2)Find distance\n3)Find time\n4)Quit\n") while a!=4: if a==1: d=input("\nEnter distance: ") t=input("Enter time: ") print ("Speed: "+str(d/t)+"\n") elif a==2: s=input("\nEnter speed: ") t=input("Enter time: ") print ("Distance :"+str(s*t)+"\n") elif a==3: s=input("\nEnter Speed: ") d=input("Enter distance: ") print ("Time :"+str(d/s)+"\n") a=input("1)Find speed\n2)Find distance\n3)Find time\n4)Quit\n")[/CODE] But, my question is, can't it be done like this: [CODE] s=input("Speed: ") d=input("Distance: ") t=input("Time: ") #Considering 1- is the symbol for 'find' s=d/t if(s==1-): print (s) elif(d==1-): print (d) elif(t==1-): print (t)[/CODE] Won't …

> I have already created functions to handle that. But it's shacking when i try to move( After add more widgets). Can somebody help me with that. from tkinter import * from PIL import Image, ImageTk import time class modtk(Tk): toptitlebar = None maincanvaswindow = None resizeon = False dragging = False def updatetopbut(self, event): self.closebutton.config(fg=self.ttfg) self.fullscreenbutton.config(fg=self.ttfg) self.minimizebutton.config(fg=self.ttfg) def downdatetopbut(self, event): self.closebutton.config(fg=self.ttbg) self.fullscreenbutton.config(fg=self.ttbg) self.minimizebutton.config(fg=self.ttbg) def modify(self, title="tk", icon=None, titlebg="#ffffff", titlefg="#000000", bg="#EBEBEB"): self.tt = title self.ico = icon self.ttbg = titlebg self.ttfg = titlefg self.bgbg = bg self.title(title) self.width = 150 self.height = 200 self.maximized = False self.map = 0 self.resizeside …

hi all iam working as software developer i wish to create my blog website using asp.net and C# so any one have idea so please help me in this Please thak you in advance

Dear the gurus; I am a developing a small program for voting of about 5 candidates. The program should compute and return the candidates and their total tallied votes. If a voter enters a number outside 1-5 it should count it as faulty vote. I have the following program but returns an error. Kindly help #include<iostream> #include<conio> using namespace std; const int vs=5; int votesA=0, votesB=0, votesC=0, spoiltvotes=0;//TOTALS ALREADY INITIALISED-GLOBAL char vote; void main() { // loop over the voting stations int i; for (i=1;i<=vs ;i++ ) // loop over voters cout<<"\n Enter your vote:\t"; cin>>vote; while( vote<=5) { switch(vote) …

Visual Tkinter is Python 2.6 GUI builder. Visual Python programming language for advanced Visual Python IDE that offers the possibility. As of December 2008 starting and writing fasting Editor. This software is using Scintilla editing component. <URL SNIPPED>

I'm reading a book about C++. I'm on arrays now. It seems that a two-dimensional array is taken in this way: void Function( int arr[][numberof2nddimension] ) { } Why is that so? Help please. Thanks

I am a developer who recently started working on my own, and I've come across some projects that I can't handle by myself (mostly in React). What resources would you guys recommend for finding / putting together a team of remote developers to join me on these projects?

Greetings to everyone, I am working as a freelance web developer, i have more than 4 years experience in osclass scripts. I am working in the osclass scripts for the past 4 years and have created nearly 67 sites in osclass, and have created many plugins, cuztomized themes, plugin cuztomizations according to the clients need. I saw many of the post was unanswered here regarding the osclass scripts, so i make this new topic those who are wandering for a good programmer for their osclass script, reply me here if you need my support, thanks.

Hello all! I have an excel file that looks like this: Time of Day Lap Lap Tm Speed 14 - Stoicescu Dan - Regularitate Coupe 9:40:50.835 1 2:47.462 88.763 9:43:37.584 2 2:46.749 89.142 9:46:33.319 3 2:55.735 84.584 9:49:58.901 4 3:25.582 72.304 9:53:13.988 5 3:15.087 76.194 9:55:50.639 6 2:36.651 94.889 9:58:49.884 7 2:59.245 82.928 10:02:33.328 8 3:43.444 66.524 20 - Dima Viorel - Regularitate Coupe 9:40:56.287 1 2:46.284 89.392 9:43:39.673 2 2:43.386 90.977 9:46:18.075 3 2:38.402 93.84 9:48:57.580 4 2:39.505 93.191 9:51:38.104 5 2:40.524 92.599 9:54:18.371 6 2:40.267 92.748 9:57:01.825 7 2:43.454 90.939 9:59:51.986 8 2:50.161 87.355 10:02:33.040 9 2:41.054 92.295 …

Hi all, I've been having a problem adding a record to an Access database using datasets and da.update etc. I'm trying to create a simple program that displays the records of a database table in a series of text boxes. I've managed to get my next and previous buttons working correctly and my update button works correctly too. The problem occurs when I try to add a new record. I keep getting a "Syntax error in INSERT INTO statement" whenever I click my add button. My database table has JobID(number), ElectricianID(number), CustomerID(number), Price(number), Date(date), Time(time), Paid(yes/no) Eventually I will have …

Python-wxPython Tutorial This tutorial will take you through the basics of wxPython. ##Introduction: Let's face it. I am a dinosaur. I got my computer science degree in the mid 70s. And it won't be long before **I** am in **my** mid 70s. So why am I trying to learn Python? Mostly because learning new things keeps my brain active. And besides, nobody on Daniweb seems to be asking questions about vb.Net anymore. So I thought I'd give it a try. After a few weeks of puttering I managed to learn enough Python to rewrite all of my vbscripts (stop laughing, …

Hi all I'm trying to put together a room hire site, to be used by the lettings clerks, for our local Quaker meeting house and I've hit a couple of problems. I have an HTML form that, using data from a MySQL database and some JSON and JavaScript, when a certain checkboxes are checked inserts the hourly rate and, if required, the deposit payable on the room chosen. This works fine. However, the value that is displayed isn't being picked up and inserted into the database table. The code for retrieving the data is: $roomRateSQL = "SELECT * FROM tblRoomRates"; …

I'm writing a utility that will likely be called by a script that uses `argparse`, but should be useable by any script. The engine object constructor needs a dozen or so parameters to tune its behavior. The question is: What is the best way to allow the caller to send the necessary parameters without requiring extra work setting params that have defaults. First thought: Since some users will have an `argparse.Namespace` instance already, I might make use of that. But other users would need to create a Namespace (or just a subclass of `object`) which seems like a problem. Second …