123 Topics

Member Avatar for
Member Avatar for borobhaisab

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 .. ```` …

Member Avatar for FilipKappa
0
60
Member Avatar for borobhaisab

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 …

Member Avatar for Dani
0
42
Member Avatar for borobhaisab

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 …

Member Avatar for Dani
0
73
Member Avatar for Mr.M

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 …

Member Avatar for Biiim
0
122
Member Avatar for annya

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 …

Member Avatar for annya
0
65
Member Avatar for janicemurby

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: …

Member Avatar for rproffitt
0
308
Member Avatar for janicemurby

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 …

Member Avatar for alan.davies
0
3K
Member Avatar for janicemurby

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'] = …

Member Avatar for jstfsklh211
0
773
Member Avatar for janicemurby

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 …

Member Avatar for ryantroop
0
704
Member Avatar for janicemurby

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'], …

Member Avatar for janicemurby
0
291
Member Avatar for janicemurby

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 …

Member Avatar for broj1
0
210
Member Avatar for janicemurby

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 …

Member Avatar for rproffitt
0
452
Member Avatar for mattyd

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 …

Member Avatar for benanamen
0
635
Member Avatar for mattyd

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 …

Member Avatar for pty
0
6K
Member Avatar for borgyborg

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 …

Member Avatar for diafol
0
3K
Member Avatar for bhuvi_2

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 …

Member Avatar for cereal
0
338
Member Avatar for Magic8Computing

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 …

Member Avatar for diafol
0
1K
Member Avatar for Seef_1

I am using the following mysql query: CREATE TEMPORARY TABLE temp_table ENGINE=MyISAM AS (SELECT age, performance, wind,name,surname,dob,prov,pos,place,date, @curRank := IF(@prevRank = performance, @curRank, @incRank) AS rank, @incRank := @incRank + 1, @prevRank := performance, CONCAT(name,' ',surname) AS 'athlete' FROM results p, ( SELECT @curRank :=0, @prevRank := NULL, @incRank := …

Member Avatar for diafol
0
311
Member Avatar for patk570

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. …

Member Avatar for patk570
0
424
Member Avatar for patk570

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 …

Member Avatar for patk570
0
656
Member Avatar for janicemurby

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: …

Member Avatar for janicemurby
0
720
Member Avatar for Catchamouse

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`) …

Member Avatar for rproffitt
0
827
Member Avatar for patk570

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>"; …

Member Avatar for diafol
0
386
Member Avatar for janicemurby

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 …

Member Avatar for cereal
0
369
Member Avatar for janicemurby

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, …

Member Avatar for janicemurby
0
447
Member Avatar for berserk

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 +----+----------+-----------------+---------------+-------------------+ …

Member Avatar for Traevel
0
712
Member Avatar for mattyd

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 …

Member Avatar for Dani
0
436
Member Avatar for developer707

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 …

Member Avatar for Dani
0
641
Member Avatar for SunnySideUp

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)){ …

Member Avatar for Dani
0
383
Member Avatar for Magic8Computing

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 …

Member Avatar for Dani
0
312

The End.