Community Member
Member Avatar
pty 618 Replied To a Post in how to add two input value?
Topic by MD_28 in Web Development
php
You need to provide more info. Is this a form you're submitting to the server to calculate or do you want all this to happen in the browser? Have you tried anything yourself? Reply by pty
Member Avatar
pty 618 Liked / Shared how to add two input value?
how I can substract value from balance when i input value.
when i add value , it will be added to balance.
please see like example below:
https://imgur.com/a/9EeviDi Topic by MD_28 in Web Development
php
Member Avatar
Topic by David_133 in Web Development
I think you're approaching this from the wrong direction. You should be storing the start date and calculating the increment using `datediff` in a computed column.

If you need more complicated logic (like zero days being displayed as one day), take care of that in the application and just store … Reply by pty
Member Avatar
pty 618 Replied To a Post in Ink or toner printer for work
Topic by Alexander_15 in Hardware
If you *really* care about image quality (say if you're printing fine art photos), Inkjet is better. For almost all office environments where most printing is black text with the odd image that's not going to be hung on a gallery wall, Laser is more convenient and faster. Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Delete all tables from schema
Topic by overwraith in Software Development
What's the advantage of this over `drop schema myschema`? Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Biggest DaniWeb pain points
Topic by Dani in DaniWeb Community Feedback
Perhaps there is another solution.

When new members make posts, hide them by default until admins have marked them as being a non-spammer. Once they've been greenlit, show them.

## Pros:

* Most spammers will fall into the trap and their spammers and their posts will vanish without the average … Reply by pty
Member Avatar
Topic by anitg in Databases
Hello Anitg,
that was my fault, I wrote for MSSQL.

However, mysql V8.0 supports the WITH Syntax.
[Click Here](https://dev.mysql.com/doc/refman/8.0/en/with.html)

With an earlier Version of MySQL I would suggest to use a View instead.
Basically put that statement from the WITH clause into a View like this:

MySQL-Syntax:



CREATE VIEW `aggregateddata` … Reply by flashx4u
Member Avatar
pty 618 Replied To a Post in PHP SQL Adding Column Values of Two Tables
Topic by anitg in Databases
There most definitely *is* a one-query solution. You'd effectively have to do both stages of the route I suggested in one go, using subqueries and a union.

Using views to simplify the process is not really a compromise, that's what they are there for. If you don't want them to … Reply by pty
Member Avatar
pty 618 Replied To a Post in Title for web based system final year project
Topic by Nurul_3 in Web Development
> my project is about the cleaning service app

"Cleaner than your mom" Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Biggest DaniWeb pain points
Topic by Dani in DaniWeb Community Feedback
Just to add, my last comment was made in reference to a spam post advertising holidays that briefly appeared in this thread. On its own it sounds rather prickly! Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Biggest DaniWeb pain points
Topic by Dani in DaniWeb Community Feedback
And here lies the problem. Not to mention the 11 year old green underlining thread that was just resurrected. The reason people like and keep going back to SO is because you just don't see spam and shitposting like this. Reply by pty
Member Avatar
pty 618 Replied To a Post in PHP SQL Adding Column Values of Two Tables
Topic by anitg in Databases
I'd do this in stages. Create a view where for each table you summarise totals by the month, you'll need to use `extract` or `date_part` to split the date into `year`and `month` integer fields, which you'll group by, and `sum` to get the monthly totals. Then your joining of the … Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Biggest DaniWeb pain points
Topic by Dani in DaniWeb Community Feedback
Posts like [this](https://www.daniweb.com/programming/web-development/threads/516332/javascript). They should be deleted instantly. To be honest, for new members, the post shouldn't even become visible until an admin has verified it. It's **pollution** and it damages the site. Reply by pty
Member Avatar
Topic by rproffitt in Software Development
If you're a developer and list your skills and past places of work there you simply become a magnet for recruiters and are inundated with requests. Some recruiters are ok, most aren't, and a large proportion of the offers I get are extremely low quality or not even remotely suitable. … Reply by pty
Member Avatar
Topic by rproffitt in Software Development
Microsoft has a mixed record. LinkedIn was barely touched (and remains a cesspit of the highest order), Skype was mangled and is a shadow of its former self, as was Nokia. Others, like Yammer and aQuantive were just absorbed.

If Microsoft change too much too soon, GitHub users may leave … Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in eBay really sucks
Topic by happygeek in Community Center
I'm a frequent eBayer and in all the years of buying I've only been stung once, a long time ago, and stupidly I used nochex instead of PayPal and couldn't even trace the scammer.

Now I only buy expensive things (more than say £20) from UK based sellers with excellent … Reply by pty
Member Avatar
pty 618 Gave Reputation to Asim_10 in How to create counting ?
I want to ask that " In some sites we see that when some peoples comments or share or click they got coins or points" so how to make this type of scirpts ? First Post in Topic by Asim_10 in Web Development
Member Avatar
pty 618 Replied To a Post in JSON and databases
Topic by Hajar_1 in Programming
If you're using a capable database you can create a JSON field, but as with every choice there are pros and cons.

The pros are, of course, flexibility. Providing your JSON is valid, it can be stored, no matter how complex or nested.

The cons, funnily enough, are also related … Reply by pty
Member Avatar
Topic by wa0h@arrl.net in Software Development
If you want a cross-platform UI that doesn't suck golf balls through a hosepipe I'd recommend Qt and [Qt-Creator](https://en.wikipedia.org/wiki/Qt_Creator).

It's extensive, well-tested, been around since the mid nineties and has bindings for plenty of languages, but works best with C++.

Lots of [high-profile commercial software](https://en.wikipedia.org/wiki/Qt_(software)) and [big open source projects](https://www.kde.org/announcements/plasma-5.5.95.php) … Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Who might have interest in building a Dazah app?
Topic by Dani in DaniWeb Community Feedback
LinkedIn has an [extensive API](https://developer.linkedin.com/legal/api-terms-of-use-upcoming). Of course they restrict aspects of it because they don't want people competing *against* them, and Salesforce is Siloed so wouldn't really be suitable for the "professional dating" thing. Xing is the LinkedIn of the German speaking world.


> Any of the people I typically … Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Who might have interest in building a Dazah app?
Topic by Dani in DaniWeb Community Feedback
> to provide matchmaking between users

Is there value in that?

I know there is value in informed matchmaking but you need a high quality pool of users and companies. Can DW's userbase (which if I'm not mistaken is Dazah's too) support this kind of use in the real world? … Reply by pty
Member Avatar
Topic by Arwym in Web Development
Sounds like a bug in the API to me. Did you write the backend too?

I'd use a tool like HTTPie/cURL so you can accurately and repeatably test requests Reply by pty
Member Avatar
Featured pty 618 Replied To a Post in Encryption Example
Topic by overwraith in Software Development
SSH with keys is the way to go. Written and vetted by cryptography experts, battle tested, hugely widespread and supported by all modern deployment mechanisms.

Rolling your own encryption routine can be fun, but it [probably won't be that secure](https://security.stackexchange.com/questions/18197/why-shouldnt-we-roll-our-own). Reply by pty
Member Avatar
pty 618 Replied To a Post in border-collapse
Topic by davy_yg in UI / UX Design
css
Ah, one of my posts is editable and one isn't.

![Screen_Shot_2018-04-26_at_09_43_11.png](/attachments/large/0/70fd9d93ca03eba2a2a620f374255d8e.png)


The difference is that the first was made on my phone and the second on a computer.

If there was a bug tracker I'd raise one. Reply by pty
Member Avatar
pty 618 Replied To a Post in border-collapse
Topic by davy_yg in UI / UX Design
css
Has the edit button disappeared? My last post doesn't make sense, it should say 'your failing css'. Reply by pty
Member Avatar
pty 618 Replied To a Post in border-collapse
Topic by davy_yg in UI / UX Design
css
Learn how to combine CSS selectors. Clue, your failing for is looking for a `table` within `#profitlosstbl`.

https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Selectors Reply by pty
Member Avatar
pty 618 Replied To a Post in table css
Topic by davy_yg in Web Development
css
The `cellpadding` attribute has been dropped, the suggested method these days is to use `padding: val` in css. Reply by pty
Member Avatar
pty 618 Replied To a Post in Select from multiple tables
Topic by k_7 in Databases
He's clearly not tried anything Shark_1, it's just a homework question he's pasted.

Giving him the answer will encourage this kind of behaviour in the future and further pollute our industry with *qualified* idiots. Not giving him the answer pollutes the forum with shitposts.

The only sensible thing to do … Reply by pty
Member Avatar
pty 618 Replied To a Post in table css
Topic by davy_yg in Web Development
css
You want your table and every cell within it to be `5px` wide and have `5px` padding?

I think you should start by learning [how CSS selectors work](https://developer.mozilla.org/en-US/docs/Learn/CSS/Introduction_to_CSS/Selectors). Reply by pty
Member Avatar
pty 618 Replied To a Post in Select from multiple tables
Topic by k_7 in Databases
The fact this post hasn't just been deleted is a bad sign. Burn it with fire. Reply by pty