Ofatfoed:

I tried it, both urls, but it doesn't load the wamp server index page. pls, what am i to do next?

I need to know the error it's bringing or is it jst loading continuously without completion?
Your antivirus could be the problem, or port.
U can change ur port to 8080 in httdp.conf file by left clicking on the wamp icon at d taskbar wen started, then ho to apache and click on httpd.conf and after changing the port, restart your wamp server and then load localhost:8080 in ur browser.

labogini13:
want to create my blog

contact me directly @ 08132961297 or contact us at www.windrey.com. We are ready to help you.

swtdrms:
This is good, am actually excited seeing someone creating a thread for application development. @OP, it'll be better if u can be more professional in ur programming threads or articles by taking screen shots from a code editor, it presents u as a professional as well help the intended readers to make sense of it.
Also always stick to what title or topics you give ur article/thread. As your title do not correlate with the body of the write up and lastly, screen shots of the final results will also put you in the professional light.

As always, you have tried, keep it up and improve on it....

As for me, do i really have time dirtying my hands with mysql functions? Frameworks can really do lots of this elementary stuffs in a cinch, and if i'll have to, i'll rather go the OOP way

Thanks a lot for the advice. It's good for one to know the basics before making use of frameworks, and that's one of the purpose of this thread.

Ricswagger:

BOSS abeg i wan learn mysql step by step,i am working with macromedia dreamweaver,i already know html,css, still learning js , php
abeg bro

contact me tru whatsapp @ 08132961297 or contact us at www.windrey.com

9jawebdev:
The mysqli procedural is okay but recommended is the object oriented.

Instantiate a mysqli database connection using

$con = new mysqli(host,username,password,db)

Then execute an sql query by calling the query method

Like

$con->query($sql) ;

Etc.

I get you, but i needed to use that method because of newbies whom are in need of the post more. For example, most newbie programmer will not know what -> means in oop

olukenzo:
I was disappointed when I came here to see php. Overlooking that, there's also a huge difference between your topic and what you eventually wrote on.

And why do I get the feeling that you webdev cats seem to think SQL is just about Web? I recently moved transaction data management on my embedded device from flat file to SQL-based. I use sqlite.so. Imagine if I were to start a topic on sqlite C functions telling you it's "SQL"?

Bro the post wasn't about SQL, it was about MySQL, you should be able to differentiate that. And i need to related the mysql with a programming language to make complete sense.
Thanks

Ofatfoed:
bigdrey
I have a wamp server on my pc, i already installed but i don't know how to connect to the local host stuff. how do i go about that?

check if it's working by starting the wamp server as an administrator and then open any of your preferred browsers and type in http://localhost in the address bar or type in http://127.0.0.1 and see if it loads the wamp server index page. Update me on that.

dhtml18:
This board no dey make frontpage again, it has been banned.

Ehya too bad. Thanks for letting me know. Seems not everyone should have programming knowledge.

amunkita:
13 fishes

U re surprised bah
If 3 died means their spirit has left them nd since their is no Heaven or Hell for animals, they would remain there..

So add this:
7 live fishes+3 dead+3 fish spirit= 13Fishes

Used Uwa Mmebi almighty formular....

This post rili got me laughing out loud. I couldn't say much than realising that truly there are different creatures on this planet earth.
Thanks for making me laugh tho. The answer should be 10, the op said how many fishes left, not how many fishes and spirit of fishes left. And during census do u count the dead to be part of a population?

If you want to have a very powerful and interactive website then consider the use of web database either MYSQL or ORACLE just to mention a few.

In this article we will see and explain most used mysql function which you may need and must know as a PHP Beginner and Programmer.

Using PHP you can interact with MySQL database either using Mysql extension, PDO extension and MySQLI extension, for security reasons MySQL extension is considered as depreciated and it should not be used. In this article we will focus on MySQLI where ‘I’ means Improved.
BUT WHAT IS MYSQL?

This is an open source relation database management system (RDBMS) based on structured query language (SQL)
WHY NEED MYSQLI

This structured query language (SQL) provide an easy way to add, remove, alter and join information in database using standard SQL commands INSERT, DELETE, JOIN AND UPDATE. Let’s take a look on each function in detail.

Before you can use MySQLI extension you may need to connect to database once, to connect to database you need to know few things about your database such as password, host, user and database name.

HOST: This is where the database is located; it can be either localhost meaning your web server machine is hosting it's self the database or the database can be in another server.
To connect to database which is on another server you use IP Address of the server otherwise you may use localhost (Self hosted database).

CONNECTING TO DATABASE

define(“HOST”,”localhost”); // our database host
define(“USER”,”root”); // by default if mysql user name has not been changed the default is root
define(“PASSWORD”,””); // database password
define(“DB”,”test”); // our database to connect to

$con = mysqli_connect(HOST,USER,PASSWORD,DB);
if($con) die(“unable to connect to database”);

Don’t forget to see how to create database and database table
ADDING DATA TO DATABASE

$query = “INSERT TO users (username,email,password) VALUES (‘user1’,’user0@gmail.com’,’password1’)"; // do not add comma (,) at the end
$sql_execute = mysqli_query($query,$con);
# check if MySQL executed successfully or not
If(!$sql_execute){
die("unable to insert data into database";
}else{
echo ("successfully added new record to database";
}
UPDATING DATA IN DATABASE

$query = “UPDATE users SET email = ’user1@gmail.com’ WHERE email = ’user0@gmail.com’ LIMIT 1”;
// Its always a good practice to add LIMIT when using update command, if more than one record match all will be updated

$sql_execute = mysqli_query($query,$con);

// let’s check if an update was successful
If(mysqli_affected_rows($con) > 0){
echo = “Record updated”;
}else{
die(“No record was updated”);
}
// if making alteration to a record with same info you may get an error
DELETING DATA IN DATABASE

- When performing this command you need to be careful as it can delete all records of the database and there is no undo

$query = “DELETE FROM users WHERE email = ’user1@gmail.com’ LIMIT 1”;
$ sql_execute = mysqli_query($query,$con);

// let’s check if Delete was successful
If(!$ sql_execute){
die (“Unable to delete file”);
}else{
echo(“succefully deleted a file”);
}

Hint: for security reasons you are required to close MySQL connection when a query finishes but lucky MySQL usually do this for you when connection is not closed

Don’t forget to check how to create simple but secure login script
Don’t forget to check the power of OOP’s in PHP

Source: http://blog.windrey.com/most_used_mysql_functions/

Cc: lalasticlala

Every browser have their specific keyboard shortcuts just as there there are windows and other application shortcuts, these shortcut makes working with them easier and faster, and they make you use computers like experts.

The good thing about these shortcuts is that many of them perform the same functions and actions on various web browsers such as Mozilla Firefox, Google Chrome, Internet Explorer, Opera e.t.c. And it is the many of them that are common to all browsers i will be listing below categorically :

Mouse Actions for Tabs

Middle Click a Tab – Close the tab.

Ctrl+Left Click, Middle Click – Open a link in a background tab.

Shift+Left Click – Open a link in a new browser window.

Ctrl+Shift+Left Click – Open a link in a foreground tab.

Navigation

Alt+Left Arrow, Backspace – Back.

Alt+Right Arrow, Shift+Backspace – Forward.

F5 – Reload.

Ctrl+F5 – Reload and skip the cache, re-downloading the entire website.

Escape – Stop.

Alt+Home – Open homepage.

Tabs

Ctrl+1-8 – Switch to the specified tab, counting from the left.

Ctrl+9 – Switch to the last tab.

Ctrl+T – Open a new tab.

Ctrl+N – Open a new browser window.

Alt+F4 – Close the current window. (Works in all applications.)

Ctrl+Tab – Switch to the next tab – in other words, the tab on the right. (Ctrl+Page Up also works, but not in Internet Explorer.)

Ctrl+Shift+Tab – Switch to the previous tab – in other words, the tab on the left. (Ctrl+Page Down also works, but not in Internet Explorer.)

Ctrl+W, Ctrl+F4 – Close the current tab.

Ctrl+Shift+T – Reopen the last closed tab.

Zooming

Ctrl and +, Ctrl+Mousewheel Up – Zoom in.

Ctrl and -, Ctrl+Mousewheel Down — Zoom out.

Ctrl+0 – Default zoom level.

F11 – Full-screen mode.

Scrolling

Space, Page Down – Scroll down a frame.

Shift+Space, Page Up – Scroll up a frame.

Home – Top of page.

End – Bottom of page.

Middle Click – Scroll with the mouse. (Windows only)

Search

Ctrl+K, Ctrl+E – Focus the browser’s built-in search box or focus the address bar if the browser doesn’t have a dedicated search box. (Ctrl+K doesn’t work in IE, Ctrl+E does.)

Alt+Enter – Perform a search from the search box in a new tab.

Ctrl+F, F3 – Open the in-page search box to search on the current page.

Ctrl+G, F3 – Find the next match of the searched text on the page.

Ctrl+Shift+G, Shift+F3 – Find the previous match of the searched text on the page.

Address Bar

Ctrl+L, Alt+D, F6 – Focus the address bar so you can begin typing.

Ctrl+Enter – Prefix www. and append .com to the text in the address bar, and then load the website. For example, type windrey into the address bar and press Ctrl+Enter to open www.windrey.com.

Alt+Enter – Open the location in the address bar in a new tab.

History & Bookmarks

Ctrl+H – Open the browsing history.

Ctrl+J – Open the download history.

Ctrl+D – Bookmark the current website.

Ctrl+Shift+Del – Open the Clear Browsing History window.

Other Functions

Ctrl+P – Print the current page.

Ctrl+S – Save the current page to your computer.

Ctrl+O – Open a file from your computer.

Ctrl+U – Open the current page’s source code. (Not in IE.)

F12 – Open Developer Tools. (Requires Firebug extension for Firefox.)


Source: http://blog.windrey.com/major-web-browsers-keyboard-shortcuts/

There are mainly two tutorials under the topic on how to take screenshot on your computer screens (Windows Users Only):

The first tutorial is How to take screenshot of the full computer screen (Windows)

Press prt sc keyboard, usually found around the upper right hand corner of your keyboard (For most keyboards)

OR Press Windows button + prt sc (For some keyboards)

OR Press fn + prt sc (For some keyboards)

OR Press ctrl + prt sc (For some keyboards)

And after that, open paint application and press ctr + V to paste and then press ctrl + S to save.


The second tutorial is How to take screenshot of part of the computer screen (Windows)

1. Got to Start or click on the windows key and type “Snipping tool”, the open the application by double clicking or pressing the enter

2. Click on the New or click on the arrow beside the new which is used for selection the option you want for the screenshot

3. Clock and Drag your cursor to cover the part or area you want to take the screenshot

4. Then Click on the save button.

Source: http://blog.windrey.com/how-to-take-screenshots-on-your-computer-screen/

cc: lalasticlala

Palmwinetapper:
because he does

I see

Without undergoing this tutorial, Microsoft windows in it's new Windows Operating System 8 and 8.1 didn't make the hibernate option available in the default shutdown options. Meanwhile, hibernate mode is a very important mode for all computer users especially when you have some uncompleted things you are doing which you would like to continue later.

Follow this simple steps below to add Hibernate mode to your windows 8 and 8.1:
Step 1: In your system tray, click the battery icon and select More power options from the panel that pops up.

Step 2: In the power options window, select either Choose what closing the lid does or Choose what the power button does from the left hand side of the panel.

Step 3: In the next window, click the blue text that says Change settings that are currently unavailable

Step 4: At the bottom of the windows, a new set of options will become available. Check the box next to Hibernate and click Save changes.

And that's all. The Hibernation will now show up in the shutdown options.

Source: http://blog.windrey.com/enable-hibernate-on-windows-88-1/

Palmwinetapper:
on what

He looks like his mum

Palmwinetapper:
Munachi abii the 28 year old mbgn rapper brought her 23 year old boyfriend Tomi Thomas out for an event. He looks like his mum!

No one is talking about the bolded, am still trying to comprehend tho.
Maybe the OP shld shed more light

tuwayz:
Nice one, not an end time list, kudos

Thanks, there are many more though.

Lawconfessor:
I know not some of those shortcuts
Thanks for sharing

There is love in sharing

JeffreyJamez:
Nice one OP

ALT+CTRL+DEL for Task Manager

That's right, thanks for the contribution

As we know all mouse can be used for clicking, selecting, and performing some operations on the computer, we should also be aware we can still perform all sorts of operations without making use of the mouse.
There can be cases where the mouse could be faulty or unavailable, and we need to still perform some operations in the computer, the good news is that keyboard shortcuts can perform virtually everything you want to do with the mouse.
Another good thing about using keyboard shortcuts is that it is much faster performing operation compared to using the mouse, and using keyboard shortcuts makes you more like a computer geek.

There are several keyboard shortcuts but we are focusing on the 15 most important ones. Find below the keyboard shortcuts and uses (Windows Users Only):

NB: Make sure you try them as you are reading.

[b]Ctrl + F =======> Find (To find a text/file in the computer, browser, e.t.c)
Ctrl + S =======> Save (To save document, web page, e.t.c)
Ctrl + D =======> Delete (To delete any file, document, text e.t.c)
Ctrl + P =======> Print (To print a document or anything on the pc)
Ctrl + A =======> Select All (To highlight all contents, files, text, e.t.c)
Ctrl + N =======> New Window (To open a new window, file, e.t.c)
Alt + F4 (Or Ctrl + W Or Ctrl + Q) =======> Quit (To close a windows program, e.t.c and can also be used in shutting down)
Alt + tab =======> Switch Windows (To switch between windows)
Alt + tab + tab + … + tab =======> Continuous Switching (To continue changing windows)
Windows key + M =======> Minimize (To minimize current windows program)
Shift + Windows key + M =======> Maximize (To maximize the currently minimized windows)
Windows key + E =======> Open Windows explorer (To open My computer windows)
Windows key + R =======> Open Windows program (To open a windows program e.g cmd, notepad, e.t.c)
Windows key + D =======> Display desktop (To open windows desktop)
Windows key + L =======> Lock Windows (To lock windows)[/b]

Note: Ctrl means Control, Alt means Alternate and Windows Key is the button on your keyboard the has the windows logo

Source: http://blog.windrey.com/15-keyboard-shortcuts-every-computer-geek-should-know/

cc skydancer

We can help you in the online aspect by creating a professional website for you at a very cheaper price since we are aware you are just starting up. Visit us www.windrey.com or contact me directly 08132961297.
We wish you the best.

tchidi:

Most of those courses cost a head, a leg and some other body parts..

CCNA, Oracle, SAP are freaking costly!!

And then one gets a peanut as a salary even after spending thrice the salaray on just one course alone, and when many of those courses are in stages by stages with lotta money which have an expiry date.

I got the message thrice yesterday 15/08/2015, and it says thus

MGR Consult invites you forbTest/Briefing by 9am on Mon 17/8/15 @ 161 Ikorodu Rd,Onipanu B/stop,Lagos.Opposite ECOBANK.

The sender are
HR-2177AX
HR-2177PH
HR-2177-J
All with same messages at different time

Pls help confirm it's genuineness.

Please, I noticed everyone is only talking abt marketing, operational and the likes. I would like u to hear about the I.T sectors in the bank as well and how they are employed and i want to knw if some of the graduate recruits are put into the I. T department.

Dharniel:


sent...

Pls kindly send to me drey808070@yahoo.com