<![CDATA[VU Help - Php & Mysql]]> https://vuhelp.net/ Tue, 27 Oct 2026 23:45:43 +0000 MyBB <![CDATA[The required PHP extension MySQLi could not be found. Please ask your host 2014]]> https://vuhelp.net/Thread-The-required-PHP-extension-MySQLi-could-not-be-found-Please-ask-your-host-2014 Sat, 09 Aug 2014 04:15:51 -0400 Xpert]]> https://vuhelp.net/Thread-The-required-PHP-extension-MySQLi-could-not-be-found-Please-ask-your-host-2014 The following errors occurred while verifying that your server can run XenForo:

The required PHP extension MySQLi could not be found. Please ask your host to install this extension.

Please correct these errors and try again.

This is common error should be install the MYSQLI and only hosting providing company can provide this.
regards]]> The following errors occurred while verifying that your server can run XenForo:

The required PHP extension MySQLi could not be found. Please ask your host to install this extension.

Please correct these errors and try again.

This is common error should be install the MYSQLI and only hosting providing company can provide this.
regards]]> <![CDATA[php lectures in urdu of Virtual University of Pakistan 2012]]> https://vuhelp.net/Thread-php-lectures-in-urdu-of-Virtual-University-of-Pakistan-2012 Sun, 29 Jan 2012 08:54:56 -0500 Xpert]]> https://vuhelp.net/Thread-php-lectures-in-urdu-of-Virtual-University-of-Pakistan-2012 Now you can get the virtual university of Pakistan php urdu video lectures. Which may help you and you can learn the fundamental of the php up to the professonal usage. So check them from the following lectures which are video lectures.
[video=youtube;rr--QbtiFzI]http://www.youtube.com/watch?feature=player_detailpage&v=rr--QbtiFzI[/video]

Lecture 2

[video=youtube;08c3IQdwsbY]http://www.youtube.com/watch?v=08c3IQdwsbY&feature=related[/video]


Lecture 3

[video=youtube;Aj2to0Lfavg]http://www.youtube.com/watch?v=Aj2to0Lfavg&feature=related[/video]]]> Now you can get the virtual university of Pakistan php urdu video lectures. Which may help you and you can learn the fundamental of the php up to the professonal usage. So check them from the following lectures which are video lectures.
[video=youtube;rr--QbtiFzI]http://www.youtube.com/watch?feature=player_detailpage&v=rr--QbtiFzI[/video]

Lecture 2

[video=youtube;08c3IQdwsbY]http://www.youtube.com/watch?v=08c3IQdwsbY&feature=related[/video]


Lecture 3

[video=youtube;Aj2to0Lfavg]http://www.youtube.com/watch?v=Aj2to0Lfavg&feature=related[/video]]]> <![CDATA[Zip code locator issues in php 2011]]> https://vuhelp.net/Thread-Zip-code-locator-issues-in-php-2011 Mon, 26 Sep 2011 04:18:37 -0400 Vuhelper]]> https://vuhelp.net/Thread-Zip-code-locator-issues-in-php-2011
Code:
// Go through and check all stores while ($row = mysql_fetch_assoc ($result)) { // Separate closest stores $distance = Dist ($row['lat'], $row['lon'], $zip['lat'], $zip['lon']); $preSpecialties = $row['specialties']; $preDoor=explode (';',$preSpecialties); $i=count($preDoor); for($n=0;$n<$i; $n++){ // Check if store is in radius if ($distance <= $r && $p == ($preDoor[1]) or ($preDoor[2]) ) { $stores[] = array ( 'name' => $row['name'], 'address' => $row['address'], 'state' => $row['state'], 'town' => $row['town'], 'postal' => $row['postal'], 'phone' => $row['phone'], 'hours' => $row['hours'], 'specialties' => $row['specialties'] ); } } } } else { $Errors = ($Errors) ? $Errors : '<p>Errors were found please try again!</p>'; }
]]>
Code:
// Go through and check all stores while ($row = mysql_fetch_assoc ($result)) { // Separate closest stores $distance = Dist ($row['lat'], $row['lon'], $zip['lat'], $zip['lon']); $preSpecialties = $row['specialties']; $preDoor=explode (';',$preSpecialties); $i=count($preDoor); for($n=0;$n<$i; $n++){ // Check if store is in radius if ($distance <= $r && $p == ($preDoor[1]) or ($preDoor[2]) ) { $stores[] = array ( 'name' => $row['name'], 'address' => $row['address'], 'state' => $row['state'], 'town' => $row['town'], 'postal' => $row['postal'], 'phone' => $row['phone'], 'hours' => $row['hours'], 'specialties' => $row['specialties'] ); } } } } else { $Errors = ($Errors) ? $Errors : '<p>Errors were found please try again!</p>'; }
]]> <![CDATA[checkbox and mysql in php 2011]]> https://vuhelp.net/Thread-checkbox-and-mysql-in-php-2011 Sun, 18 Sep 2011 05:16:13 -0400 Vuhelper]]> https://vuhelp.net/Thread-checkbox-and-mysql-in-php-2011
Code:
<input type="checkbox" name="yo[1]" value=1 <input type="checkbox" name="yo[2]" value=1 <input type="checkbox" name="yo[3]" value=1
[Image: php-mysql-logo-150x148.jpg]]]>
Code:
<input type="checkbox" name="yo[1]" value=1 <input type="checkbox" name="yo[2]" value=1 <input type="checkbox" name="yo[3]" value=1
[Image: php-mysql-logo-150x148.jpg]]]> <![CDATA[how can Animate your images in PHP 2011-12]]> https://vuhelp.net/Thread-how-can-Animate-your-images-in-PHP-2011-12 Mon, 12 Sep 2011 08:26:25 -0400 Vuhelper]]> https://vuhelp.net/Thread-how-can-Animate-your-images-in-PHP-2011-12 1. try to drag a image from the mouse on the page
2. make the image dissapear and a new image in the same location after say 15sec
3. give the images an angle by some degrees
4. select an image and get another image instead of that on the same area]]> 1. try to drag a image from the mouse on the page
2. make the image dissapear and a new image in the same location after say 15sec
3. give the images an angle by some degrees
4. select an image and get another image instead of that on the same area]]> <![CDATA[PHP Login page and MySql 2011]]> https://vuhelp.net/Thread-PHP-Login-page-and-MySql-2011 Mon, 12 Sep 2011 08:25:39 -0400 Vuhelper]]> https://vuhelp.net/Thread-PHP-Login-page-and-MySql-2011
Code:
<?php /* Login script example - displays a form for entering username and password - checks wheter username and password exist in database and match - if no match is found, clears the form and displays an error message - if exactly one match is found, redirects user to another page Tip: make page look nicer with some CSS For this login example you will need working database (mySql used here), and some test data as per instructions below (or you can use phpmyadmin or similar app) Test data (2 users): username 1: misterx password 1: secretpassword1 hashed password1: (d5f835dbe946b420e1dacde0558078b4eee36745) username 2: mistery password 2: secretpassword2 hashed password2: (fd021e83bf64b46a2a7b707441dd167bc43749d4) Prepare database 'mydatabase' with table 'user' and some test data 1. Use this or similar query to create database 'mydatabase' CREATE DATABASE `mydatabase` ; 2.create DB user named 'testdbuser' with password 'verysecretdbpassword' and granthim privileges CREATE USER 'testdbuser'@'%' IDENTIFIED BY 'verysecretdbpassword'; GRANT ALL PRIVILEGES ON * . * TO 'testdbuser'@'%' IDENTIFIED BY 'verysecretdbpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; 3. Use this or similar query to create table 'users' in database 'mydatabase' CREATE TABLE `mydatabase`.`users` ( `id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'ID (primary key)', `username` VARCHAR( 24 ) NOT NULL COMMENT 'Username (max 24 chars)', `hpassword` CHAR( 40 ) NOT NULL COMMENT 'sha1 hashed password' ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Users table'; 4. Use this query to insert above test data into the table 'users' INSERT INTO `users` (`id`, `username`, `hpassword`) VALUES (NULL , 'misterx', '298e6df75f76926af93925e7a34e060ea523a363'); INSERT INTO `users` (`id`, `username`, `hpassword`) VALUES (NULL , 'mistery', '05b68c5b67e2c7a95cc86e4ee26778e5d9c77c6c'); */ // start session session_start(); // set session variable that identifies valid user to 0 until user submits // valid username and passwordusername $_SESSION['valid_user'] = 0; // a variable that will hold error message if needed $msg = ''; // check wheter user has submitted a username and/or password if(isset($_POST['username']) or isset($_POST['password'])) { // if both username and password are submitted and not empty if(isset($_POST['username']) and !empty($_POST['username']) and isset($_POST['password']) and !empty($_POST['password'])) { // asign posted values to variables and trim possible spacess before and // after the strings $username = trim($_POST['username']); $password = trim($_POST['password']); // passwords stored in the users database are hashed with sha1 therefore // submited password has also be hashed so values can be compared $hpassword = sha1($password); // prepare database connection $conn = mysqli_connect('localhost', 'testdbuser', 'verysecretdbpassword', 'mydatabase') or die ('ERROR: Can not connect to the database!'); // prepare query to select a user with submitted username and hashed // submitted password (to check for the match) $query = "SELECT username, hpassword FROM users "; $query .= "WHERE username='$username' AND hpassword='$hpassword'"; // get the result of the query $res = mysqli_query($conn, $query); // if mysqli_query was successful and if one row was returned from query // we have a match, the username and password are OK // (if no rows returned username and password did not match, if more than // 1 row returned we have entered one user more times which is incorrect if($res and mysqli_num_rows($res) == 1) { // set session variable that identifies valid user to 1 $_SESSION['valid_user'] = 1; // redirect user to login_success.php page header("location:login_success.php"); //just in case anything goes wrong from here end the script die(); } // if no rows are returned username and password did not match // (or if more than 1 row returned we have entered one user many times // which is incorrect) else { // again set session variable that identifies valid user to 0 $_SESSION['valid_user'] = 0; // prepare error message $msg = 'Please enter correct username and password!'; } } // if only username or only password was submitted else { // again set session variable that identifies valid user to 0 $_SESSION['valid_user'] = 0; // prepare error message $msg = 'Please enter correct username and password!'; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3c.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <title>Login</title> </head> <body> <!-- Form will be submitted to itself --> <form action="#" method="post"> <p>Please login</p> <div class="login"><input name="username" type="text" id="username" /></div> <div class="login"><input name="password" type="password" id="password" /></div> <div class="login"><input type="submit" name="submit" value="Login"></div> <!-- Possible error messages will be displayed here --> <div class="error-message"><p><?php echo $msg ?></p></div> </form> </body> </html>
]]>
Code:
<?php /* Login script example - displays a form for entering username and password - checks wheter username and password exist in database and match - if no match is found, clears the form and displays an error message - if exactly one match is found, redirects user to another page Tip: make page look nicer with some CSS For this login example you will need working database (mySql used here), and some test data as per instructions below (or you can use phpmyadmin or similar app) Test data (2 users): username 1: misterx password 1: secretpassword1 hashed password1: (d5f835dbe946b420e1dacde0558078b4eee36745) username 2: mistery password 2: secretpassword2 hashed password2: (fd021e83bf64b46a2a7b707441dd167bc43749d4) Prepare database 'mydatabase' with table 'user' and some test data 1. Use this or similar query to create database 'mydatabase' CREATE DATABASE `mydatabase` ; 2.create DB user named 'testdbuser' with password 'verysecretdbpassword' and granthim privileges CREATE USER 'testdbuser'@'%' IDENTIFIED BY 'verysecretdbpassword'; GRANT ALL PRIVILEGES ON * . * TO 'testdbuser'@'%' IDENTIFIED BY 'verysecretdbpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; 3. Use this or similar query to create table 'users' in database 'mydatabase' CREATE TABLE `mydatabase`.`users` ( `id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'ID (primary key)', `username` VARCHAR( 24 ) NOT NULL COMMENT 'Username (max 24 chars)', `hpassword` CHAR( 40 ) NOT NULL COMMENT 'sha1 hashed password' ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Users table'; 4. Use this query to insert above test data into the table 'users' INSERT INTO `users` (`id`, `username`, `hpassword`) VALUES (NULL , 'misterx', '298e6df75f76926af93925e7a34e060ea523a363'); INSERT INTO `users` (`id`, `username`, `hpassword`) VALUES (NULL , 'mistery', '05b68c5b67e2c7a95cc86e4ee26778e5d9c77c6c'); */ // start session session_start(); // set session variable that identifies valid user to 0 until user submits // valid username and passwordusername $_SESSION['valid_user'] = 0; // a variable that will hold error message if needed $msg = ''; // check wheter user has submitted a username and/or password if(isset($_POST['username']) or isset($_POST['password'])) { // if both username and password are submitted and not empty if(isset($_POST['username']) and !empty($_POST['username']) and isset($_POST['password']) and !empty($_POST['password'])) { // asign posted values to variables and trim possible spacess before and // after the strings $username = trim($_POST['username']); $password = trim($_POST['password']); // passwords stored in the users database are hashed with sha1 therefore // submited password has also be hashed so values can be compared $hpassword = sha1($password); // prepare database connection $conn = mysqli_connect('localhost', 'testdbuser', 'verysecretdbpassword', 'mydatabase') or die ('ERROR: Can not connect to the database!'); // prepare query to select a user with submitted username and hashed // submitted password (to check for the match) $query = "SELECT username, hpassword FROM users "; $query .= "WHERE username='$username' AND hpassword='$hpassword'"; // get the result of the query $res = mysqli_query($conn, $query); // if mysqli_query was successful and if one row was returned from query // we have a match, the username and password are OK // (if no rows returned username and password did not match, if more than // 1 row returned we have entered one user more times which is incorrect if($res and mysqli_num_rows($res) == 1) { // set session variable that identifies valid user to 1 $_SESSION['valid_user'] = 1; // redirect user to login_success.php page header("location:login_success.php"); //just in case anything goes wrong from here end the script die(); } // if no rows are returned username and password did not match // (or if more than 1 row returned we have entered one user many times // which is incorrect) else { // again set session variable that identifies valid user to 0 $_SESSION['valid_user'] = 0; // prepare error message $msg = 'Please enter correct username and password!'; } } // if only username or only password was submitted else { // again set session variable that identifies valid user to 0 $_SESSION['valid_user'] = 0; // prepare error message $msg = 'Please enter correct username and password!'; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3c.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <title>Login</title> </head> <body> <!-- Form will be submitted to itself --> <form action="#" method="post"> <p>Please login</p> <div class="login"><input name="username" type="text" id="username" /></div> <div class="login"><input name="password" type="password" id="password" /></div> <div class="login"><input type="submit" name="submit" value="Login"></div> <!-- Possible error messages will be displayed here --> <div class="error-message"><p><?php echo $msg ?></p></div> </form> </body> </html>
]]> <![CDATA[Banner Exchange PHP PHP SCRIPTS]]> https://vuhelp.net/Thread-Banner-Exchange-PHP-PHP-SCRIPTS Sun, 11 Sep 2011 13:41:48 -0400 junaid_]]> https://vuhelp.net/Thread-Banner-Exchange-PHP-PHP-SCRIPTS <![CDATA[Radio button selection problem in php 2011-12]]> https://vuhelp.net/Thread-Radio-button-selection-problem-in-php-2011-12 Sat, 27 Aug 2011 07:05:07 -0400 Vuhelper]]> https://vuhelp.net/Thread-Radio-button-selection-problem-in-php-2011-12 Radio button selection problem in php 2011-12
.Hi guys, I have a problem on getting the selected radio button and save it in the database.

Code:
<div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer 3</li> </ul> </div> <div id="question2" style="display: none;"> <p>Question 2</p> <ul> <li><input type="radio" name="q1" value="1" id="ans2" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans2"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans2"/>Answer 3</li> </ul> </div> <div id="question3" style="display: none;"> <p>Question 3</p> <ul> <li><input type="radio" name="q1" value="1" id="ans3" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans3"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans3"/>Answer 3</li> </ul> </div> </div><!-- END OF CONTAIN
ER -->]]> Radio button selection problem in php 2011-12
.Hi guys, I have a problem on getting the selected radio button and save it in the database.

Code:
<div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer 3</li> </ul> </div> <div id="question2" style="display: none;"> <p>Question 2</p> <ul> <li><input type="radio" name="q1" value="1" id="ans2" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans2"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans2"/>Answer 3</li> </ul> </div> <div id="question3" style="display: none;"> <p>Question 3</p> <ul> <li><input type="radio" name="q1" value="1" id="ans3" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans3"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans3"/>Answer 3</li> </ul> </div> </div><!-- END OF CONTAIN
ER -->]]> <![CDATA[Moving to preg_replace() from eregi_replace() in php 2011]]> https://vuhelp.net/Thread-Moving-to-preg-replace-from-eregi-replace-in-php-2011 Sat, 23 Jul 2011 03:51:31 -0400 Vuhelper]]> https://vuhelp.net/Thread-Moving-to-preg-replace-from-eregi-replace-in-php-2011 Moving to preg_replace() from eregi_replace() in php 2011

Code:
$bodytag = '%%BODY%%'; $header = eregi_replace($bodytag . '.*', '', $temp); $footer = eregi_replace('.*' . $bodytag, '', $temp);
]]> Moving to preg_replace() from eregi_replace() in php 2011

Code:
$bodytag = '%%BODY%%'; $header = eregi_replace($bodytag . '.*', '', $temp); $footer = eregi_replace('.*' . $bodytag, '', $temp);
]]> <![CDATA[Upload Variables not getting passed in php 2011]]> https://vuhelp.net/Thread-Upload-Variables-not-getting-passed-in-php-2011 Sat, 23 Jul 2011 03:50:37 -0400 Vuhelper]]> https://vuhelp.net/Thread-Upload-Variables-not-getting-passed-in-php-2011 Upload Variables not getting passed in php 2011

Code:
<form enctype='multipart/form-data' action='Upload_File.php' method='POST'> Please choose a file: <input name='myfile' type='file' /><br /> <input type='submit' name='submit' value='Upload' /> </form>
]]> Upload Variables not getting passed in php 2011

Code:
<form enctype='multipart/form-data' action='Upload_File.php' method='POST'> Please choose a file: <input name='myfile' type='file' /><br /> <input type='submit' name='submit' value='Upload' /> </form>
]]> <![CDATA[send sms from mysql query php??]]> https://vuhelp.net/Thread-send-sms-from-mysql-query-php Sat, 23 Jul 2011 03:49:27 -0400 Vuhelper]]> https://vuhelp.net/Thread-send-sms-from-mysql-query-php
[Image: sms-bet-specify-parameters-for-mysql-function10.gif]]]>
[Image: sms-bet-specify-parameters-for-mysql-function10.gif]]]> <![CDATA[PHP include instead of iFrame 2011]]> https://vuhelp.net/Thread-PHP-include-instead-of-iFrame-2011 Fri, 22 Jul 2011 06:44:12 -0400 Vuhelper]]> https://vuhelp.net/Thread-PHP-include-instead-of-iFrame-2011 PHP include instead of iFrame


Code:
<?php include "Shopping-cart-url.html"; ?>
]]> PHP include instead of iFrame


Code:
<?php include "Shopping-cart-url.html"; ?>
]]> <![CDATA[SESSION() and goto support in php 2011]]> https://vuhelp.net/Thread-SESSION-and-goto-support-in-php-2011 Fri, 22 Jul 2011 06:42:33 -0400 Vuhelper]]> https://vuhelp.net/Thread-SESSION-and-goto-support-in-php-2011 SESSION() and goto support in php 2011 ]]> SESSION() and goto support in php 2011 ]]> <![CDATA[Variables in function names in php 2011]]> https://vuhelp.net/Thread-Variables-in-function-names-in-php-2011--6141 Fri, 22 Jul 2011 06:41:43 -0400 Vuhelper]]> https://vuhelp.net/Thread-Variables-in-function-names-in-php-2011--6141 Variables in function names in php 2011

Code:
[B] Function $variable () { function code here }[/B]
]]> Variables in function names in php 2011

Code:
[B] Function $variable () { function code here }[/B]
]]> <![CDATA[Difference between mysql and mysqli 2011]]> https://vuhelp.net/Thread-Difference-between-mysql-and-mysqli-2011 Fri, 22 Jul 2011 06:40:54 -0400 Vuhelper]]> https://vuhelp.net/Thread-Difference-between-mysql-and-mysqli-2011 Difference between mysql and mysqli 2011]]> Difference between mysql and mysqli 2011]]>