• Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Search SQL between two dates

    https://dev.mysql.com/doc/refman/8.0/en/keywords.html At least `END` is a reserved word. Use backticks.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Which one is the latest PHP version and what are the features?

    https://www.php.net/ChangeLog-7.php#7.4.12
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Parse error: syntax error, unexpected 'ch' (T_STRING)

    // To protect MySQL injection for Security purpose $stmt = $conn->prepare($SQuery); $stmt->bind_param("i", $user_id); $stmt->execute(); $stmt->bind_result($fullName); $stmt->store_result(); if($stmt->fetstmt->store_result() // <-- this looks like a typo ch()) //fetching the contents of the …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Undefined Offset 1

    It says that `$val[1]` is invalid. Are you sure that `$val` is an array?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How to generate QR Code using php

    http://phpqrcode.sourceforge.net/
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in I'm Out of Here

    > I'm closing on a house today!! Congrats! If you need a modding hand, I'd be happy to help again.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in I'm Out of Here

    > the entire moderation team got fed up and stepped down What!?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in I'm Out of Here

    Thanks for everything Rev, and the best of luck! Perhaps I can take your spammer hammer and do the whacking for you.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Retrieving data from the db with an ID or with a search term?

    I'd probably implement a method like this: @Override @GET @Path("/{text}/search") @Produces("application/json") public BookList searchBooks(@PathParam("text") string text) { dbAccess.connectToDb(); return dbAccess.searchBooks(text); } and perhaps add another parameter to indicate whether to …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in GROUP BY statement returns different values in row table

    Because you are only grouping on `r.reply`. Since there are only two differect replies, With what you've shown the group by could be `GROUP BY c.user_one, c.user_two, c.c_id, r.reply` and …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Communication to Windows COM Object

    Have a look at: Microsoft.VisualBasic.CreateObject() https://docs.microsoft.com/en-us/dotnet/api/microsoft.visualbasic.interaction.createobject?view=netframework-4.8 IIRC, you'll neet to get the type name like so: Type.GetTypeFromCLSID(guid)
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How to check internet connection using C# language

    > In this topic we w'll learn how to check internet connection using a simple code. This code checks if there is a **network connection** available, and will most likely …
  • Member Avatar for pritaeas
    pritaeas

    Gave Reputation to Reverend Jim in Creating a GUI Wrapper for VLC Media Player in python/wxpython

    ## Introduction I have a pile of home movie videos created over more than seventy years. As with my many photos (all in digital form) they require some effort to …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Map XML to SQLite

    > do you have any initial ideas on how to map the hierarchical structure of XML onto a relational structure What is missing from my statement above is that I …
  • Member Avatar for pritaeas
    pritaeas

    Endorsed Diafol_2

  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in MYSQL 8 Query Join Problem

    > I have no idea how to turn something this complex into a pdo prepare statement. Is it just a matter of putting it all on one line? A little …
  • Member Avatar for pritaeas
    pritaeas

    Created Map XML to SQLite

    I'm looking to build a command-line tool that will enable me to read an arbitrary XML file combined with a mapping to fill an existing (arbitrary) SQLite database with data. …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Searching files for a file format

    Execute a shell command: dir C:\*.txt /s/b > C:\txtfile.txt This will output all files with extension .txt on drive C to the file at the end. VB has a ShellExecute …
  • Member Avatar for pritaeas
    pritaeas

    Gave Reputation to Reverend Jim in Regex or string replace to add <p> html tag

    I don't think a regex will do what you want. I don't see how you can define a pattern, based on your example, that could distinguish things you want to …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in What can you tell me about pwa?

    - https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps - https://docs.microsoft.com/en-us/aspnet/core/blazor/progressive-web-app?view=aspnetcore-3.1&tabs=visual-studio
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Check table to see if array items already exist

    > I don't know if that is how you intended to help me, but it certain did either way. Probably not, but you'll find that trying to explain some problem …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Syntax Error in Code

    Looks like the `elseif` on line 13 should be an `if` Only strange thing is that `$ret` is an array, so I do not understand why you check for `$ret …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Random images from imagelist

    ImageList is a container control, not a visible one, hence it does not have a Location property. What you need is a PictureBox control. You can show this on the …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Check table to see if array items already exist

    $tags = array('linux,php,mysql'); Is an array with a single item. If `linux,php,mysql` is a single column in your DB, then you might do this: $tags = explode(',', 'linux,php,mysql'); To get …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Uppercase checker C# VS

    I suggest to use Regex.Match(), because it can determine if the first character is an uppercase letter easily with `^[A-Z].*` https://docs.microsoft.com/en-us/dotnet/api/system.text.regularexpressions.regex.match?view=netcore-3.1#System_Text_RegularExpressions_Regex_Match_System_String_
  • Member Avatar for pritaeas
    pritaeas

    Endorsed d5e5

  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How to change the aspect ratio of an Windows media player by using C#

    `stretchToFit` stretches the player to the size of the parent control. IIRC the player has a `uiMode` which can be set to `custom`. To get the width and height, you'll …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in MY CODE STILL REGISTERS A USER WITH THE SAME USERNAME

    Try SELECT `username` FROM users WHERE `username` = '$username' instead of SELECT 'username' FROM users WHERE 'username' = '$username' (backticks instead of single quotes)
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Chat script Not working with mysqli

    Did you read the quick start? https://www.php.net/manual/en/mysqli.quickstart.dual-interface.php
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How to interact with Servers

    Building an API using the language of your choice can accomplish what you require.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Can you help me with my payroll program

    Please explain your problem.
  • Member Avatar for pritaeas
    pritaeas

    Gave Reputation to Jacob_19 in Academic Survey on Program Comprehension

    Dear software developers, We are researchers aiming to understand developers' knowledge needs and program comprehension. Our intention is to support practitioners in selecting tools that can facilitate developers' tasks. Moreover, …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in VB.NET Insert OLEDB - Syntax error in INSERT INTO statement.

    What are the values you are trying to insert? What do you see when you click "View detail" in the exception box?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Filter by annoyance

    I use/read neither, that's why I remove the filter.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in what do you mean by mime type?

    See here the official spec: https://www.iana.org/assignments/media-types/media-types.xhtml Basically it defines what kind of information you are transmitting.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Filter by annoyance

    If I go to a specific forum, I expect to see the threads on top which have the latest replies (unread by me). If recommended is on, then the order …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Filter by annoyance

    > we simply don’t have enough new content Point taken. > What’s an example of content that you want to see that Recommended is not showing you? I'll have to …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Filter by annoyance

    > Also, you say it's a very poor recommendation algorithm, yet I keep asking and asking and asking ....... please give me feedback about what makes it poor. Personally, I'd …
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Hello Programming

    Hi.
  • Member Avatar for pritaeas
    pritaeas

    Gave Reputation to Koos_1 in Formatted Integer

    Hy guys, how can I read comma delimited list from text file into an array in c++
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Object not found! The requested URL was not found on this server.

    <form method="post" action="registration.php"> Here you submit to `registration.php` > and this if my config.php code while you state that your file is named `config.php`
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Help with VB.NET program

    What do you have so far?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in download file and redirect to page in

    So what is your question?
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in PHP SOAP and NullPointerException

    It works in SoapUI... No typos? `getidspedizionebyrmn` in the WSDL is lowercase.
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in Rewrite Javascript validation code as PHP code

    Here's one hint: https://www.php.net/manual/en/function.preg-match.php
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in List Only Usernames

    This page lists several options: https://www.cyberciti.biz/faq/linux-list-users-command/ One of them is: $ awk -F':' '{ print $1}' /etc/passwd
  • Member Avatar for pritaeas
    pritaeas

    Endorsed AndreRet

  • Member Avatar for pritaeas
    pritaeas

    Endorsed AndreRet

  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How do you handle your CAPTCHA?

    This is the one I' currently using: https://github.com/glacasa/TwoStepsAuthenticator
  • Member Avatar for pritaeas
    pritaeas

    Replied To a Post in How do you handle your CAPTCHA?

    Use it in ASP.NET website for authentication. Found a tool to help build the QR code that Authy can read (or you can manually add the code in Authy). Same …

The End.