[mysqli] Forum Topics

Hiya, It seems to me that if I put a condition on ```` mysqli_stmt_fetch($stmt); ```` to check if user credentials was ok enough for the data to be fetched, then the whole purpose of using the following function is defeated. ```` password_verify() ```` This is what I mean .. ```` …

I need to check db for matching user credential on login script. There must be atleast one matching row. Else, script should alert user not registered. Need to check the db using the function ````mysqli_stmt_num_rows()````. Assignment is to list all the various valid ways this function can be used to …

Hiya, Which of these IF CONDITION codes are valid ? And can you rank the valid ones according to your choice by giving reasons to your choices ? Thanks! 1. ```` $conn = mysqli_connect("localhost","root","","buzz"); $sql = "INSERT into users (username,email) VALUES (?,?)"; if($stmt = mysqli_prepare($conn,$sql)) { mysqli_stmt_bind_param($stmt,"ss",$_POST[username'],$_POST['email']); if(!mysqli_stmt_execute($stmt)) //FIRST CHOICE …

Hi DW. I'm creating a chat system which will alow guests to send DMs to the operator and the operator can reply to it. I'm using MYSQL as my database, fingerprint2js for identifying the user since user has not yet logged in or registered but want to first communicate with …

Hi, My insert funcation is added below, as in php 5.6 i was able to post array data to database using below funcation but in php 7 it was not working i spend hours to find an solution but nothing is working. Insert funcation public function insert($table, $data) { $formattedVals …

hi all i have recently purchased a script and im attempting to fix it would anyone know how to solve these 2 errors which appear to be coming from this function [09-Jun-2018 12:40:57 UTC] PHP Warning: Division by zero in /home/public_html/includes/functions.php on line 126 [09-Jun-2018 12:41:19 UTC] PHP Fatal error: …

hi all im getting the following error PHP Notice: Array to string conversion in /home/public_html/includes/database.php(23) : eval()'d code on line 1 in this file <?php $link = @mysqli_connect($hostname, $username, $password, $database); if (!$link) { die('Could not connect !'); exit(); } else{ mysqli_set_charset($link,'utf8'); } $sqlcf = 'select Variable, Value from '.$table_prefix.'site_settings …

hi all im attempting to update coryApp script and im getting the following error PHP Warning: Division by zero can anyone help on this please be much appreicated heres is where the error is coming from if(isset($error) && !empty($error)) echo '<p style="margin:0px; padding:5px 20px"><font color="#FF0000"><small><i>'.$error.'</i></small></font></p>'; $config['showeachside'] = 4; $config['per_page'] = …

hi im working on a php script and i have come across the following error does anyone have a ideal what can cause this the error is: PHP Warning: count(): Parameter must be an array or an object that implements Countable in /home/letsswin/public_html/dating_V1/dating/admincp/educations.php on line 74. the code where it …

hi im attempting to update a php srcipt and fixing errors and i have a error in the following block but cannot work out where if($_SERVER['REQUEST_METHOD']=='POST' && isset($_POST['smcomplete'])){ if(empty($_POST['abouth'])) $err_h = $aboutherorhis; elseif(strlen($_POST['abouth'])<6) $err_h = $datashort; else{ ERROR ON THIS LINE>>> $match = ($_POST['matchsame']=='on')?1:0;slBodyType'], $_POST['slHeightfrom'], $_POST['slHeightt $data = array($_POST['rdgender'], $_POST['slagefrom'], …

Hi i have several user types i.e female, male couple etc and when they register each group goes to there own page for profile setup but when they login they go to one standard profile page that came with script how would i redirect them to there own profile page …

hi all im attempting to update some script and i have a undefined error in a page see coding for error $column = "select * "; $sql .= " from favorites where user_id = '".$_SESSION['userid']."' "; of which the information a want to echo shows up so when i put …

Before I get into the specific issues, I want to provide some other details: - Normally, I work on a live, paid server (even in dev); I realize that is not advised, but it is a bad habit I developed over the years. I've tried using Xammp, but do not …

I've been reseraching the best way(s) to store both ipv4 & ipv6 ip addresses. Simply put, so far there seems to be much debate as to how to do so properly ranging from storing them as varchar or in a binary format. I'm really not sure at this point. I …

newbie here! I am working with a simple PHP form with few fields and few uploads. I want to use the Modal pop up form for this. Below codes are working fine. I was able to insert the fields into MYSQL successfully but I don't know how to add file …

hi i want to know how to delete duplicate rows in imported csv files in phpmyadmin in php..below is my code to import csv file in php,i want to delete duplicated rows in my imported csv files which is in database of xampp(phpmyadmin)can anyone add thecode for it <?php $user …

I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I …

I have a code that is working to show images and description. But I am trying to get it to loop through 3 pictures wide, then loop again. and display them, I am going to add pagination to the script, but before i do that i need it to loop. …

Hey everyone, I have a MYSQLI statement that i would like to add pagination to. I would like to have it set to 5 per page, and not have a negative value if you are on page 1 (disables back link) Every tutorial i have been seeing allows for a …

ive just done a simple register form where i can check username exists and before i put the username exists in the register works but when i have the username check in it doesnt work can someone check this over for me the script and error log are as follows: …

I have a code in two files and I want to convert it from mysql to mysqli. func.php: <?php $con = mysql_connect('*','*','*'); mysql_select_db("*",$con); function search_results($keywords){ $returned_results = array(); $where = ""; $keywords = preg_split('/[\s]+/',$keywords); $total_keywords = count($keywords); foreach ($keywords as $key => $keyword) { $keyword = strtolower($keyword); $where .= "LOWER(`keywords`) …

Guys, i am getting an unexpected T_While Error on my code, I cannot figure it out. can you help? ` <?php` $sql = "SELECT id, u_name, u_email, subj, phone FROM tb_cform "; $result = $conn->query($sql); echo '<table><tr><th>Name</th><th>Email</th><th>Subjec</th><th>Phone</th></tr>'; if ($result->num_rows > 0) {     while($row = $result->fetch_assoc()) {         echo "<tr><td>".$row["u_name"]."</td><td>".$row["u_email"]."</td><td>".$row["subj"]."</td><td>".$row["phone"]."</td></tr>"; …

hi ive got a html table echoing through php and im having problems displaying image in the table heres what i have so far if($fetch_image['user_image']!='') { echo '<td>'.$fetch_image['user_image'].'</td>'; } else { echo '<td>'.<img src='images/blank_big.jpg' height='150px;' width='150px;' />.'</td>'; } and here is the fetch section $user_image = mysqli_query($conn,"select * from user_images …

good got job nearly finished but one slight glitch i have 2 entries in database but only one is showing twice in table results how can i get to show both results heres code fetch and connection block <?php include("config/db_connect.php"); //include("config/ckh_session.php"); $sql = "SELECT * FROM meets"; $result = mysqli_query($conn, …

SO Basically i have this problem with this test build of a little project im rewriting and so far its not looking to good I have multiple tables that are all the same, they have been set up this way for simplicity as far as i can tell. Tables +----+----------+-----------------+---------------+-------------------+ …

I want to collect basic user information when they land on an index page, such as: IP Country City State Zip Code I've looked into sites such as ipinfo.io that offer a service regarding these details, but think it may be easier to collect the same info via PHP. From …

Hello, Recently I am dealing with bad performance in an php application that I have build, googling this issue I found out that using services like memcached you can archive a huge performance improvements. The weird thing comes when I try to find a very good and detailed example I …

Hi, I am looking to create a MySQLi class(MVC pattern), I already have the following functions: Query, Execute, Results. Below is a PDO version of a Bind statement and was wondering if you could do the following in MySQLi or something similar in MySQLi: public function bind($param, $value, $type=''){ if(is_null($type)){ …

Any ideas why this is not actuall writing to the database <form method="post" action=""> <p>&nbsp;</p> <table width="300" border="0" align="center" cellpadding="0" cellspacing="10"> <tr> <td width="100" align="right"> Film Title : </td> <td><input type="text" name="Film_Title"></td> </tr> <tr> <td width="100" align="right"> Film Format : </td> <td> <select name="Format_ID"> <option>- Select Film Format -</option> <option …