[mysqli] Forum Topics

Hey everyone, I have a question about prepared statements for PHP and mySQL. I have been able to do them for a single row such as ID and such for a particular object, but is it possible to do a SELECT all command as well? I want to be able …

Here is the error it gives me Warning: mysqli::query(): Couldn't fetch mysqli in C:\xampp\htdocs\bootstrap\tickets_info.php on line 27 db problem. Warning: main(): Couldn't fetch mysqli in C:\xampp\htdocs\bootstrap\tickets_info.php on line 31 Fatal error: Wrong SQL: SELECT `Uplata`, `Dobivka`, `Date`, `sharedTime`, `match1`, `match2`, `match3`, `match4`, `match5`, `match6`, `match7`, `match8`, `match9`, `match10`, `match11`, `match12`, …

hi all im in the middle of following a tutorial online for a rating system and im encountering a problem when i click a number of 1/5 to rate a topic the rating is not going into the database can someone check the code to see what going off sql …

hya all i have sorted the checkbox group out and its echoing through ok but its also echoing through userid, username twice and email address when all i want is to echo options ticked any ideals of what can be causing this please php block at top of page: <?php …

Hello i want to make notification when new message is received, i have a row `seen` with values `0` and `1` if is 0 then its unread else is seen i got this code but when it displays the output shows the number of rows but for example i have …

My php file connnects to my sql database , following code works <?php $servername = "globalxxx.com.mysql"; $username = "globalxxx_com"; $password = "YS4xxx"; $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully" $sql = "SELECT Id, FirstName, LastName FROM …

i have followed a tutorial for a working checkbox group after failed attempts with others. On test file it was working but when i add it to my site i dont get any results after submitting form. First of all here is the file from tutorial. Sorry in advance for …

hi i have followed a online tutorial to replace photo system on my site and all went well till i attempt to upload photo i get no file selected even if i have just gone on the page but after pressing submit i get a success message and the photo …

hi i got another syntax error in a script that i am fixing to add onto my main site can someone take a look to see whats going off this error is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …

hi i managed to change my site from mysql to mysqli with all your help although i have one line thats causing me problems in inbox.php can someone check this out and see whats wrong the error im getting is Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given …

PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given on line 31 $insert = mysqli_query ($conn," insert into user set user_name = '".$_POST['uname']."' , age = '".$age."' , page = '".$page."' , user_password = '".$password."' , user_birthdate = '".$user_birthdate."' , puser_birthdate = '".$puser_birthdate."' , user_gender = '".$_POST['gender']."' , user_country = …

I'm trying hard with displaying details from a selected option in a drop down list for my project. I have a drop down list which is populated from a MYSQLi query. I want the user to select an option and the values associated pulled from the database and displayed to …

hi i have just picked up a script of the net for my site and when i uploaded in onto my site i get the following message: Warning: Cannot modify header information - headers already sent by (output started at /home/matureco/public_html/new/php/connection.php:4) in /home/matureco/public_html/new/php/session.php on line 19 ive tried different things …

Hii..this is mysql query $querry="SELECT CONCAT(`insert_id`, `type`) AS 'order_id' FROM orders WHERE email='$email'"; $order_id=mysql_query($querry); echo $order_id; i need to convert this into ** mysqli**. Any Help??

Hello to everyone, Currenty I have a php project that uploads files to the server and save some extra information into the database. My problem is that I want to make a feature that copies a folder structure with files included to a database. I am trying to copy the …

The program below is just a simple test to see if I can get it to fetch the correct data from MariaDB and then display it on the screen but so far I'm not having any luck. I left the action attribute's value blank because I want the PHP form …

I have a problem with mysqli syntax. I really can't see what the problem is in this code. I dont know much about it. When i use it on a function like this public function Somefunction() { $query=mysqli_query($this->db,"SELECT title,url,img FROM table WHERE status='1' ORDER BY id DESC")or die(mysqli_error($this->db)); while($row=mysqli_fetch_array($query,MYSQLI_ASSOC)) { …

I posted earlier today about converting my MySQL to MySQLi - Upon further research I came across the following, Prepared Statements. It seems that this may be a good way to go but I am a bit confused about how to implement it. I am simply taking User-entered data from …

Hello. I am beginning the process of coverting all of my MySQL to MySQLi. I have been doing much research on this but find it a bit confusing. I have two questions at this point regarding the matter: 1) What does it exactly mean to "escape" a string and where …

Hi guys! I have a database which holds a table called users. in there i have a balance column which contains a numeric value. I have the following code and for some reason it doesnt work: <?php session_start(); include_once("config.php"); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search</title> …

I have a gps sending data to mysql db, but am having hard time ploting the values on google map. My javascript skills are not very good, pls help... javascript code <?php $server = "localhost"; $username = "root"; $database = ""; $password = ""; $conn = mysql_connect($server,$username,$password); mysql_select_db($database) or die("Unable …

I am inserting answer of each of my questions I need to get the question id and inserted into the answer table see my code <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" id="quiz" class="container width_648"> <?php $getTheQuiz = $db->prepare("SELECT * FROM rec_employer_quiz WHERE ad_id=?"); $getTheQuiz->bind_param('i', $ad); if ($getTheQuiz->execute()) { $res = $getTheQuiz->get_result(); …

I have a form that has two parameters amenities and attributes. The amenities parameter has a dropdown menu that whose value gets populated from a separate table. The second parameter is attribute whose value will be entered by the user and will get saved in a database. View of database …

I am using PHPASS to store password encrypted and compare when login. here is the code ob_start(); $userName = $password = ""; $userNameErr = $passwordErr = $loginErr = ""; $hasher = new PasswordHash(8, false); if (isset($_POST['subEmployee'])) { if (empty($_POST['user_name'])) { $userNameErr = "User name is required"; } else { $userName …

I am try to figure out how to check current time against time in database and header the user to "expired page" if the current time is greater than the one in database "1 hour" $email = $token = $check_time = ""; $crossToken = $db->prepare("SELECT email, token, check_time FROM pw_reset_company …

I'm converting old MySQL code to MySQLi, and running into some questions. When selecting data from the database, is it necessary or strongly advised to use prepared statements, or can I safely escape my user-derived parameters like the sample below? In a perfect world I'd have all the time I …

Hi, am interfacing gps tracker TK106 with our online platform. The data we get from gps device is in this format (06667778889-9BP05000066677788899140815A0533.8206N00009.7045W000.0165936157.6200000000-L0000F51C) Instractions form [this site](http://sourceforge.net/p/opengts/patches/1/) explains the variours data sets in the string above, for example the first 11 digits 06667778889 is the device's programmable ID ,used in placed …

Hi, i found this code [online](http://www.macrostash.com/2011/09/17/demo-use-a-php-mysql-database-to-load-markers-on-a-google-map/#comment-2675). After installing and running code on my website, the screen shows nothing back, though code is firmly in place. <script type='text/javascript' src='jquery-1.6.2.min.js'></script> <script type='text/javascript' src='jquery-ui-1.8.14.custom.min.js'></script> <style> BODY {font-family : Verdana,Arial,Helvetica,sans-serif; color: #000000; font-size : 13px ; } #map_canvas { width:100%; height: 100%; z-index: 0; …

I want if the user clicks submit to return the the selected value when the form reloads that what I try and no luck <?php $getData = $db->prepare("SELECT * FROM first_university_degree_list"); if ($getData->execute()) { $res = $getData->get_result(); while ($data = $res->fetch_array()) { ?> <option value="<?php echo $data['univ_degree']; ?>" <?php if($FirstUniversityDegree …

Is there another function for creating php sockets apart from this socket_create(AF_INET, SOCK_STREAM, SOL_TCP); ? Really need to know, thanks.