Dev Shed Forumshttp://forums.devshed.com/
Dev Shed - Open Source web development forums. Topics covered include PHP, Apache, mySQL, Zope, Jserv, Java, Python, Zend, XML, DHTML, Javascript and more.enTue, 26 Sep 2017 19:57:47 GMTvBulletin60http://forums.devshed.com/images/misc/rss.pngDev Shed Forumshttp://forums.devshed.com/
Request years that existhttp://forums.devshed.com/mysql-help/979100-request-exist-new-post.html
Tue, 26 Sep 2017 15:20:52 GMTI feel this is a really basic request via a GROUP BY, but I must just be overlooking it...
All I want to do is have a set of years returned that exist in a DATETIME column. This list will help PHP generate a drop-down to help the client choose what table to build/view.
The basic of what I have... (`date` is the DATETIME column)
Code:
---------
SELECT `date` FROM `invoice` GROUP BY...I feel this is a really basic request via a GROUP BY, but I must just be overlooking it...

All I want to do is have a set of years returned that exist in a DATETIME column. This list will help PHP generate a drop-down to help the client choose what table to build/view.

The basic of what I have... (`date` is the DATETIME column)

Code:

SELECT `date` FROM `invoice` GROUP BY `date`;

Assuming there's hundreds of rows, I may want it to return a list of 3. Lets say 2015, 2016, 2017. I can always ORDER BY via MySQL/PHP...

Quick question. Would this be a good idea to end up with higher quality list without adding extra step and losing prospects.

1 - once contact opts, send them an email with links to bait.

2 - if contact clicks the link, I'll add them to campaign with API.

Vs

1 - when contact opts in, just add them to long campaign.

What do you experts recommend?

Thank you
]]>Dev Shed LoungeEnglish Breakfast Teahttp://forums.devshed.com/dev-shed-lounge-26/single-vs-double-opt-979099.htmlSSD VPS deals from kvchosting.net at modest rates.http://forums.devshed.com/web-hosting-offers/979098-ssd-vps-deals-kvchosting-net-modest-rates-new-post.html
Tue, 26 Sep 2017 09:41:03 GMTKVC Hosting was started in 2010 with the sole purpose of creating a host company that was affordable to all. Since its inception, the company has had steady growth due to our practical business model, so much so that we've increased the size of our data center in order to meet the demands of our clients. Putting customers first is what drives us, and this has led to us winning multiple awards for providing quality technology at a great price. We focus on providing cost-effective web hosting solutions, and our extensive experience in the industry assures that you will receive high quality and economical web hosting options that can be customized to suit your needs. We are proud of the trust that our partners and customers have placed in us and welcome all to give our company a try.
Be in charge of your own Virtual Private Server (VPS Hosting)! It will work just as if you have your own machine. Our virtual private servers are affordable and powerful, offering you your own mail server and greater security control. SSD VPS Hosting is a great fit for businesses that are anticipating quick growth, huge website traffic, or who run highly dynamic, interactive websites.

What's the best way to get the rough or exact location of ip address? Maybe something like these guys

Thanks
]]>PHP DevelopmentEnglish Breakfast Teahttp://forums.devshed.com/php-development-5/whats-locate-user-ip-979097.htmlhttp://forums.devshed.com/web-hosting-offers/979096-host-proton-litespeed-lscache-http2-quic-nuevo-mariadb-jetbackup-new-post.html
Tue, 26 Sep 2017 07:51:28 GMTHost Proton provides shared, reseller, semidedicated plan solutions and we are working on launching our managed VPS range soon.
We are giving special attention to our reseller hosting plans, since they were designed so that they can be rented quickly.
We provide our customers with the best features of the hosting industry ... let me introduce our reseller hosting plans
*HOSTING...Host Proton provides shared, reseller, semidedicated plan solutions and we are working on launching our managed VPS range soon.

We are giving special attention to our reseller hosting plans, since they were designed so that they can be rented quickly.

We provide our customers with the best features of the hosting industry ... let me introduce our reseller hosting plans

If you need more information feel free to access our website and open chat. So here I leave a post where you will find a form that will give you a discount coupon to start with your HOSTING resellerLink to Post
]]>Web Hosting Offershostprotonhttp://forums.devshed.com/web-hosting-offers-100/host-proton-litespeed-lscache-http2-quic-nuevo-mariadb-jetbackup-979096.htmlEuropean Dedicated Servers From TEMOK at Very Low Price | Location Francehttp://forums.devshed.com/web-hosting-offers/979095-european-dedicated-servers-temok-low-price-location-france-new-post.html
Tue, 26 Sep 2017 07:43:25 GMTDedicated servers offer an advanced level of control, efficiency and also stability as compared to shared web hosting or virtual servers. Temok collection of personal, 'bare-metal' server hardware is available with a range of Microsoft, Linux and other software installed, and deals with each type of hosting, from websites to private clouds. All with 24/7 support and a 100% uptime SLA that we have provided more consistently than any other premium hosting company.

We are offering French Dedicated Servers according to your need & budget. Below you will find some details of it.

We have got excellent hardware accompanied with a first-class support staff. At Temok you will enjoy the experience. We do our best to provide service which is not alone rewarding but also pleasurable. We do the job beyond your expectation and go the extra mile to achieve your requirements.

➛ We accept VISA, MasterCard, American Express, PayPal, WorldPay and Diners Club International for payment.
➛ Orders will typically be processed within 48 hours after verification.
➛ Promotional pricing is available for all our customers.

For further information pleasse contact sales[at]temok.com or Via Skype: temok.sales
]]>Web Hosting Offerstk-hassanhttp://forums.devshed.com/web-hosting-offers-100/european-dedicated-servers-temok-low-price-location-france-979095.htmlCheap Joomla Web Hosting 10% OFF - Hostripples India!http://forums.devshed.com/web-hosting-offers/979094-cheap-joomla-web-hosting-10-hostripples-india-new-post.html
Tue, 26 Sep 2017 06:25:25 GMTJoomla is a free and open-source content management system (CMS) that powers ~2.7% of web sites on the 'net. It's extendable with tons of free plugins and themes. With HostRipples, you can install Joomla with just a click through an automatic installer - QuickInstall. HostRipples offers 100% compatible Joomla Hosting for tens of thousands of sites already, and is the perfect match for your Joomla-based web site.

So, with my cURL, I have managed to load ebay.com homepage.
Now, I need to tell the cURL to:

A). Find the item (search box) that has the following name attribute or id attribute and type the $keywords value onto it.

name="_nkw";
id="gh-ac";

B). Find the item (search button) that has the following name attribute or id attribute attribute and click it.

id="gh-btn";
value="Search";

I would appreciate any code snippet additions to it by anyone.
I am not that much learned to deal with API. Therefore, need the basic code lines that tell cURL or php how to identify items and type in them or click them. General code.

Order VPS at our web-site: 301 Moved Permanently
]]>Web Hosting OffersDeltahosthttp://forums.devshed.com/web-hosting-offers-100/bitcoin-vps-usa-netherlands-ukraine-ssd-vps-windows-vps-extra-ipv4-rent-ip-979090.htmlHow to run a sql file multiple times until control+C is pressedhttp://forums.devshed.com/oracle-development/979089-run-sql-file-multiple-times-control-pressed-new-post.html
Mon, 25 Sep 2017 03:37:13 GMTgenerate output file, then it should ask for schema name again--> generate output.. It should continue until control...]]>Hi All,

I am having a sql file which will extract the synonym list based on user input. It will execute once and it will come out. IS it possible to run the sql multiple times based on user input until control +c is pressed.
[what I meant is user will input schema name first-->generate output file, then it should ask for schema name again--> generate output.. It should continue until control -c is pressed.]Appreciate your help on this. Below is the code.

Quote:

set echo off
set verify off
set feedback off
prompt This script allows you to build a SQL*Plus script file
prompt which will recreate all PUBLIC synonyms referencing
prompt objects in a specified schema.
prompt
prompt To abort execution, press ctrl-C.
prompt
accept SynRefsOwner char prompt 'Schema >'
set linesize 132
set pagesize 0
set termout off
set trimspool on
set trimout on

--Spool the output the file requested by the user.
--spool &SynScriptFileName
spool &SynRefsOwner._synonyms.sql

When running the query without error only delete the 1 record in TABHDBHCHUYEN and the records in the other 2 TABLE not delete record, you see help me wrong? Created a relational table for 3 tables to Delete Rule mode to Cascade but not delete.
]]>Database Managementdongtrienhttp://forums.devshed.com/database-management-46/sql-server-delete-data-linked-table-979088.htmlsent message using wifi without internet connectionhttp://forums.devshed.com/android-development/979087-sent-message-using-wifi-internet-connection-new-post.html
Sun, 24 Sep 2017 14:14:15 GMThello guy
right now i try to develop a very simple app that can transfer message with other device.
this app using same network to allow them to sent and receive message whatever they recognize them.
this app still can transfer message using wifi as access point without internet connection. the app should
be like this https://www.asus.com/zentalk/thread-25939-1-1.html
the problem is i do...hello guy

right now i try to develop a very simple app that can transfer message with other device.
this app using same network to allow them to sent and receive message whatever they recognize them.
this app still can transfer message using wifi as access point without internet connection. the app should
be like this https://www.asus.com/zentalk/thread-25939-1-1.html
the problem is i do not know how to start it. if there is any good tutorials or website, feel free to share with
me.

While talking with a friend about industry-wide shifts in ideology and programming paradigms, I made a joke about combining all the ideas that were universally considered "bad" and pooling them into a single language that somehow managed to be "good". Among these was going back to goto-style programming. At first, it was laughable, but the more I thought about it, the more appealing it started to become. And here's why:

Most of the unstructured languages didn't have alphanumeric identifiers for labels; and much of the illegibility and tediousness can be attributed to jumping to line numbers. Adding alphanumeric labels can actually make the code easier to read and write. Some modern languages have even taken to allowing loop structures to be labeled.

Most of them also didn't have subroutines, which meant that you had to actively think hard about the organization of your code or you'd quickly end up with spaghetti code. Adding subroutines can eliminate most spaghetti code.

Not having structures doesn't mean there's no scope. It just means that everything declared inside of a subroutine is local to the subroutine; just like the function scoping in languages like Python and JavaScript.

All structural loops can be rewritten as anonymous functions, which is becoming increasingly common in newer functional languages.

Goto makes error handling much easier, because you can jump to a section that does cleanup without having to tinker with magic states.

Despite the title (intended to parody "Goto Considered Harmful"), I'm not asserting that structured programming is actually harmful or bad in any way. It's just a different style of programming which is much more prominent these days. I think that there's some value in taking another look at unstructured programming given that there are a lot of new concepts that just didn't exist back then.
]]>Other Programming LanguagesWajideushttp://forums.devshed.com/programming-languages-139/structured-programming-considered-harmful-979086.html