123 Topics
| |
Hi I have a problem with inserting into the database. This is my code : $insert = $db_con->query("INSERT INTO users (username,password,email,com-name,com-logo,com-phone,com-mobile) VALUES('".$username."','".$enc_pass."','".$email."','".$com_name."','".$profile_path."','".$com_phone."','".$com_mobile."')"); | |
Hello, i want to allow my users to reset their passwords if they forget it. My problem is that i lose the code sent to user via email, if this is the link sent to user via email http://localhost/citi/forgot.php?code=8b15388bc5ca7e2821ab6ce59b465f684942dd7901f4e31439575ab72028f84f , when the user get to forgot.php and type in the … | |
I have this form to send an email and the visitor can send an attachment with his email as will everything gos well the email sent but the attachment comes to the email like this if he uploaded any C.V the C.V will be attached to this Email --_1_c4fe3315ccb7d6076c71d64ec5265ecc Content-Type: … | |
Ok I researched EVERYWHERE on the Internet and I just can't get this to work. In my php.ini under my WAMP php folder, I have this (enabling the extensions): [CODE];extension=php_mssql.dll extension=php_mysql.dll extension=php_mysqli.dll ;extension=php_oci8.dll ;extension=php_oci8_11g.dll ;extension=php_openssl.dll[/CODE] Error: [CODE]Fatal error: Class 'mysqli' not found in C:\wamp\www\Elvonica\class\Database.php on line 11[/CODE] I have both … | |
Hey all, I am trying to update submissions from my SQL database from an edit page via an edit link in line with the submission which captures the ID of the database entry. When I click the edit link a new page opens and it has a form to update … | |
Here's how I'm thinking about inserting values into two tables. Each `reservation` will have a set of `services` the amount of which can vary, so I need to setup the query dynamically, here's my first sketch, although not tested yet. function saveBooking($fullBook) { $mysqli = new mysqli(HOST, USER, PASSWORD, DB_PRICE); … | |
Hi I am trying to convert the following mysql function to mysqli. Thanks in advance David <?php /*------------------------------------------------- This class contains generic database functions to view, add, edit and delete all facets of a database -------------------------------------------------*/ require_once ("sitesettings.php"); class Database extends SiteSettings { var $Query; var $Connection; function Database() { … | |
I have a code that i want to throw an error if there is no items to delete or if there is items it proceeds with deleting the items, here is what i have so far: if (isset($_REQUEST['removeall'])){ if($_REQUEST['removeall'] == 1){ mysqli_query($mysqli,"DELETE FROM assets WHERE cust_id = $custID AND del_flag … | |
I need to upload 5 images at ones with they labels I have made this before to upload many images at one it works fine but I need to have an label for each image how this can be done take a look at my code. this is the HTML … | |
Good Day Daniwebbers! Wonder if I can have some help. I am trying to build an 'admin panel' of sorts where the user can add content to their website, edit and delete it, all from one spot (Not unlike a CMS system I guess but purely for the purpose of … | |
<link rel="stylesheet" type="text/css" href="admin/css/style.css" /> <?php include('dbcon.php'); include('header.php'); ?> </head> <body> <div class="navbar navbar-fixed-top"> <div class="navbar-inner"> <div class="container"> <a class="brand"> <img src="admin/images/dee.png" width="150" height="50"> </a> <a class="brand"> <h2>UNITOUCH GLOBAL ONLINE E-VOTING</h2> <div class="chmsc_nav"><font size="4" color="white">Uniquely Touching The Universe</font></div> </a> <?php include('head.php'); ?> </div> </div> </div> <div class="wrapper_admin"> </br> </br> </br> … | |
I am not sure why this is not working, Its setting the flags perfectly but will not update events... if(isset($_REQUEST['del'])){ if($_REQUEST['del'] == 1){ $asset_id = $_REQUEST['assetID']; $sql = "UPDATE assets, events SET assets.del_flag=1 , events.del_flag=1 WHERE assets.id='$asset_id' AND events.asset_id='$asset_id'" or die(mysqli_error($mysqli)); if ( $mysqli->query($sql) ) { $addevent1 = "INSERT INTO … | |
Hi guys, I am trying to get the last_insert_id() from the table above, that way when it sends the query and is successful, it then updates the events table with timestamp, id , asset type and asset id from the insert code. I am currently using the max(id) but its … | |
I am trying to do a count of all types in there(hardware and software) I thought i had the correct structure...but I guess i am wrong... $count = mysqli_query($mysqli, "SELECT COUNT(*) AS total_count FROM assets WHERE cust_id=$custID AND (asset_type='hardware' AND asset_type='software') "); echo mysqli_error($mysqli); $count = mysqli_fetch_object($count); $count = $count->total_count; … | |
| While extending a mysqli class, I ran into an issue with binding parameters. I've read that db names and table names should not be used as parameters, but while I was pondering this statement... SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '$dbname' I thought, as the db name is a … |
Hi I'm working on a function and it was working good until I had an error that tells me I should swich from mysql to mysqli so I did swich but I'm having a lot of errors ! (the function is working fine but I have a lot of errors!). … | |
Below are 2 functions that will handle the Query and rending of the menu from MySQL Database. This function Loops through the array. Takes in 2 arguments. function loop_section($array, $parent_id = 0){ echo '<ul>'; foreach($array as $section){ echo '<li>'; echo $section->section_name; echo '</li>'; } echo '</ul>'; } This function handles … | |
The following snippet shows how you can use binding in your queries when using MySQLi. For starters, here's the table structure I've used: CREATE TABLE `mytable` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `dob` date DEFAULT NULL, `level` int(11) DEFAULT NULL, PRIMARY … | |
I have a login scrip (downloaded from the internet) that I have adapted to my database. I However have a problem with linking from the login to a page in my system with details of the user that has logged in. The users table on which the login system is … | |
Is the error i get trying to connect to my db. Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'http://www.fleethabari.com/' (1) in /home/www/fleethabari.com/inc/config.php on line 2 Unable to select database: Unknown MySQL server host 'http://www.fleethabari.com/' (1) Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /home/www/fleethabari.com/inc/config.php on line … | |
I'm testing my script in PHP 5.5, works perfectly until I switch from MySQL to MySQLi. Error: Stack trace: #0 C:\xampp\htdocs\url_rewrite.php(52): tep_db_fetch_array(NULL) #1 C:\xampp\htdocs\url_rewrite.php(106): transform_uri(Array) #2 [internal function]: wrap_href(Array) #3 C:\xampp\htdocs\url_rewrite.php(12): preg_replace_callback('/(<[Aa][ ???]{1...', 'wrap_href', '<!DOCTYPE html>...') #4 [internal function]: callback('<!DOCTYPE html>...', 9) #5 {main} Line 52 of url_rewrite: $cat_Q = … | |
I few weeks ago, I posted some code that I need help converting to MySQLi, now I need some help converting it to PDO. The code allows you to enter queries and commands and brings back the column headings and the information that I am looking for into a table. … | |
There has got to be a better way of doing this. First of all pay no attention to the lack of validation and error checking. I just want the core of the script to work first. Also, Block 1 and Block 2 execute, Block 3 does not. Whats the best … | |
Hello, there is a small php script that I am converting from using mysql to mysqli, but I am having a bit of an issue with mysqli_fetch_fields (this is where I assume the problem lies). Basically it is a form that allows someone to enter free form queries in order … | |
I'm totally new to php and learning. I have a table name *persons* which has columns * FirstName * LastName * Gender * Subject * Hobbies **The Task:** was to dynamically populate a drop down list with the data of FirstName, display the selected record of the name chosen in … | |
Hi all, I have a very simple question, for many of you.. I need to write out a select list like this : From table pages, I need id and link to fill up the options in my select list. But I need to tjeck in another table, if there … | |
I have tested out my procedure on my home machine. It woks pretty well I know there is output from the sql. Now I want to try it out on the host. It gives no output. Here is my php code $bob="call seeker($profound)"; if (mysqli_multi_query($conn,$bob)) { echo "<hr>"; echo "<table><th>Section</th><th>Author</th><th>Title</th>"; … | |
I would really like for someone to take a little time and look over my code. I'm parsing some news content and I can insert the initial parse into my database which contains the news URL and the title. I'd like to expand it farther, to pass along each article … | |
| Hi, I been learning **OOP** slowly. I'm stuck how to resolved an **function query() on a non object issue**. My files are very basic: This is my **db.php** file: <?php global $db; class foo_mysqli extends mysqli { public function __construct($host, $user, $pass, $db) { parent::__construct($host, $user, $pass, $db); if (mysqli_connect_error()) … |
i currently using mysql for database i want to use mysqli can any one tell me any other php server is required for it or i can use it in my bitnami wampstack 5.3.17.0 apache server. |
The End.