10,940 Topics
 | |
| | Hey everyone, I have a question and I am not sure if it's possible or not to do it with what I'm using. I am using HTML, PHP, JavaScript, and mySQL to make a web page that pulls information from a Database. After that, I want to have a dropdown … |
| | I have a MySQL database which contains a text field which contains well formed xml. I want to export this data as an xml file named result_new.xml on the fly. I have made the tmp folder and have set the permissions on the folder to 0777. If I run this … |
| | `Inline Code Example Here`Hello friends, I am building a multidimensional array with the following code: `Inline Code Example Here` the example code is $Questions = array( 1 => array( 'Question' => 'CSS stands for', 'Answers' => array( 'A' => 'Computer Styled Sections', 'B' => 'Cascading Style Sheets', 'C' => 'Crazy … |
| | Hello everyone, I am learning PHP with mySQL and I want to know if it's possible for me to do a dynamic dropdown box(which I have) that will automatically fill in fields below it such as a textbox. If I select a userID from the dropdown, that selection will fill …  |
| | I have a mysql database that has previously stored the text of an xml file including tags. I want to select that data from the database and return it as an xml file rather than just text, (eg filename.xml). It is to be further processed with a javascript file which … |
| | My loader is not working while form submits, how to solve that?  |
 | # MySQL Stored Routines: Another Useful Scenario # [In a past guide](http://blog.bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you … |
| | <?php session_start(); $username=$_POST['username']; $password=$_POST['password']; if($username&&$password) { mysqli_select_db("user",$myconnection) or die("couldn't find db"); $sqlcommand="SELECT * FROM users where username='$username'"; $query= mysqli_query($myconnection,$sqlcommand); $numrows= mysqli_num_rows($query); if($numrows!==0) { while($row= mysqli_fetch_assoc($query)) { $dbusername=$row['username']; $dbpassword=$row['password']; } if($username==$dbusername&&md5($password)==$dbpassword) { echo "you are logged in!"; $_SESSION['username']=$username; } else echo"your password is incorrect!"; } else die("that user doesn't exits"); } … |
 | So I want to remove space between tags. The tags are seperated by comma. But I don't want to remove space between words just right after the commas. So this: cats, funny cats, cute cats, funny To this: cats,funny cats,cute cats,funny I want them ready for insertion into database. This … |
| | <?php session_start(); $username=$_POST['username']; $password=$_POST['password']; if($username&&$password) { mysqli_select_db("user",$myconnection) or die("couldn't find db"); $sqlcommand="SELECT * FROM users where username='$username'"; $query= mysqli_query($myconnection,$sqlcommand); $numrows= mysqli_num_rows($query); if($numrows!==0) { while($row= mysqli_fetch_assoc($query)) { $dbusername=$row['username']; $dbpassword=$row['password']; } if($username==$dbusername&&md5($password)==$dbpassword) { echo "you are logged in!"; $_SESSION['username']=$username; } else echo"your password is incorrect!"; } else die("that user doesn't exits"); } … |
| | Using PHP / MySql... I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID. I want / need to keep the recIDs filled with completed transactions without any skips in the ID … |
| | Hi iam working on one scenario.. employe A send a Requesting mail to Project manager B, project manager B approves a request from employee and send the mail to project manager C for further process,after approving from project manager C it will go to department head like this... so here … |
| | This is my code for a user login. It allows the user to login fine. What do i need to add to the code to allow admin users to be able to login and then be redirected to another page? In the database I have assigned 0 to the normal … |
| | Hi. I want to auto calculate some fields in database without any button submit but i'm only know how to calculate using button submit. I want that user enter the value then the user will get the calculate value automatically without click on button submit. I'm doing my final year … |
| | this is my login code which works fine when someone registers and then logs in. What im trying to do is allow access for certain users to different pages as they're classed as admin users. However the username and password for them will already be set and they dont need …  |
| | I'm trying to delete a database in phpMyAdmin which is in localhost of Windows 7 Professional 64bit system. Since I am not an IT or database professional, I'd appreaciate any help with non-techy steps. :-) When I attempt to delete the database I receive the error: DROP DATABASE 'enfold-2016' #1010 … |
| | html code: <tr> <td id="qn1" name="qn1">1</td> <td>Presentation of course overview and relevant references</td> <td> <select class="form-control" name="select"> <option value="very good">Very Good</option> <option value="good">Good</option> <option value="average">Average</option> <option value="poor">Poor</option> <option value="very poor">Very Poor</option> </select> </td> </tr> php code: <?php $servername = "localhost"; $username = "root"; $password =""; $dbname = "surveyproject"; //establish connection … |
| | Hello friends, I am having a confusion in my script please explain me what is it doing i don't know what it is i don't understand sessions very well, so please explain it if (isset($_SESSION['SBUser'])) { $user_id =*** $_SESSION['SBUser']***; $query = $db->query("SELECT * FROM users WHERE id = '$user_id'"); $user_data … |
| | PLEASE HOW DO I ADD EMAIL ADDRESS TO MY PHP TO ALLOW SUBMITTED FORM COME TO MY EMAIL? SEE CODE BELOW... $em = $_POST["em"]; $nm = $_POST["us"]; $cu = $_POST["ps"]; $sch = $_POST["nm"]; $sub = $_POST["sub"]; $CONNECT = mysql_connect ("localhost", "webkoko", "ment1$"); if(!($CONNECT)) {die ("error");}; mysql_select_db("webkoko"); $k2l = "insert into … |
| | [CODE]<? $conn = mysql_connect("localhost", "your_username","your_password") or die(mysql_error()); mysql_select_db('your_database', $conn) or die(mysql_error()); ?> [/CODE] this is the code i have on database.php, when i run register page i get a erro. [QUOTE]Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'your_username'@'localhost' (using password: YES) in /home/a4595523/public_html/database.php on line 2 Access denied for user … |
 | I've updated the attendance.sql and the attendance form (index.php) by adding the time in and time out of the attendance. The time in and time out values are still blank even it is assigned in the database. (Lines 65 - 66) And when I tried to update the values (e.g. … |
| | I've updated the attendance.sql and the attendance form (index.php), but when I tried to update the values (e.g. present and late), it cannot work. And also, the checkbox says it's all ticked even the values are different (lines 61 - 63 of index.php) Can help me? Download: https://drive.google.com/open?id=0B07_pOHhTox3bTN1Z21HRlR2TEE Inside there … |
| | Help me sir for this error, Connect Error (2002) No connection could be made because the target machine actively refused it. my connection //my database class class Db { // make sure we dont connnect database to every function public $mysql; function __construct(){ $this->mysql = new mysqli('10.100.2.234','sa','P@ssw0rd','PLAZATOYOTA_MSCRM'); if (mysqli_connect_error()) { … |
| | Hello guys i am doing a archived page and i have added option to restore all but after that every newly deleted product doesn't show up here's the script //php to get update data upon click of button <?php if (isset($_GET['all'])) { $allSql = "UPDATE products SET deleted = 0 … |
| | Hi, I'm quite new to PHP and MySQL and the attendance form (index.php) is messed up. Can help me? Download the attendance form system in zip file: https://drive.google.com/open?id=0B07_pOHhTox3RnM2bFRNczhOeDA Inside there is the database table called attendance.sql. You need xampp and you must import the table (attendance.spl) in phpmyadmin. |
| | Hello, I ask information to you that you are much more experienced than me that I am learning. I would like to create an administrative panel with the only possibility to be logged in to the admin. Your wisest thing which is to carry out safely login? Let me explain, … |
| | Hello there, I am trying to add more than 2 foreach statements. Please help me. My statement - foreach (array_combine($image, $name) as $pic => $title) { } It cant be like - foreach (array_combine($image, $page, $name) as $pic => $id => $title) { } |
| | Hi, Before i do the attendance form system, I have to do the student registration form. But there is one problem. I tested the student registration form (register.php) and tried to register myself to the database, but my data did not register to the database. I've done the coding correctly … |
| | Hi , I need your help to export data from mysql to Excel using PHP  |
| | see why is is not working its not taking combo name why |
The End.