Main menu:

Site search




Oracle und SQL


finger – php Ajax Framework

If you are trying to find a usefull domainname for yourself on some Registrars webpage you always (mostly) have to go through the same type, submit, wait, check result, start again routine.

This is so 90s!

So I thought of doing it with a little php and Ajax using the finger tool (or something similar) provided by most registries. Taking this opportunity I also tried it in three different ways to check which Ajax Framework to use.

See how it works

The oldfashioned way – by hand

See the code here, a little clumsy

The Sajax Framework

See the code here, the Framework is quite new, and honestly I didn’t get the code to work on this server, it worked nicely with a XAMPP installation on windows, but neither on OpenSuse 10 nor on AIX 5.3. The callbacks are also an nuisance i.e. that you have to code them yourself.

The xajax Framework

See the code here. This is the shortest and most elegant code by far. Coming from the examples it took me about three minutes to adapt the example. For me the clear winner of this short comparison epp client

newest version of the php client for epp registry system

for more information please go to  the php-epp-client main page epp client in php

Ich bin sicher kein Experte für php, aber ich habe einmal auf die Schnelle einen clienten für das epp System gestrickt. Der Client ist eher eine “Machbarkeitsstudie” die ohne externe php module (und “ohne” xml) auskommt, daß heißt einfach entpacken, client.php editieren und loslegen. Sinnvollerweise sollten die Daten natürlich aus einer Datenbank oder etwas Vergleichbarem herkommen.

Es sind noch nicht die Templates für alle Kommandos fertig, aber anhand der Beispiele sollte es klar sein was zu tun ist. Zur Zeit auch einmal ohne Doku, ich hoffe ich komme da einmal dazu – bei Fragen bitte einfach mailen.

In Zukunft werde ich die Doku/Änderungen auf der Hauptseite der Client Packages präsentieren, die jeweils neueste Version der Software wird es hier geben.

Die With Clause

Möchte man herausfinden welcher Vermieter wieviel Autos mit welchem Extra anbietet, also zum Beispiel wieviele Autos hat “Karls Luxuskutschen” mit Klimaanlage und Automatik, kommt einem die “with clause” zur Hilfe

with verm_extras as ( SELECT vrm_name, ext_name FROM tst_vermieter, tst_fahrzeuge, tst_fhz_ext_int, tst_extras WHERE ( (tst_vermieter.vrm_id = tst_fahrzeuge.fhz_vrm_id) AND (tst_fahrzeuge.fhz_id = tst_fhz_ext_int.fei_fhz_id(+)) AND (tst_extras.ext_id(+) = tst_fhz_ext_int.fei_ext_id) ) ) select distinct e.vrm_name, e.ext_name, nvl(extras_count, 0) c from verm_extras e, (select vrm_name, ext_name, count(ext_name) as extras_count from verm_extras group by vrm_name, ext_name) ec where ec.vrm_name = e.vrm_name and ec.ext_name = e.ext_name order by e.vrm_name

Dealing with student loans

The consequences of defaulting on student loans are steep. Students who default on loans owed to their school receive a discharge of their federal student loans, which could mean losing access to any federal education aid, this means they wouldn’t be eligible for any graduate student loans in the future.

In California, that means losing eligibility for financial aid that could add up to tens of thousands of dollars in loan debt over the course of a degree or certificate. This is exactly why it is always important to seek financial assistance in these cases, by visiting websites like

According to California’s official data, 15.5 percent of borrowers who owed $20,000 or less on their loans at the end of 2015 did not make any payments during the year, according to data from the Department of Finance. In those states, students who defaulted on their federal student loans can lose federal loan subsidies and scholarships they had been eligible to receive for up to five years.

Some of the worst states for student loan defaulting are California, Hawaii, New Jersey, Washington and Illinois, all of which placed in the top 10 for students who defaulted on loans owed to their school.

How do states do it? Some, like California and New Jersey, have specific laws that require borrowers to stay current on their loans. But others are more subtle. “I don’t think that anybody’s really thinking about this,” said Michael Feroli, a law professor at the University of Pennsylvania. “It’s just part of the landscape.” In some cases, lawmakers have simply taken away the ability to pay up to have the student loan forgiven. There are several different types of loans, but the largest category, federal student loans, are issued to young people who plan to earn at least $55,000 a year after graduation. Under those loans, the interest rate is currently capped at 3.4%. After that point, the interest rate is based on the amount of time students have borrowed, as long as the debt remains outstanding for three years. In some states, such as New York and California, the interest rate is higher.

California: Interest Rates on Borrowed Debt 10 Years After Graduation Amount Interest Rate 25% $10,500 $35,625 30% $17,500 $55,000 35% $22,500 $75,000 40% $25,000 $100,000 45% $29,000 $125,000 50% $34,000 $150,000

Students who borrow money to start their career can get a great deal of student loan forgiveness. When students graduate from college, they’ll be able to get the money back from the Federal Pell Grant, the Pell Scholarship, and the Federal Work Study. They can also get money from the Federal Supplemental Educational Opportunity Grant. This means students will be able to finish their education debt-free and they can continue to work. Many students can get more debt forgiveness. For those who took out Federal Direct Loans, the student loan forgiveness amounts will vary based on the amount of the student’s loan that was in deferment. Interest Rate on Direct Loans 10 Years After Graduation Amount Interest Rate 10% $20,000