Posts tagged MySQL
7 easy steps to use Webmatrix and WordPress local development
Jan 6th
Almost all good developers that I know have some kind of repository of their code. Mine is my blog, this blog. Stay with me and you’ll find out how to easily be able to create your local version of WordPress, customize and test your plugins.
For´this you’ll need to follow the next steps:
- Go to Webmatrix official website and download the Web Platform Installer which will install for you not only Webmatrix itself, but also a lot of useful tools like an integrated webserver, Internet Information Services Express, PHP interpretor and its connectors just to name a few. But you can also use it to add new features like ASP .Net MVC3! More >
How to generate image_src for Facebook links in WordPress theme
Feb 18th
Sharing your article for free advertisement on Facebook is a fact. While using different Social Networks sharing tools I had a problem when sharing my articles on Facebook: sometimes the image that I intended to use to represent the article wouldn’t show in the list of the images who can be chosen. Why is that?
It bothered me some while I got the some free time to actually look into this, between exams, work and master research. After some wandering on the internet, I found here the correct directions. What I learnt: Always search for the API!
In order to make sure that the preview is always correctly populated, you should add the tags shown below to the <head> element in your HTML code. If you don’t tag your page, Facebook Share will grab the title of your page as specified in the <title> tag, and will create a summary description from the first text that appears in the body of your page. A list of thumbnails will all be selected from available images on your page.
You can control the exact title, description, and thumbnail that Facebook Share uses by adding the following meta tags to the <head> element in your page:
<meta name="title" content="title" /> <meta name="description" content="description " /> <link rel="image_src" href="thumbnail_image" / >
CursValutar
Jan 7th
Uses: Borland Delphi 7 VCL, HTTP, HTML Parsing, JavaScript, PHP server side script
The program parses web pages from Romanian National Bank site (www.bnr.ro), offering the latest currency ratings, among with a currency calculator, a very useful converter. The program was designed by me in Softwise Development company as a low resource program, hidden in the tray bar of Windows, while periodically checking BNR site and warning the refreshing of the currencies rate. Another feature is that it shows the trend of the user selected currency over the time, allowing you know how it fluctuates – improving the user decision.
The application is designed to be used as a simple, easy to use tool, providing without any previously knowledge of software usage the full functionality and power to the end user.It also has enough options to allow user to customize the time of refreshing data from the BNR site, the visible currencies (although all are refreshed, user may want to see just a number of them), the program start), and the calculator part – a tool visible in the main window of program (in right-bottom corner), but also in a separate window, which can be set to become visible as user clicks on the tray icon.
Softwise Development
Jan 4th
Positions: Junior to Senior Developer, Project Manager
Softwise Development is the company that shaped me as developer. I worked there for 2 years, between January 2002 and January 2004. I enjoyed there not only a good atmosphere, but also discovered a friend in the person of Mr. Dan Trutia, CEO of the company. I was his first employee and I believe that we created a good team. Together we raised the company to a 10 people business, having international contractors while working in software outsourcing industry.
There I had quite a few projects, challenge being the word of the day. I learn a lot about developing Object Oriented applications in Delphi 5 and 6, Access databases, PHP and MySQL, Windows API programming and not to mention user accessibility techniques, helping users with eye problems.
In the last six months of his employment, I was trusted with the responsibility to manage several projects to completion in budget and timely manner, being advanced to project manager. I enjoyed this opportunity and tried my best to prove my professional potential and leadership ability. Being a manager on several projects, I was responsible for conducting many meetings with the customers, conducting requirement analysis and requirements engineering that lead to successful projects.
Responsibilities:
- Delivering IT projects to user specification, on time and on budget
- Testing functionalities and modules
- Documenting IT policies and procedures
- Scheduling the project tasks
- Maintaining the IT security in line with group specifications
- Database maintenance, data updates and records checking
Technologies that I used were:
- Borland Delphi 6 and 7 Enterprise, custom built controls.
- Microsoft Access and Microsoft SQL databases, ADO
- Windows ‘98 Api programming
- PHP and MySQL for server-side applications
How to add Zend Debugging capabilities to Apache
Nov 2nd
Most developer use a local website to test and develop their applications. One of the most used servers is Apache. Since for many developers setting this complex tool is not worth spending their time, some use smart installers who can do those settings for them. I personally use Vertrigo server, who brings me the advantage of 0 time for install, 0 time required for setting and making other tools work together, like MySQL, PHP, PHP MyAdmin, Zend Optimizer etc.
This tutorial is for Windows environment, but it can be easily adapted to Linux or MAC environments because all the settings are done in the configurations files.
The problem that I want to solve in this tutorial arises when one might want to debug its work. I mean, you wrote your application in PHP. There are some tools to allow you to debug it, but either are costly, like Zend Studio and Zend Server or are hard to setup, like XCode. At the end of the day, you’re paid to create applications, not to do dirty settings in 10 or so files in order to enable a simple debug feature.
How to add a Webslice
Sep 15th
It is very nice and user-friendly to have Webslices on your website. It improves the user experience by allowing visitors to be up to date with the latest content that you provide, assuming that it is fitted to this presentation style. Since my BNR exchange rates page was this kind, I pursued in adding a Webslice especially for it.
Adding a webslice to your website is simple. After you read the main specifications or my previous article, you’ll understand the concept behind: first you signal to the browser that you have a special part of your website by setting to a container element the class “hslice”:
<div id="BNRExchange" class="hslice">
<div style="display: none" class="entry-title">
<img id="image" alt="Radu Poenaru's weblog gives you BNR Exchange rates" src="http://www.radupoenaru.com/bnr/images/radupoenaru.jpg" width="128" height="128" />
<p>
Cursul oficial BNR
</p>
</div>
<p>
<a style="display: none" href="http://www.radupoenaru.com/bnr/bnr.php" rel="entry-content">
<a style="display: none" href="http://www.radupoenaru.com/bnr/bnr.php" rel="Bookmark" target="_blank">
<span style="display: none" class="ttl">5</span>
</p>
<div id="updateTrigger" class="entry-content" runat="server" />
........ your content that you want surrounded by the green webslice part ..............
</div>
WordPress – Database backup and restore
Sep 13th
From time to time, you’ll need to get a backup of your MySQL database and install it on a different machine – as I needed when reinstalling my Windows 7. I wanted to do something simple, as the last time. But now the database sql file is 11 Mb as opposed to merely 2 MB last time.
But I thought that this would be a breeze for the MySQL interface that I use and enjoy – HeidiSQL. It’s free, easy to use and user friendly. I personally don’t like too much the phpMyAdmin interface from the Vertrigo webserver installation that I use for local development.
WordPress – How to Delete Existing Post Revisions
Sep 9th
This is the second part of managing WordPress feature of post revisions, for the users who had disabled or turned off post revisions tracking or versions history feature. As you already know, this feature exists in WordPress (starting with WordPress 2.6). After disable it (of course, if you really need to do that), it also make sense to also delete and remove all existing stored post revisions. By doing so, you’ll remove changes made on pages stored in the database such that you’ll slim down the wp_posts table size´. This is especially recommended when there is already lots of revisions or changes inside.
WordPress – managing Post Revisions Tracking
Sep 7th
A very interesting feature added in WordPress blog publishing system since version 2.6 is the post revisions tracking, like in version control systems. It simply adds a Wiki-like style tracking of edits that had been made to the posts or pages. This allows bloggers and authors to view, control and moderate – knowing who and when made what changes to any post or page. It also includes the ability to compare for differences between each saved versions, or revert back to older version.
BNR exchange rate
Aug 12th
In this global crisis, nothing is more useful than a good chart to watch your money as investment. That’s why I created a special page which collects freely available exchange rates from BNR (National Romanian Bank) and presents them in a graphical form. This way, the viewers of my website will always be on the edge with exchange rates, as soon as BNR posts them (usually around 13:00 GMT+2).
The main challenges were:
- Building a php script to parse XML, inserting the exchange rates into database. The lack of experience and debugging tools made a huge difference in development time. But all is working now.
- Creating a php script that will daily update the exchange rates, so the users will have the fresh rates at their disposal as soon as possible.
- Design the page that hosts the chart and provide create the appropriate data structure which will feed the chart with data.
- learn to use a very interesting framework of representing data as charts – Google Visualisations
Next steps:
- Offer the posibility to choose among all 30 currencies for which the BNR provides exchange rates.
- implement AJAX for smooth behavior of refreshing the page while user chooses a different currency.
Enjoy!
