We can concatenate multiple MySQL rows into one field using GROUP_CONCAT function in mySQL query. There might be situations when you select multiple values from multiple tables and after all the joins you have got a lot of rows than you would like. We can use`GROUP_CONCAT` to obtain the same result with less numbers of rows.
WordPress fix to blank screen or blank page or dashboard
Getting a blank screen or blank page or dashboard under your WordPress powered website? Relax! You are not the single person to face the issue and I have sum up all the possible solutions which will sure help you out to solve the issue.
update div top position based on its changing height
Few days ago, I have a requirement to update Div top position based on its changing height. I tried to resolve it by using different way
multiple instances of flexslider on a single page
I was developing a website. In that, I wanted to use multiple instances of flexslider on a single page. There was not the problem if ID of the container tags is different. But on my website, everything was dynamic, even how many flexslider instances were be called, that was also unknown
jQuery UI sliders on touch devices
I was using jQuery UI range slider and it was working on desktop very well but my website was responsive and working very well on touche devices. But jQuery UI sliders on touch devices appear to be incompatible when viewed on Ipad and Iphone. So I googled on this issue and found a solution which am explaining here
Deactivate plugins when not able to access dashboard
Sometimes any change made in WordPress site mess it’s working and we need to deactivate plugins or set default theme with alternate methods because we feel ourselves not able to access dashboard to undo changes.
Most of the times we see blank pages whenever we try to open wp admin dashboard that can happen due to any poor plugin or broken theme.
Loop in wordpress
In every programming or script language, loops structure has its own importance. Generally Wordpress follows PHP. But wordpress also has some specific ways to achieve loops functionality.
Create depth border effect or deep border using lists in CSS
Someone asked me how do I create depth border effect or deep border using lists in CSS. Actually he wanted to create a strand effect (divider) between each list item as you can see in the screenshot below. You can see one more example using light background in rest of the article.
Get the last inserted ID of a MySQL table in PHP
Get the last inserted ID of a MySQL table is a simple query to obtain the primary key of the record you just inserted to the table. Here I have explained the query using PDO as well as Mysqli.
Also, I have abbreviated few points while using PDO or if you are trying to get the last inserted ID of a MySQL table in PHP using other methods.
PHP return data from loop in function
The idea behind writing a post to return data from loop in function in PHP just came into my mind because a fresher was trying to set up a function to return data from loop and hoping it would then run a return each time within the loop and the function would echo each out one by one.
[ Page 24 of 32 ]