TRENDING NEWS

POPULAR NEWS

How To Add Mysql And Php On My Website

How can I add a point system to my website?

First you need to see if you website hoster allows a server side script (like PHP) and a relational Database like (MySql). I have not seen a free website host offers these so you would first have to upgrade to a paid domain/host. Then you would have to learn the server side scripting like php/asp and begin to build user creation pages,login pages, then your content to give the user in session the points appropriate.

Login for my website?

You use vbulletin or phpbb which is a free version to get the whole forum and login thing. Though I would not suggest making people have to pay to join even if it is only 20c as some people may just not want to pay and others may not have paypal etc.

Where can one host PHP and Mysql powered websites?

To get your website online, you need two main things :1) Domain Name - This is basically the name(url) of your website. You can choose from various available ones ending with .com , .in, .org depending your need. An example domain is Google.2) Hosting space - This is where all your code is stored and also from where you can setup your MySql databases and other functionalities.GoDaddy   provides a simple and easy to use interface to go from nothing to a live website withing minutes. Even I was amazed at their speed of setting up the server space and linking to domain names. Visit Godaddy and buy a hosting service from here Web Hosting from GoDaddy . I think Economy plan should be sufficient for your needs. You can upgrade at any point of time later. If you buy this service for a year or more, you'll get  a free domain name too. Once you buy this and launch it, you'll be taken to a cPanel - the main control interface of your whole website. Two things are needed to be done now :1) File Manager : Go to file manager, ensure that you are in public_html folder by chcecking the side tree. Upload all your site files to this folder. Basically, for Example, if your domain name is testxyz.com ,  then testxyz.com/ points to this public_html folder in the File Manager. So you need to upload your files here.2) MySql database : I hope you are familiar with PhpMyAdmin. In the main control panel, you can go to phpmyadmin interface and manage your databases tables from in there. But one important thing is you can not create databases from inside phpMyAdmin interface as you can in localhost. For creating databases, you need to find Create Database option in cPanel home and create a database first there. Once you have created a database here, you need to create a user also for that database. Generally in your localhost this(user) is "root", here you need to create a user with a password and assign him to database and you need to change your parameters while connecting to database in php-mysql to match these.

How do I upload a PHP website to a godaddy hosting server?

I made a PHP website with XAMPP, MySQL, and Dreamweaver and am trying to upload it to godaddy through the FTP client in Internet Explorer. I use this FTP client for my HTML websites. I have never upload a PHP website before and its not working. I get this error when I visit the index.php of the website:

Warning: mysql_pconnect(): Unknown MySQL server host '127.0.0.1/mdcphc' (1) in /home/content/m/d/c/mdcphotoclub/html/Co... on line 9

Fatal error: Unknown MySQL server host '127.0.0.1/mdcphc' (1) in /home/content/m/d/c/mdcphotoclub/html/Co... on line 9


Any ideas? Do I have to upgrade my GoDaddy hosting service? Or do I have to change an IP address? If yes, what IP address do I use?

How to add email recipient 's data from mysql table in php email?

Run this script:


require_once( "./include/fgcontactform.php" );
require_once( "./include/captcha-creator.php" ); // Just guessing here, as yahoo cut it.

$formproc = new FGContactForm();
$captcha = new FGCaptchaCreator('scaptcha');

$formproc->EnableCaptcha($captcha);

if(!isset($pub_id)){
      die('

Variable $pub_id is not set. Non-existent. Therefor, you cannot search with it.

');
}
$r = mysql_query("SELECT * FROM publishers WHERE pubid='{$pub_id}' LIMIT 1") or die('Query Error: ' . mysql_error());
if( mysql_num_rows($r) === 0){
      die('

A publisher with the pubid of [' . $pub_id . '] was not found. Cannot add, what I do not have.

');
}
$public_email = mysql_fetch_object( $r )->public_email;
echo '

Public Email: [' . $public_email . ']


';

if( strlen($public_email) > 0){
      $formproc->AddRecipient( $public_email );
}else{
      die('

No Email address to add.

');
}
?>

Then either post another question with the resulting messages/errors. Or email me them directly: http://gitlez.comxa.com/contact.php or through my Yahoo profile page.

Cheers,
Gitlez

What is the relationship between mySQL and PHP?

MySQL is the Database System where you can create tables and store data on the server.

PHP is a server side scripting language used to develop websites and mainly used for manipulating data. It is widely used to store and retrive data from MySQL database which resides on the server.

For more details and up to date information on PHP and MySQL connectivity visit the following link.

http://www.w3schools.com/php/default.asp

Hope this helps.

Hope this helps.

How can I add PayPal payments to a website and connect the transaction success with PHP and MySQL on the website?

Paypal has an open rest api that will enable you to do this. In its simplest version is the payment part involving a get request to the paypal gateway giving as parameters the seller account, payment currency, payment amount, cancel url, payment notification url and success url. If a payment goes through, paypal will respond to you through the notification url with post parameters and many more details

What is the PHP and MySQL code to create a database for my website?

It depends upon if you have hosted your website or not. If you have host your website then you need will do it online by going to my database and creating one. The name and password for that database will be given to you., You will need just to connect by using PHP scripts.If you are offline and having your own server and MySQL database installed in your computer, then use the following code to connect and create database:connect_error) {die("Connection failed: ". $conn->connect_error);}// Create database$sql = "CREATE DATABASE myDB";if ($conn->query($sql) === TRUE) {echo "Database created successfully";}else {echo "Error creating database: " . $conn->error;}$conn->close();?>

I need to add the notification feature in my website like that of Facebook using PHP and MySQL. How should I start?

You may create 2 tables.. Lets call them notifications & notifications_summary. The notifications table can store all the notifications with their appropriate contents.. The notifications_summary table can store the count of unread notifications per user... This count can be used to show the new notification counts... And when the user clicks on the count, you can query notifications table & show the "actual" content.If number of users on your site are high; you can even think about sharding these tables based of user-id.

How can I make a login system for a weebly website?

This is a simple website login system that has been very reliable and secure for me. I use it myself on my websites, when a simple login system is needed. If you know a little MySQL and PHP, it is very easy to use. If you need a PHP refresher course, I strongly recommend Simple PHP - you can learn the basics of PHP programming in just a few days! Here's how to create a simple website login system using PHP and MySQL.

First, you will need to have MySQL installed on your computer. I have XAMMP installed and I use PHPmyADMIN for accessing my databases. They are free for download; just search for them online. You also need to create a database in your MySQL. And as you proceed, remember that linux server file names are always case sensitive. LOGIN.PHP is not equal to login.php like it would be on WINDOWS servers. Continued...

TRENDING NEWS