Member Avatar
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 …
by TheFearful in Programming ()
Member Avatar
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`, …
by Stefan_1 -3 in Web Development ()
Member Avatar
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 …
by janicemurby in Programming ()
Member Avatar
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 …
by janicemurby in Web Development ()
Member Avatar
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 …
by Stefan_1 -3 in Web Development ()
Member Avatar
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 …
by latrellvie in Web Development ()
Member Avatar
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 …
by janicemurby in Web Development ()
Member Avatar
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 …
by janicemurby in Web Development ()
Member Avatar
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 …
by janicemurby in Web Development ()
Member Avatar
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 …
by janicemurby in Web Development ()
Member Avatar
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 = …
by janicemurby in Databases ()
Member Avatar
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 …
by Abbas Ansari in Web Development ()
Member Avatar
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 …
by janicemurby in Web Development ()
Member Avatar
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??
by shashigowda in Databases ()
Member Avatar
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 …
by klaus.veliu in Web Development ()
Member Avatar
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 …
by lewashby 14 in Web Development ()
Member Avatar
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)) { …
by SimonIoa 39 in Web Development ()
Member Avatar
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 …
by mattyd 89 in Databases ()
Member Avatar
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 …
by mattyd 89 in Databases ()
Member Avatar
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> …
by spud91 in Web Development ()
Member Avatar
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 …
by accra 1 in Web Development ()
Member Avatar
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(); …
by johnef_sh in Web Development ()
Member Avatar
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 …
by learner001 in Web Development ()
Member Avatar
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 …
by johnef_sh in Web Development ()
Member Avatar
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 …
by johnef_sh in Web Development ()
Member Avatar
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 …
by scaiferw 15 in Web Development ()
Member Avatar
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 …
by accra 1 in Web Development ()
Member Avatar
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; …
by accra 1 in Web Development ()
Member Avatar
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 …
by johnef_sh in Web Development ()
Member Avatar
Is there another function for creating php sockets apart from this socket_create(AF_INET, SOCK_STREAM, SOL_TCP); ? Really need to know, thanks.
by accra 1 in Web Development ()