11,093 Topics
 | |
 | Hi all - also new to PHP/SQL and have a different question on a similar question posted - I need to create a page in php that allows the user to select a date range to and from. Howver, the date stored in the database is unix such as 1494548767 …  |
 | Drop down selection not showing up in MySQL. How do I get the selection from the MySQL-populated drop down list to be a value I can use when creating a new record? <?php include_once 'dbcon.php'; if(isset($_POST['save_mul'])) { $total = $_POST['total']; for($i=1; $i<=$total; $i++) { $sname = $_POST["sname$i"]; $sql="INSERT INTO users(speaker) …  |
 | i want to show my graph values but its show null output. i show you in image output also // JavaScript Document $(document).ready(function(){ $.ajax({ url: "data.php", method: "GET", success: function(data) { console.log(data); var playerid = []; var score = []; for(var i in data) { playerid.push("Player " + data[i].playerid); score.push(data[i].score); …  |
| | I'm trying to create an online learning courseware and connecting to MySQL database via PDO. What I'm trying to achieve is: if a user is logged in after registering for a particular course, the courseware should display the registered course, as well as its course weeks. I want each course …  |
 | 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 … |
 | I want to store multiple checkboxe values in my sql database. I am using jsp as front end.  |
| | I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( … |
 | Hi there, I would love to make a list and have a collection of database servers, could you all please help me? It would be nice if you could provide a link to their homepage. If you post, I will update the first post. [list] [*]MySQL ([url="http://www.mysql.org/"]http://www.MySQL.org/[/url]) [*]PostgreSQL [*]Access [*]MSSQL …  |
 | Hi Friends i am trying to isert this data to mysql database. However I cannot get this done because I do not know what is happening. I would appreciate any help. This is the code <!doctype html> <html> <head> <meta charset="utf-8"> <title>Untitled Document</title> </head> <body> <div id="wrapper"> <div class="box-header"> <h2>NEW …  |
| | hi everyone I am currently practicing my java skills by doing this program called car rental management system. I am creating a login page where when the user login it should bring up a dashboard. but the problems when the user login and it say "credentials match, the dashboard doesnt … |
 | Hai Sir, I am confused while creating Invoice system how to add the products item for Single invoice, and save it in MYSQL data base? Thanks and Regards, S. Hari ari |
 | Hello, When I try to import this sql into phpmyadmin I am getting this error message: Query SQL: CREATE TABLE `customers` ( `customerNumber` int(11) NOT NULL, `customerName` varchar(50) NOT NULL, `contactLastName` varchar(50) NOT NULL, `contactFirstName` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `addressLine1` varchar(50) NOT NULL, `addressLine2` varchar(50) DEFAULT NULL, … |
| | I'm creating an online learning courseware using PHP 5.5 and connecting via PDO. But I'm confused as to how to get the courseware to work, as I want. This is what I've done: I created a table for students and named it "users" and another for courses and named it … |
 | Hello, I'm not able to display the whole select result information in the table and I have no idea what I am doing wrong, I would appreciate your help so much. So here's my code: <?php $DBServer = 'localhost'; $DBUser = 'root'; $DBPass = ''; $DBName = 'world'; $conn = … |
 | Hi, i am working on program that connect to database, and user then cans see, edit, insert and delete data in mysql database. I have problem whit update query, can somone help me whit this. User need to click on cell and enter/change data, then hit enter to save changes. … |
 | I have two values in my code one is from a SQL Server query echo to the screen as formattedNum10d my second value is stored in a MySQL database and echo to the screen as formattedNum10f. In a seperate column i would like to subtract foramattedNum10f from formattedNum10d and echo … |
 | <div class="content" style="margin-left:17%;"> <div class="box box-warning" > <div class="box-header with-border" style="margin-left:20%;"> <h3 class="box-title">Add Package</h3> </div><!-- /.box-header --> <div class="box-body" style="margin-left:9%;"> <div class="row"> <div class="col-md-10" > <form action="" method="post" accept-charset="utf-8"> <div class="row" > <div class="col-md-6"> <div class="form-group"> <label for="varchar">Name </label> <input type="text" class="form-control" name="name" id="name" placeholder="Name" value=""> </div> </div> <div class="col-md-6"> …  |
 | **how to automatically sum the scores that is being inputted in the textbox and display to the specific rows of textbox** > this is my code for inputting score while ($students = mysql_fetch_array($result)) { $total = $students['fld_quiz1'] + $students['fld_quiz2'] + $students['fld_quiz3'] + $students['fld_quiz4'] + $students['fld_quiz5']; echo '<tr>'; echo "<td>{$students['id']}<input type='hidden' …  |
 | Hello Guys, So im a student at 12 grade and im trying to build a website from scratch and i've been successfull until now, i've been stuck in this error for 2 or 3 days, i cant send the text area + other input to database at the same type … |
 | hi, i am new to php. I am trying to fetch the image stored in database by using mysqli but couldnt fetch it. Please help me with this. Please find the code and let me know where i am lacking... <?php $link = mysqli_connect('localhost','root','','db_image') or die(mysqli_connect_error()); if(isset($_POST['btn_submit'])){ extract($_POST); $file_name=$_FILES["image"]["name"]; $file_tmp=$_FILES["image"]["tmp_name"]; … |
| | 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 … |
 | All information related upcoming ERP Cloud systems by Oracle |
 | Hello, how to make a button for change image and upload image with database. Please help me <!DOCTYPE html> <html> <head> <div class="profile_info"> <img src="images/user_profile.png" > <div> <?php if (isset($_SESSION['user'])) : ?> <div class="box-body no-padding"> <font size="6%" face="Comic Sans MS"> <strong><?php echo $_SESSION['user']['username']; ?></strong> <i style="color: #00f7fc;">(<?php echo ucfirst($_SESSION['user']['user_type']); ?>)</i></div></font> …  |
 | Can u tell me how toset a reminder in a calendar and it should show out as a popup notification two hours before the event to occur. |
 | hi, Am a newbie in php,i want to set a countdown timer for online quiz in php. when an student login,there wil be a home page and in home page there are two php pages like quiz.php and result.php, So When the studuent selects quiz.php,he will be redirected to quiz.php … |
 | Hi, I don't know if this is possible or a really stupid question. I was wondering if after a select query has been executed can the results be filtered for specific values, and not just a single value but 7 different values. with what i want to accomplish its either … |
| | Hello, I have a products page which lists the pics of the products. I added pagination with bootstrap classes. I have 10 products in my database. I want to limit per page to display only 6 so then the second page should display 4. The issue im facing now is … |
 | Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion Here is my simple code. // db.php code _______________________ <?php //$con = mysqli_connect("localhost","root","","bakery"); $db = mysqli_connect('localhost', 'root', '', 'bakery'); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . … |
 | We have built a software web-portal (POS system) in PHP language. Which is working fine when online. But when the internet goes down in the stores, the software stops completely and the managers are not able to make bills till the time internet is live again! Hence we want to …  |
| | > this is php code for get value while ($row = $activeRiders->fetch(PDO::FETCH_ASSOC)){ $rider_name = $row['RiderName']; $longitude = $row['CurrentLongitude']; $latitude = $row['CurrentLatitude']; $locations[]=array( $rider_name, $latitude, $longitude ); } $markers = json_encode( $locations ); > Jquery function $(document).ready(function() { $('#map').height($('.page-container').height()); $( window ).resize(function() { $('#map').height($('.page-container').height()); }); <?php echo "var markers=$markers;\n"; ?> > … |
| | Hi, I'm trying to create and save breadcrumbs from recursive function. I manage to display hierarchical tree using recursive function. but I'm I am having hard time creating breadcrumb and save them one by one to my database. here is my table cat_id parent_id title 10 0 shoes 11 0 … |
| | So I have website listing characters from a multi person RP I take part in the site uses bootstrap as well as a mysql database. I have a working search script to search teh database for a query and echo the results. I'm trying to figure out how to make … |
 | i need someone who can give me his email so i can send my timetable generator software that is given me errors. please anyone who can be of assistance, i will be grateful. |
| | I have a list.php which displays all the records that is in the database with 2 options Edit or Delete. When clicked its suppose to delete by id but instead it deleted everything. I'm not sure where i went wrong, please help. list.php <?php include "db.php"; try { $conn = … |
 | This problem's driving me crazy since yesterday. I have a table consist of 5 columns: kode_barang (item ID), nama_barang (name of item), qty (quantity), harga_beli (price), jumlah (total). User can input 2 items. This is the code of the form: <HTML> <?php include "koneksi.php"; ?> <form action="insert3.php" method="POST"> <table id="theTable" … |
 | 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 have 2 tables; first table Book, having book id and chapters. The second table points having studentid, bookid and hw-points for the students. I need to get results like below tabular format. Chapter 1 Chapter 2 Chapter 3 Book 1 sum of c1/B1 sum of c2/B1 sum of c2/B1 … |
| | How do i formatt the dates do the come out as DD/MM/YYYY please <?php $convar = mysqli_connect("localhost","root","","ffp_calendar"); if(mysqli_connect_errno()) { echo "Error occured while connecting with the database ".mysqli_connect_errno(); } $sqlvar = "SELECT * FROM `calendar` WHERE `CurrentDate` = curdate()"; $resultvar = mysqli_query($convar, $sqlvar) or die("Bad Query: $sql"); while($rowvar = mysqli_fetch_assoc($resultvar)) … |
 | is there anyway to stop sql injection while using mysql_connect and not using PDO or mysqli ?? |
| | Is the method in MySQL to set in SQL script dynamic log file name? e.g in Oracle PL/SQL set define on column sdate new_value sdate select to_char(sysdate,'YYYY.MM.DD_HH.MI') sdate from dual; spool 'logs/install_&sdate..log'; e.g. in PG/SQL \o ./logs/install_`date +"%Y-%m-%d_%H%M"`.log but I cant find similar in MySQL \T ?????? |
 | How does POS been coded? First, get orders then store it in a container like listview or datagridview Second save data from container to xml file then import data from xml to database.  |
 | //The php section of the code <?php function getJSONFromDB($sql){ $conn = mysqli_connect("localhost", "root", "","rent"); //echo $sql; $result = mysqli_query($conn, $sql)or die(mysqli_error()); $arr=array(); while($row = mysqli_fetch_assoc($result)) { $arr[]=$row; } return json_encode($arr); } $jsonData= getJSONFromDB("select Pic from Display"); $jsn=json_decode($jsonData); //for loop to retrieve rows from database for($i=0;$i<sizeof($jsn);$i++){ $a=$jsn[$i]->Pic; //here is the main … |
| | Hi. I'm retrieving a record and populating the data into input fields. there is a column called fld_order_date type timestamp. How do i retrieve the date? i have the usual retrieval: $stmt = $conn->prepare("SELECT * FROM tbl_orders_a154287 WHERE fld_order_id = :oid"); $stmt->bindParam(':oid', $oid, PDO::PARAM_STR); $oid = $_GET['edit']; $stmt->execute(); $editrow = … |
| | I keep getting this message. undefined reference to `mysql_get_client_info' From what I can figure out when I google it I am not linking correctly. So I tried this. gcc *.c -L"C:\Program Files\MySQL\MySQL Server 5.7\lib" Can I please get some help on what I am doing wrong? |
| | 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 …  |
| | Are there any good tutorials c programming with mysql? I only found one promising link, unfortunately they neglect to to show what is in their header files which doesn't help very much. http://zetcode.com/db/mysqlc/ |
| | Greetings! I am trying to connect my android application to a MySQL database. The app serves as a tool for lawyers providing them features such as: - a calendar wherein they can add and view events -an agenda list wherein they can see a list of their agendas -a notification … |
 | Here is a sample of my code where I retrieve a fingerprint template stored in mysql database. I have stored the fingerprint template as BLOB type. I have a table with two fields or columns, CaseFileNumber and FingerP. I have stored the fingerprint template in the FingerP column and also …  |
 | 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 … |
| | I'm developing some kind of web application simillar to forum. I want to show comments under which it belongs to. I currently used bootstrap, php, mysql for this. Here I post my code.... <div class="col-md-7"> <div class="col-md-12"> <form action="insert_post.php" method="post"> <div class="input-group"> <p><b>You Are Posting As : </b></p><h4><span class="label label-default"><?php … |
The End.