10,932 Topics
 | |
 | 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 … |
| | Hi, I would like to ask for help with regards on my problem on my phpmyadmin - mysql database. I am using wamp server 2.5. So here's the scenario, I try to insert data on two tables (accounts, user_info) on mysql @ phpmyadmin using php ajax. Now the problem is … |
 | Greetings I am looking for users idea approval and management system where user can register his self online and submit an idea/thought and it only reflects to his/her reporting manager to approve. if the manager approves then it will go to management. please help to create this in php & …  |
 | Hi I'm trying to update my DB table with below code.When I select all row or only 1st row its working fine, but when I select 2nd row or another row, its updating the 1st row value to my DB table. Please see & try to help me. update.php <table …  |
 | 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 … |
| | Hi i am having 3rd party csv file. i am having php uploading script to upload the datas into my table. while uploading datas into my mysql Table mean while it has to remove duplicate entries rows from CSV file. Please help me |
 | function total_price (){ $total = 0; global $db; $ip = getIp(); $sel_price = "select * from cart where ip_add='$ip'"; $run_price = mysqli_query($db,$sel_price); while ($p_price= mysqli_fetch_array($run_price)){ $product_id = $p_price['p_id']; $product_price = "select * from product where product_id='$product_id'"; $run_pro_price = mysqli_query($db,$product_price); while ($pp_price= mysqli_fetch_array($run_pr0-_price)){ $product_price = array($pp_price ['product_price']); $values = array_sum($product_price); $total … |
 | Select quray is working but delete query not working. <table border="1", align="center", width="98%", margin="auto", cellpadding="auto"> <caption><h2>View News</h2></caption> <tr> <th><input type="Submit" name="" value="Delete"></th> <th> S.No. </th> <th> Title</th> <th> Description</th> <th> Delete</th> <th> Edit</th> </tr> <?php $sel="select * from add_news"; $exe=mysql_query($sel); while ($fetch=mysql_fetch_array($exe)) { ?> <tr> <td><input type="checkbox" name=""></td> <td> <?php … |
 | Hello all, I am having a bit of an issue with a problem in my Web Dev Class. I am unable to get my "localhost" to pull up, it keeps giving me an error of; Parse error: syntax error, unexpected '<', expecting end of file in C:\xampp\htdocs\xampp\Chap19\Fig19_9.php on line 19. … |
 | |
 | how to upload and download the Folder zip file in php??? |
 | Whenever i execute this, only the last row of the loop gets inserted even if i click on the first row or any row. What i need is: if i click register, the entire selected row must store in another table Whats wrong here? Please help me.. <table class="table table-striped … |
 | hi frinds. hope you are well. as i writte this writting im thinking about a my [site](http://Iraniantranslate.com) .... how can i introduce my site to other people? and how can i popular it in google search? best regards, |
| | Hi, I have problem to count a multiple condition in one query. Usually i have to select count it one by one just like this : SELECT COUNT(kod_urusan) as num1 FROM customer_info WHERE kod_urusan = '0001' SELECT COUNT(kod_urusan) as num2 FROM customer_info WHERE kod_urusan = '0002' SELECT COUNT(kod_urusan) as num3 … |
| | I know how to do a fetch array to create a while loop as well as the mysql query in ASC order. What I'm trying to sort out is how I might be able to make it create the ASC order but to ignore the initial words "The" or "A" … |
 | I have done master master replication . I want to do multi master master replication. I research and found mostly master master replication in circular topology. But I want to do one supermaster who reads and update other masters. Is it possible? Is anybody did this? |
| | Hi I am new in PHP. I have used dropdown to bind with my sql data. It is ok But I could not insert data into table only from dropdown. Other controls like text can be inserted. I have given code below. Pls advise me. Maideen <?php require_once '../inc/header.php'; ?> … |
The End.