39,320 Topics
 | |
| | In this pseudo example I have a table called **carsales** which contains 2 columns called **date** and **make** Every time a salesperson sells a car they enter the date in the **date** column and model of the car for example Ford, Honda, Audi in the **make** column. The required output … |
 | hi i have a script created for me and im attempting to add user_id so it it gets the userid from the users table so far i have done CREATE TABLE IF NOT EXISTS `checkbox` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(50) NOT NULL, `male` varchar(10) COLLATE utf8_unicode_ci NOT … |
| | Ok so im looking to create a simple booking system as part of my Final Year Project. I have a locally hosted mySQL database created and linked to using php. I have created a databse called reservations with 3 tablels (Available, reserves and confirms). Basically what I am looking to … |
 | 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 … |
| | Please help me how to do click button to display select box. at the same time add and remove select box  |
| | Please how do I reload a PHP function in a div using jquery? Any idea? |
| | So I have my PHP code here: $r = new HttpRequest('https://api.worldoftanks.com/wot/auth/login/', HttpRequest::METH_POST); $r->addPostFields(array('application_id' => 'e991ff783ae65f1ceefd1036211e5772', 'redirect_uri' => 'http://www.wotclanbuilder.com', 'nofollow' => 1)); try{ $result = $r->send()->getBody(); $json = json_decode($result); $url = json_encode($json->data->location); echo $url; } catch (HttpException $ex) { echo $ex; } and my Ajax code here: // AJAX Code To … |
 | 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 … |
 | Hi, Everyone, I am trying to add a php variable to my form input action. When I click the button to submit the form, the php var is not being added to the action url. I have tried using ".." / '..' to try to add the php var to … |
| | Hello, I keep having this error whenever I try to post a reply on my forum website. Here is my code: <?php session_start(); include ('dbconn.php'); $comment = nl2br(addslashes($_POST['comment'])); $cid = $_GET['cid']; $scid = $_GET['scid']; $tid = $_GET['tid']; $insert = mysqli_query($con, "INSERT INTO replies (`category_id`, `subcategory_id`, `topic_id`, `author`, `comment`, `date_posted`) VALUES …  |
 | i have an echo statement. which am looping columns. and i want to use this onerror command <img src="http://subinsb.com/to-an-image" onerror="this.src='img/delogo.jpg';"/> but not working. how do i do this. thanks echo ' <div class="col-lg-5 col-md-5 col-xs-12"> <h4 class="font_head_check">' . $title . '<span class="box_type_unik">For Sale</span></h4> <p class="font_check">' . $town . '</p> <span … |
| | ive just followed a tutorial where if a user chooses to delete there account and after i click delete account i get the following message Unable to delete user account! can someone check this out for me please delete.php <?php include ('dbconnect.php'); if (isset($_GET['del'])) { $user_id = $_GET['del']; $delete = … |
 | So this code below is part of a install file within a calendar script, when i try to upload the file it disappears. I have cut the code down to these lines that will not allow it upload. I can even just add these lines to a test.php file and … |
| | Hi , I need a calculation method to calculate multiple marks for an Individual students. Based on standard id and section id I showed list of students, and subjects dynamically, so that, for each student n number of subjects will display. When entering marks, for each student and for all …  |
| | Hi I am trying to send a reminder mail with the HTML Table format. But the details is not getting displayed. Please help me to fix. i am using class file to send the email. include ('config.php'); date_default_timezone_set('Asia/Calcutta'); require "classemail.php"; $mail = new EMail; $mail->Username = 'emailid'; $mail->Password = 'password'; … |
| | <script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"> </script> <script type="text/javascript"> var $k = jQuery.noConflict(); $k(function(){ $k("select[id^='tmp']").change(function(){ var geno3 =$k('#tmp').val(); if(geno3=='filename') { $k('#tmp1').attr("placeholder", "Ex: 'ICC8937_Read1.fastq.gz' etc"); } if(geno3=='runno') { $k('#tmp1').attr("placeholder", "Ex: '2,4' etc"); } if(geno3=='projectid') { $k('#tmp1').attr("placeholder", "Ex: 'ceg001,ceg002' etc"); } }); }); </script> Search the Database with any one of the following option: <form … |
| | I have a custom function called "query" with PDO statement in the functions.php file: /** * Executes SQL statement, possibly with parameters, returning * an array of all rows in result set or false on (non-fatal) error. */ function query(/* $sql [, ... ] */) { // SQL statement $sql … |
| | I have two table : buy_temp & buy_detail, i need transfer data from buy_temp to buy_detail . For the first step i will get data from buy_temp like this : $sid = $db->data("email", $user_session); $sql = mysql_query("SELECT * FROM buy_temp WHERE id_session='$sid'"); while ($r=mysql_fetch_array($sql)) { $cart[] = $r; } $j … |
| | I have been looking at this code and can't see the errors. I would like as a test for myself to post a SQL query to a PHP file and do the query and return the selected rows. So what is wrong with this POST, and how do I pickup … |
 | I have been working on a web application that requires a calendar that will display events along with information about them. I have been using the full calendar API to handle the calendar for me. But I whenever I have an event that spans across multiple days the calendar does … |
| | Hey everyone. I have a couple of questions related to PHP. I realized I need to learn how to code in baby steps until I get the gist of it. This is how I learn best, knowing every detail so I can break it down in my head. Which is … |
| | Hi all, I'm facing this error while following a tutorial. Warning: mysqli_result::fetch_array() expects parameter 1 to be integer, string given in C:\xampp\htdocs\client\login.php on line 12 [] Here is my php <?PHP include_once("connection.php"); if( isset($_GET['format']) && $_GET['format'] == "json" ) { $query = "SELECT * FROM tbl_client " ; $result = … |
| | hi im attempting to get all selected checkboxes to show in a database column. But ive tried adding a sql string for database to the code below to add the selected to database but nothing is coming up. where is it best to add the string <?php $aDoor = $_POST['formDoor']; …  |
| | Could you answer? I've a table in mysql database the structure is like: table name: img_tbl (id, image, size, format, etc..) image defined as blob datatype inside the table. i can retrieve single image from mysql database by using the following code. [CODE] $sql = "SELECT image,size,format FROM img_tbl"; // … |
| | hi all i have duplicated a script i had created and adapted it to something else i want and now im getting a Fatal error: Call to undefined function get_interests_data_from_post() in /home/jktempla/public_html/checkboxes/check.php on line 8 can someone help with this heres the coding for that section <?php include("connection.php"); $interests = … |
| | Hi In a form, I have two divs like in left and right but only one submit button . I don`t know how to save in submit action. Submit button has to come in center. Here I included my code . Check and tell me <form action="usersave.php"> <!-- class="form-horizontal form-label-left"--> … |
| | when ever i am inserting any of the symbols like cosec^2Ɵ (cosec power 2) it will display inline. i won't that to be displayed with raise to 2 or subscript or superscript of it. How to get Displayed that using utf-8 unicode characset ?  |
 | 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 … |
 | How I can send emails to gmail, yahoo, etc. from localhost. I am using XAMPP in windows. What are the necessary changes in php.ini ?? |
| | 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 … |
The End.