php-mysql

Dump and restore from .sql Dump mysqldump db_name table_name > table_name.sql Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql

linux php-mysql

No route to host (113)

May 23, 2014 eduguru 1 Comment [Solved] unable to connect to host: No route to host (113), ERROR: [Errno 113] No route to host - Ask OpenStack: Q&A .., In host machine iptables is running and is blocking the port 5901. Kill all the vncserver desktop in the host machine and run the following command in the terminal. Type the password for the user when, Linux Error :113 No route to host, No route to host (113), No Route to Host error and solution, Stop firewal or iptables service #service iptables stop, unable to connect to host: Connection refused (111), unable to connect to host: No route to host (113)

In host machine iptables is running and is blocking the port 5901. Kill all the vncserver desktop in the host machine

Asterisk info php-mysql

saving data into custom cdr field – add new filed in cdr

January 3, 2014 eduguru 11 Comments 1, but i don't know where is the file that saves details of call into database. Help me, but where? exten => s, database "asteriskcdrdb". In this field I want to store recording name. I know i should do it by adding this line in one of .conf files, I created custom field "rec_name" id table "cdr", I'll by grateful., please, set(CDR(rec_name)=${CALLFILENAME}) I can do it by sql statement, too

I created custom field “rec_name” id table “cdr”, database “asteriskcdrdb”. In this field I want to store recording name. I

info php-mysql

Create your own search engine with PHP and MySQL

October 21, 2013October 21, 2013 eduguru 4 Comments `pagecontent` TEXT NOT NULL, `pageurl` VARCHAR( 255 ) NOT NULL, `username`, '$_POST[url]', '$pagedata')"); Give a small added message, "", "PASSWORD"); mysql_select_db("DATABASE"); Now perform the MySQL query (as a query) 1 $sql = mysql_query("SELECT * FROM searchengine WHERE pagecontent LIKE '%$_GET[term]%' LIMIT 0, "PASSWORD"); mysql_select_db("DATABASE"); The URL of the page will now get its source code read and made into a variable. 1 $pagedata = htmlspecialchars(file_get_contents($_POST['url'])); This little , $_GET[results]"); The query mentioned above will look in the page data i.e. the Search results after entering in the keyword and display it as many times as you define it. We will create an array now , $pagedata); Let us now insert the information into the database. 1 mysql_query("INSERT INTO searchengine VALUES ('', Blogs, Create your own search engine with PHP and MySQL, Database Matter The first step is to open up phpMyAdmin or a database software and incorporate the below query into the SQL section. 1 2 3 4 5 6 CREATE TABLE `searchengine` ( `id` INT NOT NULL AUTO_IN, edit and delete the results as well. The most important part is the security of the search engine and preventing other people to add information. This can be done by doing a password protects on ‘addu, Entertainment, just so you know it's been added. 1 2 echo "URL Added.Continue..."; ?> Search Engine is ready!!! So we are ready with our nice and simple search engine. One can now go to 'addurl.php' and enter the, let us make the form that will permit the visitors or the end users to perform a search. A file 'index.php' needs to be created. The form will be using GET instead of POST thereby making the informati, PRIMARY KEY ( `id` ) ) ENGINE = MYISAM The above query will assist the details or information to be stored in the database. Creating the Form Now when the database information is now added, technology etc. can be done. With the completion of this tutorial, the connection with the database, the process to read information from a database and obviously how we can add some new information into the database., there will be good amount of results for the reason that it'll be reading stuff like ''. We can make things better by following the below mentioned points. We can alter the ‘addurl.php’ page that will, we have leant on how to build a HTML form

Database Matter The first step is to open up phpMyAdmin or a database software and incorporate the below query into

php-mysql

Insert Data From a Form Into a Database

October 18, 2013January 10, 2014 eduguru 2 Comments '$_POST[age]')"; if (!mysqli_query($con, '$_POST[lastname]', "abc123", "my_db"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql="INSERT INTO Persons (FirstName, "peter", $sql)) { die('Error: ' . mysqli_error($con)); } echo "1 record added"; mysqli_close($con); ?>, Age) VALUES ('$_POST[firstname]', and a new record will be added to the "Persons" table. Here is the "insert.php" page: <?php $con=mysqli_connect("example.com", and retrieves the values from the form with the PHP $_POST variables. Then, in the example above, Insert Data From a Form Into a Database, LastName, Now we will create an HTML form that can be used to add new records to the "Persons" table. Here is the HTML form: Firstname: Lastname: Age: When a user clicks the submit button in the HTML form, the form data is sent to "insert.php". The "insert.php" file connects to a database, the mysqli_query() function executes the INSERT INTO statement

Now we will create an HTML form that can be used to add new records to the “Persons” table. Here