11,093 Topics
 | |
 | Hi Guys, Happy new year for everybody. Look i'm trying to achive a goal to load iframe on bootstrap modal dinamical. Like i just want the iframe src be called just when modal is opened. Because the src url is coming from database, and in some page there more than … |
| | Hi everyone, tried to display next and previous records from the coding below but unable to do so.It suppose to display next records for the current user with the when user click "Next" but currently it doesn't display "Next" but only display "Random". When i clicked "Random", it displays next … |
 | Hello i want to make like button so i need to `INSERT`, `SELECT` and check does already exists the record i have this code: **likes.php** <?php require 'connect.php'; require 'core.php'; require_once 'functions.php'; $user = getUserData('users', 'UserUsername'); if(isset($_GET['type'], $_GET['id'])){ $type = $_GET['type']; $id = (int)$_GET['id']; switch($type) { case 'ticket': $sql = …  |
| | <h2><i>Top Rated</i></h2> <center> <table> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top"><img src="images/<?=$image->filename?>" width="70" /></td> <? endforeach ?> </tr> <? <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Score: <?=$image->score?></td> <? endforeach ?> </tr> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Performance: …  |
| | Impossible to paste code. Insert form not working, giving up |
 | 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 … |
 | Hello i want to create a script like this `$query=mysqli_query($this->db,"SELECT * FROM table WHERE to_user_id='$uid' ORDER BY id DESC")or die(mysqli_error($this->db));` but the to_user_id row has multiple values. (45,67,234) Lets say that one of them (45) is the $uid note: the $uid variable is called on a session file. Its the … |
| | Hi - I am very new to this. I have a joomla site where I am trying to get a date from a datepicker and display parts of my table using the date. Two major problems: Datepicker - for future. $dateSelected1 = $dateSelected . " 00:00:01"; $dateSelected2 = $dateSelected . …  |
| | How can i check if username and email exists i have this code but its only checking the email not the username... $sql = "SELECT `Email`, `UserUsername` FROM `users` WHERE `UserUsername`='".$user."' AND `Email`='".$email."'"; $result = $conn->query($sql); if($result->num_rows >= 1) { echo "Email or Username already exist, try something else."; } … |
 | Hello everyone, I want to build an advertising system like AdSense on my website. I want to count only clicks that are not from the same user. Because I don't want the user to click many times on the same ad and ruining the ad program. I was thinking of …  |
| | 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 im wondering what the difference between mysqli_escape_string and mysqli_real_escape_string as i have a error on mysqli_escape_string and when i go to google error im just getting results in with mysqli_real_escape_string  |
| | 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 … |
| | Step-by-step 1) I’ll continue from the previous post. You can download a project file from the previous post at here – SampleMySQL (zip format). The project was created on Microsoft Visual Studio 2005. 2) Open the Design view of Form1. 3)Drag DataGridView tool from the Toolbox window to empty area …  |
| | My website show below error. Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET/@@@@@@.net/ Reason: Error reading from remote server Apache/2.2.15 (CentOS) Server at hostgator.com Port 443 Response from Hostgator: The site is currently expericing MySQL timeout … |
 | please i want to reduce the size of images when i am rendering it on my site. my site is very slow now. i want to accept any size now but when rendering please i want to reduce the size. thanks in advance  |
| | i am using password_hash() and password_verify() for hashing passwords but passwords_verify() returns false.This is my code <?php /** * . * * @author Anmol Raghuvanshi <ershadow786@gmail.com> * @license * @copyright */ class User_admin { private $db; function __construct($DB_con) { $this->db = $DB_con; } public function register($fname,$lname,$umail,$upass,$mobile,$address) { var_dump($upass); try { … |
| | 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 = … |
| | Hy there! I have a strange error to my prestashop. If I deactivate the module block contact without container the whole theme for mobile is ruined....Please see photo https://www.dropbox.com/s/1pst1w9ivuw4v3a/2016_01_03_12.25.10.png?dl=0 The error appears only to mobile and tablets. For desktop everything is okay. The same problem I get if I activate … |
| | Here is the deal, working on a card game using php mysql, I have a very simple way of shuffling the deck and I use array_chunk() to divide the deck into hands, the number of cards in each hand is variable depending of the numbers of players, there is also … |
| | pls i have a syntax error here... i have syntax error in line2 .... <?php mysql_query("insert into $s[pr]ad_type_google_dhtml VALUES (5, 'var dhtmlwindow={\r\najaxbustcache: true, //Bust caching when fetching a file via Ajax?\r\nminimizeorder: 0,\r\ntobjects: [], //object to contain references to dhtml window divs, for cleanup purposes\r\ninit:function(t){\r\n var domwindow=document.createElement(\"div\") //create dhtml window div\r\n … |
| | Hi, I am new to framwork, Now I started to learn Codeigniter. I have installed version of CodeIgniter 2.2.6, from the following link https://codeigniter.com/download I want to do a simple registration form with image upload , storing that image in a seperate folder, image name in to database, and with … |
| | Hi everyone, tried to display next and previous records using Next and Previous buttons but unable to do so. The record displayed is the current record whenever i click the Next or Previous buttons ie it doesn't move to the next or previous records. Below is the coding. Please advise. … |
| | I want to show all data of the page in pdf but i have no idea how to do this . I am using php .Please help me to solve that problem. |
| | i have following code first insert is working properly and data in to database but second insert query which depends on last_insert_id() fails.I have tried to find out mistake but failed to do so? <?php namespace Solutions\File; class AddUserData { function __construct($DB_con) { $this->db = $DB_con; } public function insert_detail($productDetails){ … |
| | I use this code to find time difference, alert(( new Date("1970-1-1 12:42 ") - new Date("1970-1-1 9:42") ) / 1000 / 60 / 60 ); it works in chrome, but in firefox it shows NaN error. How to solve this? |
| | Hi all, I have two tables. - Cart (cartId, prodId, etc) - Codes (Id, cartId, Code) Each line in the **Cart table** has a code from the **Codes table**. Because of an error, we now have 20 cart rows (But another time around it could be 1000 rows, so manually … |
| | this is my code $sql = "SELECT * FROM `sale_history` WHERE `date` BETWEEN :fromdate AND :todate"; $stmt = $PDO->prepare($sql); $stmt->bindParam(':fromdate', $_POST['fromdate'], PDO::PARAM_STR); $stmt->bindParam(':todate', $_POST['todate'], PDO::PARAM_STR); $stmt->execute(); $total = $stmt->rowCount(); while ($row = $stmt->fetchObject()) { echo "$row->date"; echo "$row->product"; echo "$row->username"; echo "$row->quantity"; } but its not working, where is the … |
| | HI, In a page I load table in while loop with time duration calculation for multiple times. I want to display time difference in their respective rows. Here I included my code. <?php $a = mysql_query("SELECT * FROM user")or die(mysql_error()); $a_count = mysql_num_rows($a); if($a_count > 0) { ?> <table border="1" … |
| | I have a strange problem here is code snippet for form having bootstrap tab when after filling all form fields i submit the form no error or form fileds are posted,there is something wrong with my html however my validations and other backend code is working for other form but … |
| | When I login same script works for first user but for other user, it gives error in connection. More over i want to fetch data from database Main File is <?php include_once("../init.php"); validation_check($_SESSION['SID'],MEM_HOME_ADMIN); $msg=''; $dir ='../'.USER_PIC; $sId = $_SESSION['SID']; $query = mysql_query("select * from user WHERE user = ".$sId) or … |
| | Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in … |
 | I received a database I need to restore on my local machine. The database is MySQL off a Linux box, is it possible to mount these files similar to how you would a .mdb file on a MSSQL Server? I am looking to mount them on my Windows based version … |
| | I've asked the same Question here http://stackoverflow.com/questions/34422852/debug-assertion-failed-binary-search-tree > IM IN DESPERATE NEED OF HELP. Im working on a project, What I want is to get data from a database (MySql) and store it in a Tree. And be able to do insertion, deletion or updates on the nodes, if any … |
| | <?php if (isset ($_POST['submit'])) { try { $picture = "../images/default-picsss.png"; $sql = " INSERT INTO user (username, password, fullname, address, mobile, email, picture) VALUES (:username, :password, :fullname, :address, :mobile, :email, :picture ); INSERT INTO user_balance (username) VALUE (:username); "; $stmt = $PDO->prepare($sql); $stmt->bindParam(':username', $_POST['username'], PDO::PARAM_STR); $stmt->bindParam(':password', $_POST['password'], PDO::PARAM_STR); $stmt->bindParam(':fullname', $_POST['fullname'], … |
| | Hi, I am trying to load data from mysql to angular JS. the data is huge. i.e. 50000 records.I have also set SQL_BIG_SELECTS=1 before join query execution. But i am getting following error while calling this query. Error: Internal Server Error. |
| | I was trying and trying to get this to work as expected I got this chain drop down menu to work but the problem how can I edit or retrieve data to edit pls if you have time look at my script here on (MS oneDrive) https://onedrive.live.com/redir?resid=B6ED478A72FB6A78!33834&authkey=!AO9oNU_4snXOqH4&ithint=file%2czip the three drop … |
| | Hi, I need your help for forgot password decryption. When a user registers , his password will be encrypted using md5(); and When he sign in, I will encrypt his password using MD5() and I will compare it with value already stored in to table, My problem is, If he … |
| | my insert statement seems to be ignoring my unique index and adding duplicates what'd i mess up? thanks in advance Table CREATE TABLE `address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `address_street1` varchar(100) NOT NULL, `address_street2` varchar(100) DEFAULT NULL, `address_street3` varchar(100) DEFAULT NULL, `address_city` varchar(45) NOT NULL, `address_state` char(2) DEFAULT NULL, …  |
| | Hello. I have created a filter result using php but it is not properly working for me when i filter result it is not showing me up with any products <form method="POST" action="product.php?cat=<?php echo $cat; ?>"> <div class="price-box"> <h5>Price</h5> <input type="hidden" name='price_range' class="range-slider" min="0" max="600" value="23" /> </div> <div id="filters"> … |
| | Hi, How we can know , a user requested for forgot password? |
| | * <?php mysql_connect("localhost","root","") or die ("could not connect"); mysql_select_db("search_test") or die ("could not find db!"); //collect if(isset($_POST['search'])){ $searchq = $_POST['search']; $searchq = preg_replace("#[^0-9a-z]#i","",$searchq); $query = mysql_query("SELECT * FROM members WHERE firstname LIKE '%$searchq%' OR lastname LIKE '%$searchq%'") or die ("could not search!"); $count = mysql_num_rows($query); if ($count == 0 ) … |
| | I have a program that will connect to mysql server , now how to do for this work? What settings should I do on a mysql server? |
| | here is my sample code: addqtr.php <?php $quarter=$_POST['quarter']; $sql="Select * from $quarter where id=?"; $res=$db->prepare($sql); $res->execute(array($pqid)); while($rowadd = $res->fetch(PDO::FETCH_ASSOC)){ $num=$rowadd['id']; $pushup=$rowadd['pushup']; $situp=$rowadd['situp']; } ?> <form method="post" name="frmQuarter" action="saveqtr.php"> <input type="hidden" name="qid" value="<?php echo $pqid; ?>"/> <table> <tr> <td>Select Quarter</td><td>:</td> <td> <select id="quarter" name="quarter"> <option selected></option> <option value="1qtr">1st</option> <option value="2qtr">2nd</option> <option … |
| | I'm experiencing an issue deleting data via PHP/MySQL query. The following is the error message: Delete product category failed. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 This is … |
| | I want to add data entered from Java GUI into mysql database and inside actionlestener I am using the following code: String s1; JTextField enterdata = new JTextField(10); s1=enterdata.getText(); PreparedStatement ps = con.prepareStatement("INSERT INTO d (name) VALUES (?)"); ps.setString(1, s1); ps.executeUpdate(); 'name' is the column in database; i am having …  |
| | Hi guys. I have already installed fullcalendar successfully onto my webpage home.php <script type="text/javascript" src="js/fullcalendar.js"></script> <script type="text/javascript" src="js/fullcalendar.min.js"></script> <script> $(document).ready(function() { var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); $('#calendar').fullCalendar( { header: { left: 'prev,next today', center: 'title', right: 'month,basicWeek,basicDay' }, … |
 | Hi All, I want to know wheather I can update (add new data) to a row in mysql database table without replacing existings data. Ex : There is a row that contains, ID Name City Groups 1 John Colombo gamers I want to add 'programmers' to John's Groups. ID Name … |
| | i am trying to fetch only image from database.In database the table (post_content) have image along with description i only want image.is it possible?Keep in mind that $row['post_content'] has image and decription. <?php $sql = "select * from wp_tableposts;"; $res = mysql_query($sql); while ($row = mysql_fetch_array($res)) { echo'Post Contant:'. $row['post_content']. … |
The End.